Re: [GENERAL] Transaction with in function
How can we achieve nested transactions? ( may be using save points )with in functions. Is there any work around? -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of A. Kretschmer Sent: Wednesday, May 26, 2010 10:44 AM To: 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/current/static/sql-savepoint.html Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Transaction with in function
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
[GENERAL] Transaction with in function
I looking for solution for commit, rollback with in function. Below is Example function CREATE OR REPLACE FUNCTION test() RETURNS void AS $BODY$ BEGIN --- setof statements Commit; -- set of statement commit; -- if things goes wrong rollback RETURN; END; $BODY$ LANGUAGE 'plpgsql'; Thanks in advance . Regards Ravi Katkar
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/current/static/sql-savepoint.html Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general