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 <[email protected]> wrote: > ---------- Forwarded message ---------- > From: Sam Stearns <[email protected]> > Date: Tue, May 3, 2011 at 6:32 PM > Subject: Re: [ADMIN] Unable to Insert Row > To: Adarsh Sharma <[email protected]> > > > 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 <[email protected]> > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
