Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success

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