Re: check database integrity

On 22/07/14 16:58, Tom Lane wrote:
> Doh.  I looked right at this code in get_raw_page yesterday:
>
>     if (blkno >= RelationGetNumberOfBlocks(rel))
>         elog(ERROR, "block number %u is out of range for relation \"%s\"",
>              blkno, RelationGetRelationName(rel));
>
> RelationGetNumberOfBlocks reports the length of the main fork ... but
> this check is applied regardless of which fork we're reading.  Should
> be using RelationGetNumberOfBlocksInFork, of course.

Thanks for fixing it. I saw your GIT commit.

Do you know how long it takes for the change to make it into a new pgdg
debian package?

Thanks,
Torsten