Re: pg_dump: schema with OID 559701082 does not exist

Yes, I think so. What search path do you mean? These tables were all 
temporary tables.

Dirk


Tom Lane wrote:
> =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> 
>>The problem I'm facing is the following:
> 
> 
>>cs1=# select relname from pg_class where relname like 'bm%';
>>               relname
>>-----------------------------------
>>  bm_pagehits_1133271374_047421_941
>>  bm_pagehits_1133271378_920896_129
>>  bm_pagehits_1133282272_744243_536
>>  bm_pagehits_1133284780_743839_884
>>(4 rows)
> 
> 
>>cs1=# drop table bm_pagehits_1133271374_047421_941;
>>ERROR:  table "bm_pagehits_1133271374_047421_941" does not exist
> 
> 
> Uh, are you sure these are in a schema that's in your search path?
> 
> 			regards, tom lane