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