Re: [GENERAL] not finding rows using ctid

On 08/07/2014 02:14 PM, AI Rumman wrote: I didn't execute any Vacuum Full and I tried to get the row after 3 hours of the issue. Also, "...a row's ctid will change if it is updated..." Thanks. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] not finding rows using ctid

I didn't execute any Vacuum Full and I tried to get the row after 3 hours of the issue. Thanks. On Thu, Aug 7, 2014 at 1:51 PM, Adrian Klaver wrote: > On 08/07/2014 12:40 PM, AI Rumman wrote: > >> >> Hi, >> >> I am getting the logs as follows: >> >> LOG: process 32145 acquired ExclusiveLock o

Re: [GENERAL] not finding rows using ctid

On 08/07/2014 12:40 PM, AI Rumman wrote: 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 g

[GENERAL] not finding rows using ctid

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.