Re: Savepoints in plpgsql

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Savepoints in plpgsql
Date: 2024-08-05 08:20:58
Message-ID: 1af26a1b-9b82-4f89-a5e1-eb86e5330c3d@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.
--
Олег

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2024-08-05 14:29:12 There is an invalid value for cidr type in the "Table 8.22. cidr Type Input Examples"
Previous Message David Rowley 2024-08-02 15:12:34 Re: incorrect PostgreSQL documentation for pg_type