Re: Nested Transactions, Abort All
Alvaro Herrera <alvherre@dcc.uchile.cl>
From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Thomas Swan <tswan@idigx.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-07-02T22:03:13Z
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)