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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: craigmluacs(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9087: Foreign data wrapper connection management issues
Date: 2014-02-04 01:19:42
Message-ID: 28210.1391476782@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

craigmluacs(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Christian Kruse 2014-02-04 08:13:10 Re: BUG #9088: default are not working
Previous Message Patrick Lademan 2014-02-03 23:38:42 Re: BUG #9088: default are not working