commits in functions - Mailing list pgsql-admin

From Sriram Dandapani
Subject commits in functions
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF041C2A76@ca-mail1.cis.local
Whole thread Raw
Responses Orphan files  (dzung nguyen the <dzungthenguyen@yahoo.com>)
List pgsql-admin

Hi

 

Is there a way to issue commits in long running functions. Currently, I make calls out to java functions for transaction blocks that need committing at frequent intervals.

 

The begin..end  savepoint feature is nice, but what I am looking for is a way to reduce resources/log file generation by issuing frequent commits.

pgsql-admin by date:

Previous
From: "Hogan, James F. Jr."
Date:
Subject: Trouble installing pltcl language
Next
From: brian
Date:
Subject: Re: New system recommendations