Re: pg_dump: schema with OID 559701082 does not exist

Dirk Lutzebäck <lutzeb@aeccom.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