Re: Error when trying to drop a tablespace

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