lookup fail at DROP USER

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

Responses

Browse pgsql-hackers by date

  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