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

Re: pg_dump: schema with OID 559701082 does not exist

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Date: 2005-11-30 21:44:11
Message-ID: 438E1D2B.7020907@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Yes, I finally found the reference in pg_type.

Thanks for your help!

Regards,

Dirk


Tom Lane wrote:
> =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)com> writes:
> 
>>I have now deleted every temp table I know from pg_temp_nnn using your 
>>approach but still can't dump the schema:
>>pg_dump: schema with OID 559701082 does not exist
>>I could'nt find any reference to  559701082 in pg_class, pg_namespace or 
>>pg_proc.
> 
> 
> Better keep looking then.  See
> http://www.postgresql.org/docs/8.1/static/catalogs.html
> (adjust link for your PG version) to find out which catalogs reference
> pg_namespace.
> 
> 			regards, tom lane


In response to

pgsql-bugs by date

Next:From: Susan FuDate: 2005-11-30 21:53:44
Subject: BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function runs correctly on win postgres 8.1
Previous:From: Tom LaneDate: 2005-11-30 18:12:35
Subject: Re: BUG #2079: strage PREPARE/EXECUTE behavior

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