Request a Demo
Home   >   mailing lists

Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result
Date
Msg-id CAKFQuwZdRbac7ajisTqDSJp7Djj4EQCBJDkNb7de10nYd4gBrQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result  ("ZhangChi" <798604270@qq.com>)
Responses Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: "ZhangChi"
Date:
Subject: Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result
Next
From: Tom Lane
Date:
Subject: Re: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result