From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | lookup fail at DROP USER |
Date: | 2005-08-30 00:19:21 |
Message-ID: | c2d9e70e0508291719124d7d3d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 ;)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-30 00:25:51 | Re: Performance gain from reduction of GROUP BY memory allocations |
Previous Message | Tom Lane | 2005-08-30 00:18:50 | SHMMAX seems entirely broken in OS X 10.4.2 |