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

Re: pg_dump: schema with OID 559701082 does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lutzeb(at)aeccom(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Date: 2005-11-29 20:40:38
Message-ID: 9655.1133296838@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Dirk LutzebäckDate: 2005-11-29 20:59:15
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Previous:From: Dirk LutzebäckDate: 2005-11-29 20:13:13
Subject: Re: pg_dump: schema with OID 559701082 does not exist

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