What were you trying to do that didn't work?

Configure an database query like 

man pgsql_table 

recommends using the modern "postgresql:// connection URI". But when using the URI scheme, then the database name are an part of the URI. So the extra dbname parameter will not be needed and also not used. Here an working but strange example:

 hosts = postgresql://<USER>/<DATABASE>?host=/run/postgresql
 dbname = NoSuchDatabase
 query = <SQL query>

Please provide the package NVR for which bug is seen:

postfix-pgsql-3.5.9-24.el9.x86_64

How reproducible:

every time

Steps to reproduce

1.  create the query file using the URI scheme

hosts = postgresql://<USER>/<DATABASE>?host=/run/postgresql
query = <SQL query>

1.  use the query via 

    postmap -q info@example.com pgsql:/tmp/foo

Expected results

Working query

Actual results

Error:

 postmap: fatal: /tmp/foo: bad string length 0 < 1: dbname =