Bumping this old thread to clarify a few points.
As an initial note on terminology, a "server" can be called a server, an
instance, a server instance, or in PostgreSQL's (PG hereafter) case, a "DB
Cluster." They all are used interchangeably in the wild to mean the same thing,
with perhaps "serv
Moreno,
You have two lines in your WHERE clause commented out, the first line is a
duplicate check on flag = TRUE, and the other line involves several checks on
the "tipo" column. Will the final query or set of related queries actually need
to filter on the "tipo" column? You currently have "ti
lease advise.
Thanks,
Kevin Stephenson
From: Tom Lane
Sent: Saturday, March 22, 2025 7:59 AM
To: Christophe Pettus
Cc: Kevin Stephenson ; pgsql-gene...@postgresql.org
Subject: Re: Nested Stored Procedures - ERROR: invalid transaction termination
2D000
Chris
is that if the outer procedure does not use an
EXCEPTION block (see Test 2 ), 2D000 is not thrown and the autonomous TX
workaround works as desired.
Please advise if this is expected behavior.
Much thanks,
Kevin Stephenson
-- WARNING: Script contains DROP statements.
-- Greatly simplified schema for
