[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