Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

• Connection Pools and DISCARD ALL at 2007-10-04 14:11:22 from Simon Riggs

Responses

• Re: Connection Pools and DISCARD ALL at 2007-10-04 14:50:16 from Simon Riggs

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-10-04 14:43:16
	Subject: Re: First steps with 8.3 and autovacuum launcher
Previous:	From: Simon Riggs	Date: 2007-10-04 14:27:52
	Subject: Re: First steps with 8.3 and autovacuum launcher

pgsql-patches by date

Next:	From: Simon Riggs	Date: 2007-10-04 14:50:16
	Subject: Re: Connection Pools and DISCARD ALL
Previous:	From: Simon Riggs	Date: 2007-10-04 14:11:22
	Subject: Connection Pools and DISCARD ALL