[COMMITTERS] pgsql: Re-establish postgres_fdw connections after server or usermappi

Поиск
Список
Период
Сортировка
От Tom Lane
Тема [COMMITTERS] pgsql: Re-establish postgres_fdw connections after server or usermappi
Дата
Msg-id E1dYb9g-0004YP-68@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Re-establish postgres_fdw connections after server or user mapping changes.

Previously, postgres_fdw would keep on using an existing connection even
if the user did ALTER SERVER or ALTER USER MAPPING commands that should
affect connection parameters.  Teach it to watch for catcache invals
on these catalogs and re-establish connections when the relevant catalog
entries change.  Per bug #14738 from Michal Lis.

In passing, clean up some rather crufty decisions in commit ae9bfc5d6
about where fields of ConnCacheEntry should be reset.  We now reset
all the fields whenever we open a new connection.

Kyotaro Horiguchi, reviewed by Ashutosh Bapat and myself.
Back-patch to 9.3 where postgres_fdw appeared.

Discussion: https://postgr.es/m/20170710113917.7727.10247@wrigleys.postgresql.org

Branch
------
REL9_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/cb2b1cac0c331493dc3a316f92834bfad1b62149

Modified Files
--------------
contrib/postgres_fdw/connection.c              | 131 +++++++++++++++++++++----
contrib/postgres_fdw/expected/postgres_fdw.out |  37 +++++++
contrib/postgres_fdw/sql/postgres_fdw.sql      |  20 ++++
3 files changed, 170 insertions(+), 18 deletions(-)


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add a Gather executor node.
Следующее
От: Robert Haas
Дата:
Сообщение: [COMMITTERS] pgsql: pg_rewind: Fix busted sanity check.