Hi,

i have installed the latest CVS, 8.1beta1.

and get an error executing at DROP USER. these are the commands i
execute and the error i get:

in: psql -U postgres template1

CREATE USER deimos;
CREATE TABLESPACE sgis_dat OWNER deimos LOCATION '/data/postgres/sgis_dat';
CREATE TABLESPACE sgis_idx OWNER deimos LOCATION '/data/postgres/sgis_idx';
CREATE DATABASE sgis WITH OWNER deimos ENCODING 'latin1' TABLESPACE sgis_dat;

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

i get these lines from the log file:

LOG: statement: drop database sgis;
LOG: transaction ID wrap limit is 2147484144, limited by database "postgres"
LOG: statement: drop tablespace sgis_idx;
LOG: statement: drop tablespace sgis_dat;
LOG: statement: drop user deimos;
ERROR: cache lookup failed for tablespace 16396

i hope it helps...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Mon, Aug 29, 2005 at 07:19:21PM -0500, Jaime Casanova wrote:

> 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

Confirmed. Most likely this is a problem in shared dependency handling.
I'll submit a fix after dinner.

Thanks for the report.

--
Alvaro Herrera <alvherre[]alvh.no-ip.org> Architect, www.EnterpriseDB.com
"La felicidad no es mañana. La felicidad es ahora"

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I'll submit a fix after dinner.

Done already ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings