From: Sam Stearns <samtstearns@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Unable to Insert Row
Date: Wed, 4 May 2011 08:22:06 +0930
Message-ID: <BANLkTimbiS7Hfz5JvOFKKxjV7RQ4XQooWg@mail.gmail.com> (raw)
In-Reply-To: <BANLkTikTqXtq1+05BVmUBsb-DaVSWrBbxQ@mail.gmail.com>
References: <BANLkTikz3KxQEma8NYXZcjq4KwRBpQKJLQ@mail.gmail.com>
<4DBFB066.9010202@orkash.com>
<BANLkTimpNKa_S-Ys8Ra8ksBRv5-UB7fGVw@mail.gmail.com>
<BANLkTikTqXtq1+05BVmUBsb-DaVSWrBbxQ@mail.gmail.com>
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@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Sam Stearns <samtstearns@gmail.com>
> Date: Tue, May 3, 2011 at 6:32 PM
> Subject: Re: [ADMIN] Unable to Insert Row
> To: Adarsh Sharma <adarsh.sharma@orkash.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.sharma@orkash.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
>>>
>>>
>>
>>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samtstearns@gmail.com
Subject: Re: Unable to Insert Row
In-Reply-To: <BANLkTimbiS7Hfz5JvOFKKxjV7RQ4XQooWg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox