Skip site navigation (1) Skip section navigation (2)

Re: psql or pgbouncer bug?

From: Jakub Ouhrabka <kuba(at)comgate(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: psql or pgbouncer bug?
Date: 2010-05-24 07:52:14
Message-ID: 4BFA302E.8020802@comgate.cz (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-bugs by date

Next:From: Daniele VarrazzoDate: 2010-05-24 13:16:51
Subject: BUG #5469: regexp_matches() has poor behaviour and more poor documentation
Previous:From: Tom LaneDate: 2010-05-24 03:24:07
Subject: Re: ERROR: failed to build any 3-way joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group