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

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

Previous
From: Steve Clark
Date:
Subject: renumber table
Next
From: "Scott Marlowe"
Date:
Subject: Re: renumber table