On Wed, May 26, 2010 at 2:52 AM, Ravi Katkar <ravi.kat...@infor.com> wrote: > How can we achieve nested transactions? ( may be using save points )with in > functions. > Is there any work around?
It unfortunately can't be done from within the database. There is only one workaround -- using dblink or similar technology to connect back to the database inside your function to bend/break transaction rules. In the 9.0 world, this (no implicit transaction state pl code, possibly termed 'stored procedures') is one of the top two or three requested features. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general