On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer
<akretschmer@spamfence.net> wrote:
Jasid ZA <
za.jasid@gmail.com> wrote:
> 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 an autonomous transaction. You can use savepoints.
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.comMail sent from my BlackLaptop device