On 01/23/2015 11:56 AM, Suresh Raja wrote:
Hi All:
We are running a function with a loop in it. We tried
commit;
We are getting error with above command. How can i easily commit
withing a function.
Functions do not have transactions inside them. If you are using plpgsql
you can use EXCEPTIONS:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
Thanks,
-SR
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
