Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZWweN-00040G-BN for pgsql-docs@arkaria.postgresql.org; Wed, 02 Sep 2015 01:15:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZWweM-0007oO-4n for pgsql-docs@arkaria.postgresql.org; Wed, 02 Sep 2015 01:15:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZWwe0-00072v-JQ for pgsql-docs@postgresql.org; Wed, 02 Sep 2015 01:15:20 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZWwdx-0000II-Mf for pgsql-docs@postgresql.org; Wed, 02 Sep 2015 01:15:19 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1ZWwdw-00069a-Lf; Tue, 01 Sep 2015 21:15:16 -0400 Date: Tue, 1 Sep 2015 21:15:16 -0400 From: Bruce Momjian To: Mehmet Emin =?utf-8?Q?KARAKA=C5=9E?= Cc: pgsql-docs@postgresql.org Subject: Re: Wrong Typo Message-ID: <20150902011516.GH27332@momjian.us> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Wed, Jul 29, 2015 at 12:21:43PM +0300, Mehmet Emin KARAKAŞ wrote: > Hi Everybody, > > I saw wrong typo in `ALTER FOREIGN TABLE´ documentation page.(http:// > www.postgresql.org/docs/9.1/static/sql-alterforeigntable.html). On the bottom > of page have an example like that. > ALTER FOREIGN TABLE myschema.distributors OPTIONS (ADD opt1 'value', SET opt2, > 'value2', DROP opt3 'value3'); > > Don't need to put comma  set options values. This is wrong usage and not > working. Need to remove comma after opt2. All of documentation series the same > (9.1,9.2,9.3,9.4...).True usage is; >   > ALTER FOREIGN TABLE myschema.distributors OPTIONS (ADD opt1 'value', SET opt2 > 'value2', DROP opt3 'value3'); This has been fixed, thanks. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs