lookup fail at DROP USER - Mailing list pgsql-hackers

From Jaime Casanova
Subject lookup fail at DROP USER
Date
Msg-id c2d9e70e0508291719124d7d3d@mail.gmail.com
Whole thread Raw
Responses Re: lookup fail at DROP USER  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: lookup fail at DROP USER  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 ;)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: SHMMAX seems entirely broken in OS X 10.4.2
Next
From: Tom Lane
Date:
Subject: Re: Performance gain from reduction of GROUP BY memory allocations