On 1 Srpen 2011, 13:55, Deniz Atak wrote:
> Hi Thomas,
>
> thanks for your answer. We decided not to go further with this error,
> because soon we will have another product that replaces this one. Because
> I
> want to learn more about this topic, I did the following:
>
> Before I write your code, I tried:
> select oid,ctid,relname from pg_class where ctid='(4707,0)';
You need to select from the relation with relfileid 16564, not from
pg_class. Use this
SELECT relname FROM pg_class WHERE relfilenode = 16564;
and then select from this relation.
And if you want to see the items on block 4707, you can do something like
this:
SELECT * FROM relation WHERE ctid >= '(4707,0)' AND ctid < '(4708,0)';
although it'll probably fail. Maybe "pageinspect" contrib module will tell
you more about the page
(http://www.postgresql.org/docs/current/static/pageinspect.html).
Tomas