Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Warren Vanichuk <pyber(at)street-light(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Date: 2001-03-07 04:04:55
Message-ID: 8371.983937895@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Warren Vanichuk <pyber(at)street-light(dot)com> writes:
> freehost=# vacuum analyze;
> NOTICE: Rel pg_language: TID 0/1: OID IS INVALID. TUPGONE 1.
> ERROR: Index pg_language_oid_index is not a btree

Yeek. Something's pretty hosed with pg_language_oid_index. Try
reindexing it. (The procedure to reindex a system index is a bit
arcane, and I have to admit I've never done it myself, but it's in
the documentation.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-07 04:12:58 Re: Temporary sorting space
Previous Message will trillich 2001-03-07 03:59:18 Re: Temporary sorting space