[EMAIL PROTECTED] wrote:
Hi,
I have to execute commit for evey record that i processed during a cursor fetch 
in a function.
There is a way to do it?

Sure. Do it outside PL/PgSQL, using a database client API like those available for Python, Java, Perl, etc.

If you really need to do it in PL/PgSQL, is there any reason you can't do all the work in one transaction and commit when the function finishes?

--
Craig Ringer

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to