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
