Re: psql or pgbouncer bug? - Mailing list pgsql-bugs

From Jakub Ouhrabka
Subject Re: psql or pgbouncer bug?
Date
Msg-id 4BFA302E.8020802@comgate.cz
Whole thread Raw
In response to Re: psql or pgbouncer bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql or pgbouncer bug?  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: psql or pgbouncer bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: psql or pgbouncer bug?  (Tom Molesworth <tom@audioboundary.com>)
List pgsql-bugs
> The auto-reconnect behavior is long-established and desirable.  What's
 > not desirable is continuing with any statements remaining on the same
 > line, I think.  We need to flush the input buffer on reconnect.

So if I understand it correctly, if I need correct transaction behaviour
in psql even in case of disconnection the only safe way is to use one
statement per line.

Is this correct?

Thanks,

Kuba

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: failed to build any 3-way joins
Next
From: "Daniele Varrazzo"
Date:
Subject: BUG #5469: regexp_matches() has poor behaviour and more poor documentation