On Wed, Jul 26, 2017 at 12:17 AM, Arseny Sher <a.s...@postgrespro.ru> wrote: > Hi, > > Is there any particular reason why postgres_fdw forbids usage of > connection strings by passing expand_dbname = false to > PQconnectdbParams? Attached patch shows where this happens. >
According to F.34.1.1 at [1] passing connection string as dbname option should work, so your question is valid. I am not aware of any discussion around this on hackers. Comments in connect_pg_server() don't help either. But I guess, we expect users to set up individual foreign server and user mapping options instead of putting those in a connection string. I can not think of any reason except that it improves readability. If postgres_fdw wants to take certain actions based on the values of individual options, having them separate is easier to handle than parsing them out of a connection string. Any way, if we are not going to change current behaviour, we should change the documentation and say that option dbname means "database name" and not a connection string. [1] https://www.postgresql.org/docs/10/static/postgres-fdw.html#idm44880567492496 -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers