Postgres Pro
Downloads
Home   >   mailing lists

Re: existing row not found by SELECT ... WHERE CTID = ? - Mailing list pgsql-general

From Matthias Apitz
Subject Re: existing row not found by SELECT ... WHERE CTID = ?
Date
Msg-id 20220525120112.GA17@sh4-5.1blu.de
Whole thread Raw
In response to Re: existing row not found by SELECT ... WHERE CTID = ?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: existing row not found by SELECT ... WHERE CTID = ?
List pgsql-general
Tree view 
El día Mittwoch, Mai 25, 2022 a las 12:51:02 +0200, Laurenz Albe escribió:

> On Wed, 2022-05-25 at 11:21 +0200, Matthias Apitz wrote:
> > Is it possible that the PostgreSQL 13.1 server does something by its own to invalidate the rowid?
> 
> No.  PostgreSQL may remove a dead row, but a dead row is by definition
> no longer visible, so it wouldn't be found by a query.

We will solve the problem now with setting the session after connect to

   SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL REPEATABLE READ;

(with an appropriate ESQL/C call). Any comments?

Thanks

    matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: existing row not found by SELECT ... WHERE CTID = ?
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: existing row not found by SELECT ... WHERE CTID = ?