Simon Riggs <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to