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>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Nested Transactions, Abort All
Date: 2004-07-01 22:38:41
Message-ID: 20040701223841.GD13816@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Jul 01, 2004 at 02:01:37PM -0500, Thomas Swan wrote:
> Is there going to be an option to abort the complete transaction without 
> knowing how deep you are?  Perhaps something like "ABORT ALL".
> 
> The reason I suggest this, is that I can foresee an application or user 
> leaving nested transactions open inadvertently, or not knowing how 
> deeply nested they are when they are called.  It's just a thought, and I 
> didn't recall any mention of something like it on the list.

If we change the syntax, say by using SUBCOMMIT/SUBABORT for
subtransactions, then using a simple ABORT would abort the whole
transaction tree.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)


In response to

Responses

pgsql-hackers by date

Next:From: Gavin SherryDate: 2004-07-01 22:43:26
Subject: Re: Quick question regarding tablespaces
Previous:From: Alvaro HerreraDate: 2004-07-01 22:37:53
Subject: Re: suggestion: set default statistics to 100 for numerics

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