Re: autonomous transactions - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: autonomous transactions
Date
Msg-id 47A0AE1C.8090200@agliodbs.com
Whole thread Raw
In response to Re: autonomous transactions  (Bruce Momjian <bruce@momjian.us>)
Responses Re: autonomous transactions  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
All,

> 
> Added to TODO:
> 
> * Add anonymous transactions
> 
>   http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php
>

IMHO, autonomous transactions should be part of a package with a 
spec-compliant CREATE PROCEDURE statement.    That is, the difference 
between PROCEDURES and FUNCTIONS would be that:

-- PROCs have autonomous transactions
-- PROCs have to be excuted with CALL, and can't go in a query
-- PROCs don't necessarily return a result

--Josh Berkus


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Truncate Triggers
Next
From: Alvaro Herrera
Date:
Subject: Re: autonomous transactions