Error when trying to drop a tablespace

Поиск
Список
Период
Сортировка
От Cyril SCETBON
Тема Error when trying to drop a tablespace
Дата
Msg-id 4856896B.6090102@echo.fr
обсуждение исходный текст
Ответы Re: Error when trying to drop a tablespace  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Error when trying to drop a tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Arnošt
Дата:
Сообщение: problem with to_ascii() function in version 8.3.3
Следующее
От: Klint Gore
Дата:
Сообщение: Re: inserting to a multi-table view