Re: Unable To Drop Tablespace

Hi there

We are trying to drop a table space on RDS Postgres . We have removed the objects etc, but it still won't drop.

I have checked and there's no reference anywhere to this tablespace but it complains it's not empty.

I checked if it is a default for a database, revoked all privileges on the tablespace.

We dropped the database but underpinning tablespace remained but when I query to see if any reference i get no hits.

"Select c.relname,t.spcname from pg_class c JOIN pg_tablespace t ON c.reltablespace=t.oid where t.spcname='mytablespace'

I dont find any objects referencing. Kindly let me know if anything else needs to be checked?