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

Re: Connection Pools and DISCARD ALL

From: Neil Conway <neilc(at)samurai(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Connection Pools and DISCARD ALL
Date: 2007-10-04 20:03:22
Message-ID: 1191528202.6191.6.camel@dell.linuxdev.us.dell.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Thu, 2007-10-04 at 15:50 +0100, Simon Riggs wrote:
> On Thu, 2007-10-04 at 10:29 -0400, Tom Lane wrote:
> >  Somebody who wants the
> > above behavior can send "ROLLBACK; DISCARD ALL".
> 
> ...which generates an ERROR if no transaction is in progress and fills
> the log needlessly.

Well, it's a WARNING, but your point is taken. Can't a clueful interface
just check what the transaction status of the connection is, rather than
unconditionally issuing a ROLLBACK?

-Neil



In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-10-04 20:14:51
Subject: Re: Connection Pools and DISCARD ALL
Previous:From: Alvaro HerreraDate: 2007-10-04 19:33:35
Subject: Re: type money causes unrestorable dump

pgsql-patches by date

Next:From: Simon RiggsDate: 2007-10-04 20:14:51
Subject: Re: Connection Pools and DISCARD ALL
Previous:From: Tom LaneDate: 2007-10-04 19:26:53
Subject: Re: initdb of regression test failed.

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