Thread: BUG #9087: Foreign data wrapper connection management issues

BUG #9087: Foreign data wrapper connection management issues

From
craigmluacs@gmail.com
Date:
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.

Re: BUG #9087: Foreign data wrapper connection management issues

From
Tom Lane
Date:
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