On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote:
No, a function is not an autonomous transaction (at least not what that term stands for in Oracle).
Jasid ZA <za.jasid@xxxxxxxxx> wrote:No. A function is an autonomous transaction. You can use savepoints.
> Hi,
>
> Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
> function(user defined) which is written in PL/Perl?
No, a function is not an autonomous transaction (at least not what that term stands for in Oracle).
Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
