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 <[EMAIL PROTECTED]> 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.
pgpjwDDy6kyyH.pgp
Description: PGP signature
