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

Re: Nested Transactions, Abort All

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: 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 22:03:13
Message-ID: 20040702220313.GA1279@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Jul 02, 2004 at 11:51:01PM +0200, Jeroen T. Vermeulen wrote:
> 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).

Oh, right, I forgot about this one ...  Will think about it (it should
be forbidden).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiánse", y el computador dirá "especifique el tipo de ciervo"
(Jason Alexander)


In response to

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2004-07-02 22:32:12
Subject: Re: working on support triggers on columns
Previous:From: Greg Sabino MullaneDate: 2004-07-02 21:51:38
Subject: Re: [Re] Re: PREPARE and transactions

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