Unable to Insert Row - Mailing list pgsql-admin

From Sam Stearns
Subject Unable to Insert Row
Date
Msg-id BANLkTikz3KxQEma8NYXZcjq4KwRBpQKJLQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Howdy,

Environment:

Postgres 8.3.14
Solaris 10

When attempting to insert a row, the following error is received:

ERROR:  could not open relation with OID 926167091

This OID does not exist anywhere in the database.  Most inserts on
this table are successful.  It is only for 2 particular id's where the
inserts are failing with this error.  The id column is indexed.  I
have tried vacuum analyzing the database.  Still get the error.  I
have NOT tried re-indexing yet.  Some googling says a restart of
postgres fixes it.  I would like to get your thoughts first 'though,
please.

Thank you,

Sam

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: simple question about using an empty string building a partial index
Next
From: Sam Stearns
Date:
Subject: Fwd: Unable to Insert Row