not finding rows using ctid

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: not finding rows using ctid
Date: 2014-08-07 19:40:48
Message-ID: CAGoODpfu4x4SA_NcPee25NtjMJvGqp=n1Ph8OW1M8kgJoHFZkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Curvey 2014-08-07 19:53:16 Re: dump/restore with a hidden dependency?
Previous Message Jeff Janes 2014-08-07 19:21:19 Re: Avoid WAL archiving when idle?