| From: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: sql transaction |
| Date: | 2009-03-18 15:54:20 |
| Message-ID: | 65937bea0903180854r5536949dm4e0d20e17f7e8d19@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer <
akretschmer(at)spamfence(dot)net> wrote:
> Jasid ZA <za(dot)jasid(at)gmail(dot)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[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kynn Jones | 2009-03-18 16:00:30 | DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently |
| Previous Message | Chris Browne | 2009-03-18 15:49:02 | Re: PostgreSQL versus MySQL for GPS Data |