Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 9408415B6234;
	Sun,  4 Dec 2011 12:56:16 -0400 (AST)
Received: from relay3-d.mail.gandi.net ([217.70.183.195])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andrew@dunslane.net>)
	id 1RXFMM-0001F8-FM; Sun, 04 Dec 2011 16:56:16 +0000
X-Originating-IP: 217.70.178.130
Received: from mfilter1-d.gandi.net (mfilter1-d.gandi.net [217.70.178.130])
	by relay3-d.mail.gandi.net (Postfix) with ESMTP id BC53BA806E;
	Sun,  4 Dec 2011 17:55:49 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at mfilter1-d.gandi.net
Received: from relay3-d.mail.gandi.net ([217.70.183.195])
	by mfilter1-d.gandi.net (mfilter1-d.gandi.net [10.0.15.180])
	(amavisd-new, port 10024)
	with ESMTP id 6mbA3qPGd8Vb; Sun,  4 Dec 2011 17:55:48 +0100 (CET)
X-Originating-IP: 98.27.54.176
Received: from [192.168.10.146] (cpe-098-027-054-176.nc.res.rr.com
	[98.27.54.176]) (Authenticated sender: adsend@dunslane.net)
	by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id 32E20A8081;
	Sun,  4 Dec 2011 17:55:42 +0100 (CET)
Message-ID: <4EDBA60D.2050904@dunslane.net>
Date: Sun, 04 Dec 2011 11:55:41 -0500
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.17) Gecko/20110428 Fedora/3.1.10-1.fc14
	Lightning/1.0b3pre Thunderbird/3.1.10
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Magnus Hagander <magnus@hagander.net>, Bruce Momjian <bruce@momjian.us>,
	PostgreSQL-documentation <pgsql-docs@postgresql.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Moving tablespaces
References: 
 <CABUevEx2xYV==WRxWdMr=mS3Q1orBUvJcXa8AZx_LVbL122g5Q@mail.gmail.com>
	<201112041612.pB4GCHt06225@momjian.us>
	<CABUevEzuRQLddyY2yypiZpjWzzEzz0p66TgzoXGuz+jLxKgdkg@mail.gmail.com>
	<23636.1323016890@sss.pgh.pa.us>
In-Reply-To: <23636.1323016890@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201112/10
X-Sequence-Number: 7117



On 12/04/2011 11:41 AM, Tom Lane wrote:
>
>> 1) Remove the column. Rely on the symlink. Create a
>> pg_get_tablespace_location(oid) function, that could be used by
>> pg_dumpall and friends, that just reads the symlink.
> Hm, how portable is symlink-reading?  If we can actually do that
> without big headaches, then +1.
>


I wondered that, specifically about Windows junction points, but we seem 
to have support for it already in dirmod.c::pgreadlink(). Surely there's 
no other currently supported platform where it would even be a question?

cheers

andrew