On Sun, Nov 20, 2016 at 7:37 PM, Corey Huinker <corey.huin...@gmail.com> wrote: > I ran into this today: > > select current_database() as current_db \gset > CREATE EXTENSION postgres_fdw; > CREATE EXTENSION > CREATE EXTENSION dblink; > CREATE EXTENSION > CREATE ROLE bob LOGIN PASSWORD 'bob'; > CREATE ROLE > CREATE SERVER bob_srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS ( host > 'localhost', dbname :'current_db' ); > CREATE SERVER > CREATE USER MAPPING FOR public SERVER bob_srv OPTIONS ( user 'bob', password > 'bob' ); > CREATE USER MAPPING > SELECT * > FROM dblink('bob_srv','SELECT 1') as t(x integer); > x > --- > 1 > (1 row) > > ALTER SERVER bob_srv OPTIONS (updatable 'true'); > ALTER SERVER > SELECT * > FROM dblink('bob_srv','SELECT 1') as t(x integer); > psql:bug_example.sql:18: ERROR: could not establish connection > DETAIL: invalid connection option "updatable" > > > Is this something we want to fix?
Looks like a bug to me. > If so, are there any other fdw/server/user-mapping options that we don't > want to pass along to the connect string? InitPgFdwOptions has an array labeled as /* non-libpq FDW-specific FDW options */. Presumably all of those should be handled in a common way. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers