Skip site navigation (1) Skip section navigation (2)

Re: corrupt pg_language index <?>

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Dugan <dugan(at)smi(dot)stanford(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: corrupt pg_language index <?>
Date: 2001-10-29 22:14:33
Message-ID: 14703.1004393673@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Jon Dugan <dugan(at)smi(dot)stanford(dot)edu> writes:
> NOTICE:  Rel pg_class: TID 0/46: OID IS INVALID. TUPGONE 0.
> ERROR:  cannot find attribute 1 of relation pg_language_oid_index

Hmm.  Try rebuilding the system indexes, via REINDEX DATABASE in
that database.  (See the REINDEX documentation for the proper procedure
to rebuild system indexes --- you need to give the command in a
standalone backend with the postmaster shut down, else you'll probably
make things worse not better.)

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Ross J. ReedstromDate: 2001-10-29 23:16:27
Subject: Re: Code to automatically refresh sequences after loading data?
Previous:From: Sean ChittendenDate: 2001-10-29 21:46:04
Subject: Re: FreeBSD upgrade causes performance degredation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group