Re: error connecting to database: could not open relation

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: PontoSI - Consultoria, Informática e Serviços LDA <geral(at)pontosi(dot)pt>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: error connecting to database: could not open relation
Date: 2008-04-24 07:31:14
Message-ID: 20080424073114.GD14647@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 24, 2008 at 08:17:15AM +0100, "PontoSI - Consultoria, Informática e Serviços LDA" wrote:
>
> %/usr/local/bin/postgres --single -P -D /usr/local/pgsql/data/ <dbname>
> FATAL: XX000: could not open relation with OID 2661
> LOCATION: relation_open, heapam.c:700
> %
>
> <dbname> is the name of the database.

Ok, 2661 is definitly pg_cast_source_target_index on my system so the
-P should have caused postgres to ignore it. I'm out of ideas so I'm
sending it to the list to see if anyone else has any.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kaloyan Iliev 2008-04-24 08:11:14 I think this is a BUG?
Previous Message Steve Martin 2008-04-24 06:30:27 timestamp with time zone output incorrect