Re: Nested Stored Procedures - ERROR: invalid transaction termination 2D000 - Mailing list pgsql-general

Hello,

> On Mar 22, 2025, at 08:38, Kevin Stephenson <kjs714@hotmail.com> wrote:
>     • When a top-level stored procedure is called it implicitly creates a TX if there is no current TX.
>     • When a BEGIN/EXCEPTION block is used it implicitly creates a subTX for that block.

These statements are correct.

>     • When a nested stored procedure is called it implicitly creates a subTX for that invocation.

This one is not.  (Although the behavior you are looking for may not depend on that.)

A procedure cannot issue top-level transaction control statements from within an exception block, and attempting to do
soraises the error you saw.  This includes procedures that are called from within an exception block.