From: | "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Why did pg_relation_filepath does not give a correct path ? |
Date: | 2012-04-20 09:35:53 |
Message-ID: | 4F912DF9.6030105@club-internet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 *************************
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-04-20 10:05:26 | Re: Why did pg_relation_filepath does not give a correct path ? |
Previous Message | Albe Laurenz | 2012-04-20 08:51:08 | Re: Money in numeric field |