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: lutzeb@aeccom.com
Cc: pgsql-bugs@postgresql.org
Date: 2005-11-29T20:40:38Z
Lists: pgsql-bugs 
=?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