On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer < akretsch...@spamfence.net> wrote:
> Jasid ZA <za.ja...@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[.sin...@enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device