Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-08-30 00:25:51
Subject: Re: Performance gain from reduction of GROUP BY memory allocations
Previous:From: Tom LaneDate: 2005-08-30 00:18:50
Subject: SHMMAX seems entirely broken in OS X 10.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group