luke.78@libero.it 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