[BUGS] BUG #14738: ALTER SERVER for foregin servers not working

Поиск
Список
Период
Сортировка
От fcs1@poczta.onet.pl
Тема [BUGS] BUG #14738: ALTER SERVER for foregin servers not working
Дата
Msg-id 20170710113917.7727.10247@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14738: ALTER SERVER for foregin servers not working  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: jothiprasath216
Дата:
Сообщение: [BUGS] Re: BUG #14736: Crash on postgresql server by autovacuum workerprocess
Следующее
От: fbd@datasapiens.com
Дата:
Сообщение: [BUGS] BUG #14739: Wrong message when unique contraint fail