Re: [SQL] Commit every processed record

Well, actually there is. Do the processing in a plperlu function which uses it's own connection to the db. Then every instance of the function will have it's own transaction. Try to start that perl connection outside the function or your performance will drop too much. I use this technique to fet

Re: [SQL] Commit every processed record

[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 P

Re: [SQL] Commit every processed record

am Mon, dem 07.04.2008, um 14:46:50 +0200 mailte [EMAIL PROTECTED] folgendes: > 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? No. Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0

[SQL] Commit every processed record

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? Thanks in advance. Luke. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql