| From: | Sam Stearns <samtstearns(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Unable to Insert Row |
| Date: | 2011-05-03 06:53:43 |
| Message-ID: | BANLkTikz3KxQEma8NYXZcjq4KwRBpQKJLQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Stearns | 2011-05-03 09:03:07 | Fwd: Unable to Insert Row |
| Previous Message | Guillaume Lelarge | 2011-05-03 06:48:19 | Re: simple question about using an empty string building a partial index |