Dump/restore of table resolved this problem. On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns@xxxxxxxxx> wrote: > Does anyone else have any ideas on how to solve this problem besides > this mysterious repair command? > > On Tue, May 3, 2011 at 6:33 PM, Sam Stearns <samtstearns@xxxxxxxxx> wrote: >> ---------- Forwarded message ---------- >> From: Sam Stearns <samtstearns@xxxxxxxxx> >> Date: Tue, May 3, 2011 at 6:32 PM >> Subject: Re: Unable to Insert Row >> To: Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> >> >> >> Thanks, Adarsh. >> >> I don't see any references to a repair command in the 8.3 doco. >> >> On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote: >>> Try again after repairing the tables with the repair command. >>> >>> Best Regards, >>> Adarsh >>> >>> Sam Stearns wrote: >>>> >>>> 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 >>>> >>>> >>> >>> >> > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
