From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
---|---|
To: | 'Albert Csaba' <maka_cs(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: META vacuum - FAIL: ERROR |
Date: | 2002-06-06 09:14:23 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F748D3@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)com]
>
> Hi!
>
> I have a RaQ3 Cobalt server, which uses PostgreSQL.
> Lately I'm getting this error:
>
> NOTICE: Index pg_attribute_attrelid_index: NUMBER OF
> INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE: Index pg_attribute_relid_attnum_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE: Index pg_attribute_relid_attnam_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> META vacuum - FAIL: ERROR: cannot find attribute 1 of
> relation quota
>
> What can I do? Can I change manually somehow the
> database?
>
> Any help is welcome,
> Thank you in advance
>
> Csaba Albert
Try reindex from a stand alone postgres (just postgres rather than
postmaster).
This should reindex the system tables.
hth,
- Stuart
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2002-06-06 09:22:30 | Re: Unable to access records in table! |
Previous Message | Wim | 2002-06-06 08:55:12 | Unable to access records in table! |