root page error

From: "A Palmblad" <adampalmblad(at)yahoo(dot)ca>
To: "General Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: root page error
Date: 2004-08-03 20:04:43
Message-ID: 00d001c47995$1ed155e0$97019696@AERS04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 neighbourhood of 45 million rows.

How can I fix the problem?

-Adam Palmblad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-08-04 00:20:21 Re: root page error
Previous Message David Parker 2004-08-03 19:30:26 trash talk