Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group