Re: Error when trying to drop a tablespace - Mailing list pgsql-general

From Tom Lane
Subject Re: Error when trying to drop a tablespace
Date
Msg-id 18959.1213706375@sss.pgh.pa.us
Whole thread Raw
In response to Error when trying to drop a tablespace  (Cyril SCETBON <scetbon@echo.fr>)
List pgsql-general
Cyril SCETBON <scetbon@echo.fr> writes:
> I get the following error :

> postgres=# DROP TABLESPACE IF EXISTS my_tbs;
> ERROR:  tablespace "my_tbs" is not empty

> I've searched in pg_class and I'm not able to find a relation which
> refers to my_tbs with :

Maybe there's something in a different database?

I'd just look into the filesystem and see what's underneath the
tablespace directory ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Slony-I configuration problem, probably due to custom casts in 8.3
Next
From: Philippe Grégoire
Date:
Subject: Re: inserting to a multi-table view