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-29 20:59:15
Message-ID: 438CC123.5050004@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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(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: Tom LaneDate: 2005-11-29 21:07:16
Subject: Re: pg_dump: schema with OID 559701082 does not exist
Previous:From: Tom LaneDate: 2005-11-29 20:40:38
Subject: Re: pg_dump: schema with OID 559701082 does not exist

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