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 4859736F.6000704@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:
>
>> Albe Laurenz wrote:
>>
>>> is there anything in this directory?
>>>
>
>
>> find .
>> .
>> ./100456
>> ./100456/100738
>> ./100456/102333
>> ./100456/103442
>> ./100456/102618
>> ./100456/104159
>> ./100456/101234
>> ./100456/102658
>> ./100456/104477
>>
>
> So which database has OID 100456?
>     select datname from pg_database where oid = 100456;
>
it's not a database oid but a tablespace oid
>
>> ./100456/1259
>>
>
> Since the output lists some system catalogs, I'm betting this tablespace
> is actually the default for that database.
>
>             regards, tom lane
>
>

--
Cyril SCETBON - Ingénieur bases de données
AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon@jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat
Bâtiment Marco Polo C2 - Bureau 202
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************


pgsql-general by date:

Previous
From: Pavel Arnošt
Date:
Subject: Re: problem with to_ascii() function in version 8.3.3
Next
From: Cyril SCETBON
Date:
Subject: Re: Error when trying to drop a tablespace