Re: Error when trying to drop a tablespace

Поиск
Список
Период
Сортировка
От Cyril SCETBON
Тема Re: Error when trying to drop a tablespace
Дата
Msg-id 485A1347.40608@echo.fr
обсуждение исходный текст
Ответ на Re: Error when trying to drop a tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Tom Lane wrote:
> 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.
>
under the tablespace directory I got :

PG_VERSION file and  oidtbs directory
> You sure it isn't?
>
sure
>             regards, tom lane
>

--
Cyril SCETBON

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

Предыдущее
От: Cyril SCETBON
Дата:
Сообщение: Re: Error when trying to drop a tablespace
Следующее
От: Cyril SCETBON
Дата:
Сообщение: Re: Error when trying to drop a tablespace