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?
Regards
Pavan