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