Re: root page error - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: root page error
Date
Msg-id 20040804002021.GB28318@svana.org
Whole thread Raw
In response to root page error  ("A Palmblad" <adampalmblad@yahoo.ca>)
List pgsql-general
Dunno about the problem, but "reindex primary_index_name" will probably
fix it...

On Tue, Aug 03, 2004 at 01:04:43PM -0700, A Palmblad wrote:
> Today, queries to one of our tables started giving the following error:
>     ERROR: root page xxxx of "primary_index_name" has level 0, expected 3.
>
> What would cause that?  We did have a earlier today, methinks they are probably related.  It's a big table, in the
neighbourhoodof 45 million rows.   
>
> How can I fix the problem?
>
> -Adam Palmblad
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: "David Parker"
Date:
Subject: trash talk
Next
From: "Scott Marlowe"
Date:
Subject: Re: trash talk