Savepoints in plpgsql

The Post Office <noreply@postgresql.org>

From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: splarv@ya.ru
Date: 2024-07-12T05:52:24Z
Lists: pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/plpgsql-transactions.html
Description:

https://www.postgresql.org/docs/current/plpgsql-transactions.html

In this section nothing mentioned that a savepoint (a subtransaction) will
not work inside plpgsql. Savepoint command is ended with "ERROR: 
unsupported transaction command in PL/pgSQL". Also need to say, that "begin
end" block with "exception" handler will implicitly save and release
savepoints.

Commits

  1. Doc: minor improvements for plpgsql "Transaction Management" section.