Savepoints in plpgsql

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: splarv(at)ya(dot)ru
Subject: Savepoints in plpgsql
Date: 2024-07-12 05:52:24
Message-ID: 172076354433.736586.14347210271966220018@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2024-07-12 13:15:20 Re: Savepoints in plpgsql
Previous Message Laurenz Albe 2024-07-10 20:36:27 Re: Add small detail to RAISE statement descripton