Horton

Re: Nested Transactions, Abort All

Jeroen Vermeulen <jtv@xs4all.nl>

View thread
From: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
To: Alvaro Herrera <alvherre@dcc.uchile.cl>
Cc: Thomas Swan <tswan@idigx.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-07-02T21:51:01Z
Lists: pgsql-hackers 
On Fri, Jul 02, 2004 at 05:30:49PM -0400, Alvaro Herrera wrote:
 
> You can't have subtransactions inside an implicit transaction block, so

Haven't been following this thread closely, but just my 2 cents...

If you collate queries using the semicolon, AFAIK the whole thing is
executed as a single implicit transaction (if not in an explicit one
already, of course).  So is there anyone stopping a user from executing

BEGIN ; UPDATE ... ; COMMIT

?


Jeroen