Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, ashutosh(dot)bapat(at)enterprisedb(dot)com, pgsql-hackers(at)postgresql(dot)org, Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp, fcs1(at)poczta(dot)onet(dot)pl
Subject: Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING
Date: 2017-07-20 22:23:05
Message-ID: 20170720222305.ij3pk7qw5im3wozr@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Kyotaro HORIGUCHI wrote:

> Finally, I added a new TAP test library PsqlSession. It offers
> interactive psql sessions. Then added a simple test to
> postgres_fdw using it.

Hmm, I think this can be very useful for other things. Let's keep this
in mind to use in the future, even if we find another way to fix the
issue at hand. In fact, I had a problem a couple of weeks ago in which
I needed two concurrent sessions and one of them disconnected in the
middle of the test. Can't do that with isolationtester ...

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2017-07-21 05:25:51 Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING
Previous Message Tom Lane 2017-07-20 22:15:42 Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2017-07-20 22:40:43 Re: <> join selectivity estimate question
Previous Message Tom Lane 2017-07-20 22:15:42 Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING