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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
