Re: lookup fail at DROP USER - Mailing list pgsql-hackers

Jaime Casanova <systemguards@gmail.com> writes:
> the i drop the objects:
> DROP DATABASE sgis;
> DROP TABLESPACE sgis_dat;
> DROP TABLESPACE sgis_idx;
> DROP USER deimos;
> ERROR:  cache lookup failed for tablespace 16396

Fixed ... it seems the shared-dependency patch missed DROP TABLESPACE.
If you need to clean up from this, you can just manually remove the
relevant rows in pg_shdepend (look for rows with classid = 1213 and
objid not equal to any OID in pg_tablespace).

Thanks for the report!
        regards, tom lane