Why did pg_relation_filepath does not give a correct path ?

Поиск
Список
Период
Сортировка
От F. BROUARD / SQLpro
Тема Why did pg_relation_filepath does not give a correct path ?
Дата
Msg-id 4F912DF9.6030105@club-internet.fr
обсуждение исходный текст
Ответы Re: Why did pg_relation_filepath does not give a correct path ?
Список pgsql-general
Hi,

according to the documentation, the function pg_relation_filepath
"returns the entire file path name (relative to the database cluster's
data directory PGDATA) of the relation"

When my table are located in the pg_default tablespace, the gievn
relative path is correct

When my table are located on a specific tablespace, this function
returns incorrect dats such as :

pg_tblspc/25310/PG_9.1_201105231/16594/25311

only the "PG_9.1_201105231/16594/25311" is correct.

What does the "pg_tblspc/25310" do ???

How can I obtain the correct relative path ?

Thanks

--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR  :  http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************


В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Money in numeric field
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Why did pg_relation_filepath does not give a correct path ?