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-30 09:06:05
Message-ID: 438D6B7D.5040104@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Tom,

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.

Regards,

Dirk

Tom Lane wrote:

>=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)com> writes:
>  
>
>>Yes, I think so. What search path do you mean? These tables were all 
>>temporary tables.
>>    
>>
>
>In that case they're most likely *not* in your search path, unless your
>session happens to have seized on the same pg_temp_nn schema they are
>in (in which case it'd have deleted them, so I guess it didn't).
>
>I'd suggest joining to pg_namespace to determine which schema(s) they
>are in, and then deleting with the explicit schema, ie, DROP TABLE
>pg_temp_nnn.bm_pagehits_... Note you'll probably need to be superuser
>to do this.
>
>Or you could just ignore them, because they'll get zapped automatically
>next time the containing pg_temp schema gets reused.
>
>			regards, tom lane
>  
>

-- 
/This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they are 
addressed. If you are not the intended recipient, you should not copy 
it, re-transmit it, use it or disclose its contents, but should return 
it to the sender immediately and delete your copy from your system. 
Thank you for your cooperation./

*Dirk Lutzebäck* <lutzeb(at)aeccom(dot)com> Tel +49.30.5362.1635 Fax .1638
CTO AEC/communications GmbH <http://www.aeccom.com>, Berlin, Germany

In response to

Responses

pgsql-bugs by date

Next:From: Yuriy VostrikoffDate: 2005-11-30 09:38:01
Subject: BUG #2079: strage PREPARE/EXECUTE behavior
Previous:From: Pierre BeyssacDate: 2005-11-29 21:56:03
Subject: BUG #2078: lock freeing problem in transaction (?)

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