Postgres Pro
Downloads
Home   >   mailing lists

Re: Connection Pools and DISCARD ALL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Connection Pools and DISCARD ALL
Date
Msg-id 20312.1191508140@sss.pgh.pa.us
Whole thread Raw
In response to Connection Pools and DISCARD ALL  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Connection Pools and DISCARD ALL
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndquadrant.com> writes:
> As committed, DISCARD ALL does everything but cannot be issued inside a
> transaction block.

> I'd like to propose that DISCARD ALL also issue a ROLLBACK command if it
> is issued from within a transaction block.

That was *intentional* to prevent mistakes.  Somebody who wants the
above behavior can send "ROLLBACK; DISCARD ALL".
        regards, tom lane

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher
Next
From: Tom Lane
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher