Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAs6n-0001mV-7w for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2014 02:21:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WAs6m-0003Xi-4m for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2014 02:21:00 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAs6j-0003XX-SI for pgsql-hackers@postgresql.org; Wed, 05 Feb 2014 02:20:58 +0000 Received: from tama50.ecl.ntt.co.jp ([129.60.39.147]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAs6g-0006Jz-Sn for pgsql-hackers@postgresql.org; Wed, 05 Feb 2014 02:20:57 +0000 Received: from mfs6.rdh.ecl.ntt.co.jp (mfs6.rdh.ecl.ntt.co.jp [129.60.39.149]) by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id s152KpIt024876; Wed, 5 Feb 2014 11:20:51 +0900 Received: from mfs6.rdh.ecl.ntt.co.jp (localhost.localdomain [127.0.0.1]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id 7943CE011B; Wed, 5 Feb 2014 11:20:51 +0900 (JST) Received: from imail3.m.ecl.ntt.co.jp (imail3.m.ecl.ntt.co.jp [129.60.5.248]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id 62624E011A; Wed, 5 Feb 2014 11:20:51 +0900 (JST) Received: from [129.60.241.197] ([129.60.241.197]) by imail3.m.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id s152KpFd008682; Wed, 5 Feb 2014 11:20:51 +0900 Message-ID: <52F19FF7.3010403@lab.ntt.co.jp> Date: Wed, 05 Feb 2014 11:20:39 +0900 From: Etsuro Fujita User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: Robert Haas CC: Tom Lane , Shigeru Hanada , PostgreSQL-development Subject: Re: inherit support for foreign tables References: <12432.1384406906@sss.pgh.pa.us> <10163.1384786524@sss.pgh.pa.us> <52DDD071.9090405@ak.jp.nec.com> <52E5F3FD.6050000@lab.ntt.co.jp> <52E6137B.1080704@lab.ntt.co.jp> <32648.1391097891@sss.pgh.pa.us> <20275.1391119500@sss.pgh.pa.us> <52EF09D3.8060302@lab.ntt.co.jp> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-TM-AS-MML: No X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org (2014/02/04 20:56), Robert Haas wrote: > On Sun, Feb 2, 2014 at 10:15 PM, Etsuro Fujita > wrote: >> Allowing ALTER COLUMN SET STORAGE on foreign tables would make sense if for >> example, "SELECT * INTO local_table FROM foreign_table" did create a new >> local table of columns having the storage types associated with those of a >> foreign table? > > Seems like a pretty weak argument. It's not that we can't find > strange corner cases where applying SET STORAGE to a foreign table > doesn't do something; it's that they *are* strange corner cases. The > options as we normally don't understand them just aren't sensible in > this context, and a good deal of work has been put into an alternative > options framework, which is what authors of FDWs ought to be using. I just wanted to discuss the possiblity of allowing SET STORAGE on a foreign table, but I've got the point. I'll resume the patch review. Thanks, Best regards, Etsuro Fujita -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers