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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
