Re: check database integrity

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: check database integrity
Date: 2014-07-23 02:26:36
Message-ID: 53CF1D5C.8080200@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2014-07-23 03:53:58 Re: question about memory usage
Previous Message klo uo 2014-07-22 22:16:47 question about memory usage