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 21:07:16
Message-ID: 9989.1133298436@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:
> 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

In response to

Responses

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2005-11-29 21:50:13
Subject: Re: On-line backup
Previous:From: Dirk LutzebäckDate: 2005-11-29 20:59:15
Subject: Re: pg_dump: schema with OID 559701082 does not exist

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