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 ;)