Re: Error when trying to drop a tablespace

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Error when trying to drop a tablespace
Дата
Msg-id 7496.1213823664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Error when trying to drop a tablespace  (Cyril SCETBON <scetbon@echo.fr>)
Ответы Re: Error when trying to drop a tablespace  (Cyril SCETBON <scetbon@echo.fr>)
Список pgsql-general
Cyril SCETBON <scetbon@echo.fr> writes:
> Tom Lane wrote:
>> So which database has OID 100456?
>> select datname from pg_database where oid = 100456;
>>
> it's not a database oid but a tablespace oid

[ squint... ]  There shouldn't be any files directly under a tablespace
directory, except possibly a PG_VERSION marker file.  What should be
there are per-database directories, and those are what contain the
files.  So that's why I assumed 100456 must be a database directory.
You sure it isn't?

            regards, tom lane

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

Предыдущее
От: Steve Clark
Дата:
Сообщение: renumber table
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: renumber table