Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZKNYa-0003qE-52 for pgsql-docs@arkaria.postgresql.org; Wed, 29 Jul 2015 09:21:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZKNYZ-0004gI-DY for pgsql-docs@arkaria.postgresql.org; Wed, 29 Jul 2015 09:21:47 +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 1ZKNYY-0004gB-Sp for pgsql-docs@postgresql.org; Wed, 29 Jul 2015 09:21:47 +0000 Received: from mail-vn0-x233.google.com ([2607:f8b0:400c:c0f::233]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZKNYW-0007sg-7U for pgsql-docs@postgresql.org; Wed, 29 Jul 2015 09:21:45 +0000 Received: by vnds125 with SMTP id s125so1066292vnd.1 for ; Wed, 29 Jul 2015 02:21:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=dpk54E9aE8QUla2h8VNkfDGhOd/yjLSa6oFF/E0EC2o=; b=Pzu+UEaWCe19zqaMfTTc/NoN9cTIpPvQCrkc1SZSt/+cjrnkd9nYYX75DubLNygypB JKyEe6Zlthp/OuIZOe2ewj7LBNUvO6lzp7m3EVj6e1ap6EEihdRIxePl6jEoqShbPt5B JcTBpW1lyFchMZVDPlw5eee4aix00r2VXWP4jypF1NPnvzIrSWThFG5Jt0GenfBroKsV fEOcZpYVhi8HpqBHmatWRvhuX0+yncQD8ZVxdy/ga3KTl0Sh41H1oCqr2ESSSo1ciAEP c7MOqq86e55L3XZDGDuBlXFIvED6NAbDF7qAIh8lAiPV0ZRNuhNG8bRlZhc4qPBw4Qrt P1eg== MIME-Version: 1.0 X-Received: by 10.52.32.34 with SMTP id f2mr50760951vdi.11.1438161703236; Wed, 29 Jul 2015 02:21:43 -0700 (PDT) Received: by 10.31.80.194 with HTTP; Wed, 29 Jul 2015 02:21:43 -0700 (PDT) Date: Wed, 29 Jul 2015 12:21:43 +0300 Message-ID: Subject: Wrong Typo From: =?UTF-8?Q?Mehmet_Emin_KARAKA=C5=9E?= To: pgsql-docs@postgresql.org Content-Type: multipart/alternative; boundary=bcaec51d2b8073804b051c001d02 X-Pg-Spam-Score: -2.4 (--) 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 --bcaec51d2b8073804b051c001d02 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Everybody, I saw wrong typo in `ALTER FOREIGN TABLE=C2=B4 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'); Thanks. --=20 MEHMET EM=C4=B0N KARAKA=C5=9E --bcaec51d2b8073804b051c001d02 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi Everybody,

I saw wrong typo in `ALTER FOREIGN TA= BLE=C2=B4 documentation page.(http://www.postgresql.org/docs/9.1/stat= ic/sql-alterforeigntable.html). On the bottom of page have an example l= ike that.
ALTER FOREIGN TABLE myschema.distributors OPTIONS (ADD opt1 &#= 39;value', SET opt2, 'value2', DROP opt3 'value3');
=
Don't need to put comma=C2=A0 set options values. This is wrong usa= ge and not working. Need to remove comma after opt2. All of documentation s= eries the same(9.1,9.2,9.3,9.4...).True usage is;
=C2=A0
ALTER FOREIG= N TABLE myschema.distributors OPTIONS (ADD opt1 'value', SET opt2 &= #39;value2', DROP opt3 'value3');

Thanks.

MEHMET EM=C4=B0N = KARAKA=C5=9E

--bcaec51d2b8073804b051c001d02--