Postgres Pro
Downloads
Home   >   mailing lists

not finding rows using ctid - Mailing list pgsql-general

From AI Rumman
Subject not finding rows using ctid
Date
Msg-id CAGoODpfu4x4SA_NcPee25NtjMJvGqp=n1Ph8OW1M8kgJoHFZkw@mail.gmail.com
Whole thread Raw
Responses Re: not finding rows using ctid  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

Hi,

I am getting the logs as follows:

LOG:  process 32145 acquired ExclusiveLock on tuple (153420,5) of relation 663326 of database 475999 after 1123.028 ms


But, when I am executing sqls to find the row on that table using the ctid = '(153420,5)', I get no rows.


Any idea, why?


Thanks.

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Avoid WAL archiving when idle?
Next
From: Steve Clark
Date:
Subject: Re: order by question