Andreas Kretschmer wrote: > Jasid ZA <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
