Postgres Pro
Downloads
Home   >   mailing lists

Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP - Mailing list pgsql-general

From Christophe Pettus
Subject Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Date
Msg-id 72BEC008-DC6C-4D80-80A6-E1634CFFA656@thebuild.com
Whole thread Raw
In response to COMMIT IN STORED PROCEDURE WHILE IN A LOOP  (Ravi Krishna <s_ravikrishna@aol.com>)
Responses Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
List pgsql-general
Tree view 

> On Oct 18, 2022, at 13:14, Ravi Krishna <s_ravikrishna@aol.com> wrote:
>
> I am getting error at COMMIT -> cannot commit while a subtransaction is active.
> Is commit not possible in a loop

You can commit in a loop, but not in BEGIN / END block that has an exception handler: that creates a subtransaction for
theduration of the BEGIN / END.

pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Next
From: Bryn Llewellyn
Date:
Subject: Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP