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
On Mon, Aug 29, 2005 at 07:19:21PM -0500, Jaime Casanova wrote:
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
Confirmed. Most likely this is a problem in shared dependency
Jaime Casanova [EMAIL PROTECTED] writes:
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
Fixed ... it seems the shared-dependency patch missed DROP TABLESPACE.
If you need to
Alvaro Herrera [EMAIL PROTECTED] writes:
I'll submit a fix after dinner.
Done already ...
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings