Error when trying to drop a tablespace

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

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