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

In response to

• Re: Nested Transactions, Abort All at 2004-07-02 21:30:49 from Alvaro Herrera

Responses

• Re: Nested Transactions, Abort All at 2004-07-02 22:03:13 from Alvaro Herrera

pgsql-hackers by date

Next:	From: Greg Sabino Mullane	Date: 2004-07-02 21:51:38
	Subject: Re: [Re] Re: PREPARE and transactions
Previous:	From: Alvaro Herrera	Date: 2004-07-02 21:30:49
	Subject: Re: Nested Transactions, Abort All