Postgres Pro
Downloads
Home   >   mailing lists

Re: sql transaction - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: sql transaction
Date
Msg-id 65937bea0903180854r5536949dm4e0d20e17f7e8d19@mail.gmail.com
Whole thread Raw
In response to Re: sql transaction  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
Tree view
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.com

Mail sent from my BlackLaptop device

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: PostgreSQL versus MySQL for GPS Data
Next
From: Kynn Jones
Date:
Subject: DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently