commits in functions

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: commits in functions
Date: 2006-04-27 22:26:34
Message-ID: 6992E470F12A444BB787B5C937B9D4DF041C2A76@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dzung nguyen the 2006-04-28 02:05:15 Orphan files
Previous Message brian 2006-04-27 22:11:30 Re: New system recommendations