Re: not finding rows using ctid
От | Adrian Klaver |
---|---|
Тема | Re: not finding rows using ctid |
Дата | |
Msg-id | 53E3E6DF.9090303@aklaver.com обсуждение исходный текст |
Ответ на | not finding rows using ctid (AI Rumman <rummandba@gmail.com>) |
Ответы |
Re: not finding rows using ctid
|
Список | pgsql-general |
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 get no rows. > > > Any idea, why? http://www.postgresql.org/docs/9.3/static/ddl-system-columns.html "ctid The physical location of the row version within its table. Note that although the ctid can be used to locate the row version very quickly, a row's ctid will change if it is updated or moved by VACUUM FULL. Therefore ctid is useless as a long-term row identifier. The OID, or even better a user-defined serial number, should be used to identify logical rows." Something changed the row between the time you saw it in the log and the time you did the query. > > > Thanks. > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: