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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
