Re: nested transactions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: nested transactions
Date
Msg-id 200211281627.gASGRKw15547@candle.pha.pa.us
Whole thread Raw
In response to Re: nested transactions  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
Hans-J�rgen Sch�nig wrote:
> Is there going to be a way to use transactions inside transactions of 
> transactions?
> In other words:
> 
>     BEGIN;
>     BEGIN;
>     BEGIN;
>     BEGIN;
> 
>     COMMIT;
>     COMMIT;
>     COMMIT;
>     COMMIT;
> 
> Is there a way to have some sort of recursive solution with every 
> transaction but the first one being a child transaction?
> Is there a way to implement that without too much extra effort?
> I just curious how that could be done.

Sure, nesting will be unlimited.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Alter table .. Add primary key
Next
From: Masaru Sugawara
Date:
Subject: Is current_user a function ?