Hello,

 

(Postgres 8.3, Linux)

 

while trying to drop a tablespace, I get an error  tablespace "xxx" is
not empty.

 

There are effectively a few files within the corresponding  folder, 

but all of them are empty and a few months old.

 

moreover, pg_class does not contain any references to this tablespace.

 

 

What should I do to safely get rid of this tablespace:

 

- Is there a way to obtains all dependent objects of a tablespace ?

- How is this error triggered ? comes it from a check of the folder
content, or from the catalog  ?

 

 

many thanks,

 

Marc Mamin

 

Reply via email to