Horton

Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: ZhangChi <798604270@qq.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2025-08-30T01:57:05Z
Lists: pgsql-bugs 
On Friday, August 29, 2025, ZhangChi <798604270@qq.com> wrote:
>
>
> I still have a problem with this. When an INSERT fails, why not undo all
> the effects of the INSERT?
>

Performance.

Sequences don’t go backward.

David J.