Re: Inserting values into a SERIAL field - Mailing list pgsql-general

From Warren Vanichuk
Subject Re: Inserting values into a SERIAL field
Date
Msg-id Pine.LNX.4.21.0103061533520.25271-100000@urd.street-light.com
Whole thread Raw
In response to Re: Inserting values into a SERIAL field  (GH <grasshacker@over-yonder.net>)
List pgsql-general
Greetings.

I just received the following error attempting to do a vacuum on my
database:

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

And I see several errors in the logs regarding invalid function calls.  When
I attempt to call any user-defined function I receive :

freehost=# select add_pageview( 1 );
ERROR:  Index pg_language_oid_index is not a btree

The only oddity during this time was the postgres process handling the
vacuum shot up to 685MB worth of RAM usage (638 shared) during the vacuum.

This is a Debian 2.2 system running PostgreSQL 7.0.3...

Help? :)

Sincerely, Warren


pgsql-general by date:

Previous
From: Boulat Khakimov
Date:
Subject: Undefined symbol
Next
From: Warren Vanichuk
Date:
Subject: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language