On Wed, May 26, 2010 at 2:52 AM, Ravi Katkar <Ravi.Katkar@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
