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

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

> > 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.)

Thank you, I found 'reindex' and followed the instructions and everything
appears to be fairly happy again. :)

Sincerely, Warren

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Madden 2001-03-07 19:18:41 Re: How robust is postgresql ?
Previous Message Brett W. McCoy 2001-03-07 19:17:15 Re: How robust is postgresql ?