Re: Error when trying to drop a tablespace - Mailing list pgsql-general

From Cyril SCETBON
Subject Re: Error when trying to drop a tablespace
Date
Msg-id 485A1347.40608@echo.fr
Whole thread Raw
In response to Re: Error when trying to drop a tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Cyril SCETBON
Date:
Subject: Re: Error when trying to drop a tablespace
Next
From: Cyril SCETBON
Date:
Subject: Re: Error when trying to drop a tablespace