Re: BUG #18457: Possible data loss needs to be evaluated - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #18457: Possible data loss needs to be evaluated
Date
Msg-id 7aafc728c6928b1b3a6e6ddeae8ae59dd3f65261.camel@cybertec.at
Whole thread Raw
In response to BUG #18457: Possible data loss needs to be evaluated  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18457: Possible data loss needs to be evaluated
List pgsql-bugs
On Tue, 2024-05-07 at 08:35 +0000, PG Bug reporting form wrote:
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
>
> We are still trying to find out how this could have happened.

This is not a bug, it is expected behavior.
If a statement in a transaction causes an error, all subsequent
statements in that transaction will receive that message until
you end the transaction with ROLLBACK or COMMIT (which will also
roll back).

Yours,
Laurenz Albe



pgsql-bugs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: BUG #18458: SQL Error [XX000]: ERROR: cache lookup failed for type 0
Next
From: Julius Ernesti
Date:
Subject: Re: BUG #18457: Possible data loss needs to be evaluated