Thread: Savepoint

Savepoint

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-insert.html
Description:

https://www.postgresql.org/docs/16/sql-insert.html#SQL-ON-CONFLICT

In section on conflict nothing that there will be implicit savepoint (sub
transaction). But this is important to know to mark function as PARALLEL
UNSAFE.

Re: Savepoint

From
Laurenz Albe
Date:
On Fri, 2024-10-18 at 06:50 +0000, PG Doc comments form wrote:
> https://www.postgresql.org/docs/16/sql-insert.html#SQL-ON-CONFLICT
>
> In section on conflict nothing that there will be implicit savepoint (sub
> transaction). But this is important to know to mark function as PARALLEL
> UNSAFE.

What makes you think that INSERT ... ON CONFLICT takes a savepoint?

Yours,
Laurenz Albe