Message-ID: <1af26a1b-9b82-4f89-a5e1-eb86e5330c3d@ya.ru>
Date: Mon, 5 Aug 2024 11:20:58 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Savepoints in plpgsql
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>
References: <172076354433.736586.14347210271966220018@wrigleys.postgresql.org>
 <CAKFQuwZXC2dDsDMLg77kWO4c7aiFwEn5LS9Hc9p-iooHXK+Ecw@mail.gmail.com>
 <2320320.1720791744@sss.pgh.pa.us>
Content-Language: ru
From: =?UTF-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= <splarv@ya.ru>
In-Reply-To: <2320320.1720791744@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/1af26a1b-9b82-4f89-a5e1-eb86e5330c3d%40ya.ru>
Precedence: bulk


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.
-- 
Олег