Thread: Transactions in postgres

Transactions in postgres

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/tutorial-transactions.html
Description:

What is discussed in the transaction article
is valid as long as the commit is made in the place where the stored
procedure was invoked, since if the commit is made in the procedure where
the transaction is executed, it generates the following error: ERROR:
invalid transaction termination SQL state: 2D000 .
Additionally begin; generates syntax error.