| From: | Cyril SCETBON <scetbon(at)echo(dot)fr> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Error when trying to drop a tablespace | 
| Date: | 2008-06-16 15:40:27 | 
| Message-ID: | 4856896B.6090102@echo.fr | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi guys,
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 :
postgres=# select * from pg_class where reltablespace=100456;
 relname | relnamespace | reltype | relowner | relam | relfilenode | 
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | 
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers 
| relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules 
| relhassubclass | relfrozenxid | relacl | reloptions
---------+--------------+---------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------------+--------+------------
(0 rows)
100456 has been found with :
/oid2name -s|grep my_tbs
Any idea ?
-- 
Cyril SCETBON
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Decibel! | 2008-06-16 16:10:09 | Re: Money data type - Deprecated? | 
| Previous Message | Michael Fuhr | 2008-06-16 13:37:39 | Re: why sequential scan is used on indexed column ??? |