Re: Named transaction - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Named transaction
Date
Msg-id 4A3928ED.2010407@dunslane.net
Whole thread Raw
In response to Re: Named transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Named transaction  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers

Tom Lane wrote:
> Pavel Golub <pavel@microolap.com> writes:
>   
>> Is there any possibility that Postgres will have named transaction
>> ever, like Firebird?
>>     
>
> What in heck is a named transaction, and why should we care?
>
>             
>   

Isn't this just another name for a subtransaction or inner transaction 
that can be separately committed?
   begin transaction bar;   ...   begin transaction foo;   ...   commit foo;   ...   rollback bar;



foo's work is still committed.

People have been hacking this up using dblink calls, I believe, but 
that's a horrid kludge.

cheers

andrew


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: GRANT ON ALL IN schema
Next
From: Alvaro Herrera
Date:
Subject: Re: Named transaction