Savepoint

Started by PG Bug reporting formover 1 year ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: Savepoint

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