pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sam Stearns <samtstearns@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Unable to Insert Row
Date: Thu, 5 May 2011 08:23:16 +0930
Message-ID: <BANLkTimE7yAxD-qnUQ0gLhbKc2tN3Mp2vA@mail.gmail.com> (raw)
In-Reply-To: <BANLkTimbiS7Hfz5JvOFKKxjV7RQ4XQooWg@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>
	<BANLkTimbiS7Hfz5JvOFKKxjV7RQ4XQooWg@mail.gmail.com>

Dump/restore of table resolved this problem.

On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns@gmail.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@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
>>>>
>>>>
>>>
>>>
>>
>



view thread (6+ messages)  latest in thread

Message-ID: <BANLkTimE7yAxD-qnUQ0gLhbKc2tN3Mp2vA@mail.gmail.com>
Permalink:  ../BANLkTimE7yAxD-qnUQ0gLhbKc2tN3Mp2vA@mail.gmail.com/
Also on:    postgresql.org/message-id/BANLkTimE7yAxD-qnUQ0gLhbKc2tN3Mp2vA@mail.gmail.com

 · 

reply

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: <BANLkTimE7yAxD-qnUQ0gLhbKc2tN3Mp2vA@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