Re: [HACKERS] Detecting corrupted pages earlier

[Hiroshi Inoue]

Tom Lane wrote:
> 
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> >>> Is there a way to make our way around the pages ?
> >>
> >> If the header is corrupt, I don't think so.
> 
> > What I asked is how to read all other sane pages.
> 
> Oh, I see.  You can do "SELECT ... LIMIT n" to get the rows before the
> broken page, but there's no way to get the ones after it.  My proposal
> won't make this worse, but it won't make it any better either.  Do you
> have an idea how to get the rows after the broken page?

How about adding a new option to skip corrupted pages ?

regards,
Hiroshi Inoue
        http://www.geocities.jp/inocchichichi/psqlodbc/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]