Re: Unable to Insert Row

Dump/restore of table resolved this problem.

On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns(at)gmail(dot)com> 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(at)gmail(dot)com> wrote:
>> ---------- Forwarded message ----------
>> From: Sam Stearns <samtstearns(at)gmail(dot)com>
>> Date: Tue, May 3, 2011 at 6:32 PM
>> Subject: Re: [ADMIN] Unable to Insert Row
>> To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
>>
>>
>> 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(dot)sharma(at)orkash(dot)com> 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
>>>>
>>>>
>>>
>>>
>>
>