On Wed, May 26, 2010 at 2:52 AM, Ravi Katkar 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
: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Transaction with in function
In response to Ravi Katkar :
>
>
> I looking for solution for commit, rollback with in function.
You can't use transactions within functions, use savepoints instead.
http://www.postgresql.org/docs/
In response to Ravi Katkar :
>
>
> I looking for solution for commit, rollback with in function.
You can't use transactions within functions, use savepoints instead.
http://www.postgresql.org/docs/current/static/sql-savepoint.html
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035
