Re: nested transactions

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: nested transactions
Дата
Msg-id 200211281627.gASGRKw15547@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: nested transactions  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Alter table .. Add primary key
Следующее
От: Masaru Sugawara
Дата:
Сообщение: Is current_user a function ?