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
