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  (AI Rumman <rummandba@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris Curvey
Дата:
Сообщение: Re: dump/restore with a hidden dependency?
Следующее
От: David G Johnston
Дата:
Сообщение: Re: dump/restore with a hidden dependency?