Re: Commit every processed record
От
Craig Ringer
Тема
Re: Commit every processed record
Дата
Msg-id
47FA23EB.8060701@postnewspapers.com.au
Ответ на
Commit every processed record (luke\.78\@libero\.it)
Список
Дерево обсуждения
Commit every processed record "luke\.78\@libero\.it" <luke.78@libero.it>
Re: Commit every processed record "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Commit every processed record "Bart Degryse" <Bart.Degryse@indicator.be>
Re: Commit every processed record Craig Ringer <craig@postnewspapers.com.au>
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
В списке pgsql-sql по дате отправления
