Re: Commit every processed record

luke.78@[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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql