Search Postgresql Archives

Re: Rows missing from table despite FK constraint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/1/8 Tom Lane <tgl@xxxxxxxxxxxxx>:

> Just to confirm, if you try to select any of these rows by ctid, ie
>        select * from tablename where ctid = '(603713,1)';
> you get nothing?  What *should* happen is that you get the row if you
> mention offset 1, 3, or 5, but nothing if you say 2 or 4.

How about this?

# select attachment_id from attachment where ctid = '(603713,1)';
 attachment_id
---------------
      15460683
(1 row)

# select attachment_id from attachment where attachment_id = 15460683;
 attachment_id
---------------
(0 rows)

-- 
Konrad Garus

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux