Skip site navigation (1) Skip section navigation (2)

Re: lookup fail at DROP USER

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: lookup fail at DROP USER
Date: 2005-08-30 01:11:35
Message-ID: 15739.1125364295@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jaime Casanova <systemguards(at)gmail(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-08-30 01:23:16
Subject: Re: lookup fail at DROP USER
Previous:From: Alvaro HerreraDate: 2005-08-30 00:40:33
Subject: Re: lookup fail at DROP USER

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