BUG #9087: Foreign data wrapper connection management issues
The following bug has been logged on the website:
Bug reference: 9087
Logged by: Craig Lucas
Email address: craigmluacs@gmail.com
PostgreSQL version: 9.3.2
Operating system: Centos 6.4
Description:
When you create a foreign data table to a remote postgres instance and that
instance goes down or restarts, all subsequent queries on that foreign data
table fail until the foreign server is dropped and recreated.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
craigmluacs@gmail.com writes:
When you create a foreign data table to a remote postgres instance and that
instance goes down or restarts, all subsequent queries on that foreign data
table fail until the foreign server is dropped and recreated.
Hmmm ... actually, it's sufficient to restart your session. But I agree
postgres_fdw could do a little better here.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs