Re: ERROR: could not open relation with OID 2836

From: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID 2836
Date: 2008-06-26 05:32:32
Message-ID: 486329F0.1070307@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com> writes:
>> Basically I should reinstall again PG with the same configuration and
>> wait 1 night. Any log you need or want? anything to do besides doing the
>> same I did?
>
> Umm ... if I reinstall PG and wait one night, I'm quite sure that
> nothing much will happen. You need to show me how to reproduce the
> problem you're having.
>
> regards, tom lane

Dont know exactly what you mean, if you are talking about the moment
that I receive the error...

# pg_dump -U postgres db
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not open relation with
OID 2836
pg_dump: The command was: SELECT proretset, prosrc, probin,
proallargtypes, proargmodes, proargnames, provolatile, proisstrict,
prosecdef, proconfig, procost, prorows, (SELECT lanname FROM
pg_catalog.pg_language WHERE oid = prolang) as lanname FROM
pg_catalog.pg_proc WHERE oid = '17018'::pg_catalog.oid

Anything else I can do or give you, just tell me and I will try...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-06-26 05:52:57 Re: ERROR: could not open relation with OID 2836
Previous Message Tom Lane 2008-06-26 05:17:17 Re: ERROR: could not open relation with OID 2836