On 02 Aug 2003 09:42:05 -0400, Doug McNaught <doug@mcnaught.org>
wrote:
>Bhavesh Jardosh <perltastic@yahoo.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