root page error

[A Palmblad]

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

[Martijn van Oosterhout]

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

How can I fix the problem?

-Adam Palmblad --
Martijn van Oosterhout <kl*****@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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBECvFY5Twig3Ge+YRAtO+AKDBZi/AJ3g7owtxX8PE9eE2yO8tMgCeP2GG
CLB/XsSDYl/YIBJfpNDThJo=
=nSmV
-----END PGP SIGNATURE-----