David Christensen <david@endpoint.com> writes:
> On Feb 7, 2010, at 11:04 AM, Tom Lane wrote:
>> pg_relation_filepath(regclass) returns text
>> which would expose the output of relpath(), ie, the $PGDATA-relative
>> path name of the relation.
> Should this return multiple values (text[] or SETOF text) for tables
> which wrapped over the single file-limits (1GB, IIRC)? So: "pg_tblspc/
> 48372/8.5_201002061/68483/172744", "pg_tblspc/
> 48372/8.5_201002061/68483/172744.1", etc?
No, I'm not inclined to go there. The set of actually existing segments
seems too volatile; and anyone worried about this probably can add a
star to the end of the pathname ...
regards, tom lane