dblink get_connect_string() passes FDW option "updatable" to the connect string, connection fails. - Mailing list pgsql-hackers

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"

bug_example.sh:#!/bin/bash

dropdb bug_example

dropuser bob

createdb bug_example

psql bug_example -f bug_example.sql

\set ECHO all

select current_database() as current_db \gset

CREATE EXTENSION postgres_fdw;

CREATE EXTENSION dblink;

CREATE ROLE bob LOGIN PASSWORD 'bob';

CREATE SERVER bob_srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS ( host 'localhost', dbname :'current_db' );

CREATE USER MAPPING FOR public SERVER bob_srv OPTIONS ( user 'bob', password 'bob' );

SELECT *

FROM dblink('bob_srv','SELECT 1') as t(x integer);

ALTER SERVER bob_srv OPTIONS (updatable 'true');

SELECT *

FROM dblink('bob_srv','SELECT 1') as t(x integer);