Skip site navigation (1) Skip section navigation (2)

Re: Nested Transactions, Abort All

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Thomas Swan <tswan(at)idigx(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Nested Transactions, Abort All
Date: 2004-07-02 21:51:01
Message-ID: 20040702215101.GH50626@xs4all.nl (view raw or flat)
Thread:
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


In response to

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group