Andreas Kretschmer 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.
This question comes up very often. Would somebody please write it and a detailed answer to add to the FAQ in the Wiki? http://wiki.postgresql.org/wiki/FAQ -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
