Re: Error when trying to drop a tablespace

Tom Lane wrote:
> Cyril SCETBON <scetbon(at)echo(dot)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