Postgres Pro
Downloads
Home   >   mailing lists

Re: commit inside a function failing - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: commit inside a function failing
Date
Msg-id CAFj8pRCF=874RVXHa2P486af+a5ZuckSDDjeQ_k8o93QQV7bPg@mail.gmail.com
Whole thread Raw
In response to commit inside a function failing  (Suresh Raja <suresh.rajaabc@gmail.com>)
List pgsql-sql
Tree view
Hi

2015-01-23 20:56 GMT+01:00 Suresh Raja <suresh.rajaabc@gmail.com>:
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.


It is not possible in PostgreSQL

Regards

Pavel Stehule
 

Thanks,
-SR 

pgsql-sql by date:

Previous
From: Suresh Raja
Date:
Subject: commit inside a function failing
Next
From: Adrian Klaver
Date:
Subject: Re: commit inside a function failing