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
