[BUGS] BUG #14738: ALTER SERVER for foregin servers not working - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14738
Logged by:          Michal L
Email address:      fcs1@poczta.onet.pl
PostgreSQL version: 9.4.1
Operating system:   Windows 7 x64 Pro
Description:

Hello,

Command like this doesn't take effect:

ALTER SERVER srw_egib_1 OPTIONS (   SET host 'localhost',   SET port '5432',   SET dbname 'gml2m1');

It changes definition of this server but tables connected to it are still
connected to previous definition of this server, for example:

CREATE SERVER srw_egib_1 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (   host 'localhost',   port '5432',   dbname
'gml2');

It seams to take effect when I disconnect to the database and connect again.
I tested it on PgAdmin.

Regards
Michal


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs