Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kHicy-0000Dq-DE for pgsql-docs@arkaria.postgresql.org; Mon, 14 Sep 2020 07:10:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kHicw-0002MP-KF for pgsql-docs@arkaria.postgresql.org; Mon, 14 Sep 2020 07:10:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kHicw-0002Km-EI for pgsql-docs@lists.postgresql.org; Mon, 14 Sep 2020 07:10:14 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kHicp-0002iR-53 for pgsql-docs@postgresql.org; Mon, 14 Sep 2020 07:10:12 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTP id 2B58B62320; Mon, 14 Sep 2020 16:10:03 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.102.3 at oss.nttdata.com MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Mon, 14 Sep 2020 16:10:03 +0900 From: btkatsuragiyu To: Michael Paquier Cc: Fujii Masao , pgsql-docs@postgresql.org Subject: Re: Fix the example in the document of file-fdw In-Reply-To: <20200914050716.GC2183@paquier.xyz> References: <0cd5a9ebbec58bb16fd3f6eb20e401d9@oss.nttdata.com> <3b42a115-ebc9-d800-f51f-b5bf7a84201b@oss.nttdata.com> <20200914050716.GC2183@paquier.xyz> Message-ID: X-Sender: btkatsuragiyu@oss.nttdata.com User-Agent: Roundcube Webmail/1.1.9 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-09-14 14:07, Michael Paquier wrote: > On Mon, Sep 14, 2020 at 11:33:23AM +0900, Fujii Masao wrote: >> On 2020/09/14 11:19, btkatsuragiyu wrote: >>> This patch fixes the DDL in the document of file-fdw. >> >> Thanks for the patch! LGTM. I will commit it. > > Hmm. Instead of keeping a copy-paste of the same table in both > config.sgml and file-fdw.sgml, why not having only one? I agree with this comment. > It seems to me that we could just have the file_fdw doc refer to the > main > configuration, and it is not difficult to guess how the CREATE TABLE > query needs to be changed to map with foreign table. However, I think showing complete DDL including SERVER pglog and OPTIONS would be helpful to users who are not familiar with this feature. Regards, Yuta Katsuragi