On Wed, Jul 15, 2009 at 4:32 PM, Anj Adu<
fotographs@gmail.com> wrote:
> No
>
> Savepoints allow a transaction to be committed upto a savepoint "if"
> somthing bad happens after savepoint..but I want an explicit commit even if
> nothing bad happens later..i.e.I need to commit "when" I want to. (just like
> Oracle PLSQL)
>
> On Wed, Jul 15, 2009 at 3:01 PM, Scott Marlowe <
scott.marlowe@gmail.com>
> wrote:
>>
>> On Wed, Jul 15, 2009 at 3:58 PM, Anj Adu<
fotographs@gmail.com> wrote:
>> > Is there a way to issue a commit within a function and continue
>> > processing?
>> > I know this is not possible in 8.1..
>> >
>> > We have long running function calls...parts of which are independent of
>> > each
>> > other. The independent functions are called within a "main" outer
>> > function.
>> > We would like to commit the data modified by each function as a single
>> > unit
>> > so that the data is freed up for other modules to act on.
>> >
>> > Are there any future postgres releases (we use 8.1.9) that possible
>> > address
>> > this.
>>
>> What you are looking for are savepoints, most likely.
>
>