=?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
pgsql-bugs by date
|Next:||From: Bruno Wolff III||Date: 2005-11-29 21:50:13|
|Subject: Re: On-line backup|
|Previous:||From: Dirk Lutzebäck||Date: 2005-11-29 20:59:15|
|Subject: Re: pg_dump: schema with OID 559701082 does not exist|