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 по дате отправления: