Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: existing row not found by SELECT ... WHERE CTID = ?
Date
Msg-id de368023ce9d002ab169428175d27108f6c17cb6.camel@cybertec.at
Whole thread Raw
In response to existing row not found by SELECT ... WHERE CTID = ?  (Matthias Apitz <guru@unixarea.de>)
Responses Re: existing row not found by SELECT ... WHERE CTID = ?
Re: existing row not found by SELECT ... WHERE CTID = ?
List pgsql-general
Tree view 
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.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: link that explain ICU_LOCALE locale concept about local variant code and keywords.
Next
From: Matthias Apitz
Date:
Subject: Re: existing row not found by SELECT ... WHERE CTID = ?