Jaime Casanova <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster