Re: Inserting values into a SERIAL field

From: Warren Vanichuk <pyber(at)street-light(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting values into a SERIAL field
Date: 2001-03-06 23:42:40
Message-ID: Pine.LNX.4.21.0103061533520.25271-100000@urd.street-light.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Boulat Khakimov 2001-03-06 23:44:31 Undefined symbol
Previous Message GH 2001-03-06 23:13:09 Re: Inserting values into a SERIAL field