Horton

Re: Savepoints in plpgsql

Olleg Samoylov <splarv@ya.ru>

View thread View on postgr.es
From: Олег Самойлов <splarv@ya.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Date: 2024-08-05T08:20:58Z
Lists: pgsql-docs 

On 12.07.2024 16:42, Tom Lane wrote:

> 
>      PL/pgSQL does not support savepoints (SAVEPOINT/ROLLBACK TO
>      SAVEPOINT/RELEASE SAVEPOINT commands).  Typical usage patterns
>      for savepoints can be replaced by blocks with exception handlers
>      (see 43.6.8).  Under the hood, a block with exception handlers
>      forms a subtransaction, which means that transactions cannot
>      be ended inside such a block.
> 
> 			regards, tom lane

Yes, this will be fine.
-- 
Олег

Commits

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