Re: Nested Transactions, Abort All - Mailing list pgsql-hackers

From Jeroen T. Vermeulen
Subject Re: Nested Transactions, Abort All
Date
Msg-id 20040702215101.GH50626@xs4all.nl
Whole thread Raw
In response to Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List 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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Nested Transactions, Abort All
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: [Re] Re: PREPARE and transactions