Horton

Re: pg_dump: schema with OID 559701082 does not exist

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dirk Lutzebäck <lutzeb@aeccom.com>
Cc: pgsql-bugs@postgresql.org
Date: 2005-11-30T15:04:36Z
Lists: pgsql-bugs 
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.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