Re: Help with BEGIN/COMMIT within a transaction

On 02 Aug 2003 09:42:05 -0400, Doug McNaught <doug(at)mcnaught(dot)org>
wrote:
>Bhavesh Jardosh <perltastic(at)yahoo(dot)com> writes:
>> I need to use BEGIN/COMMIT within a stored procedure [...]
>
>You can't currently do this. Calls to functions are already inside a
>(possibly implicit) transaction, so calling BEGIN inside a function
>would have to start a subtransaction, which PG doesn't currently
>support. There is some possibility that this feature will be in 7.5,
>but that won't be coming out anmytime soon.

Subtransactions won't help, because the OP wants

>[...] to commit from within a cursor loop so that the changes are visible in
>other sessions as soon as they are done.

Changes will not be visible to other sessions until the *main*
transaction commits.

Servus
Manfred