Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2D57AB5DF8F for ; Fri, 3 Jun 2011 01:07:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 72342-10 for ; Fri, 3 Jun 2011 04:07:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from defer-pm01.ocn.ad.jp (defer-pm01.ocn.ad.jp [122.1.234.5]) by mail.postgresql.org (Postfix) with ESMTP id C08DFB6240D for ; Fri, 3 Jun 2011 01:07:12 -0300 (ADT) Received: from vsxkg005.ocn.ad.jp (vsxkg005.ocn.ad.jp [211.129.17.144]) by defer-pm01.ocn.ad.jp (Postfix) with ESMTP id 55B701975 for ; Fri, 3 Jun 2011 13:07:10 +0900 (JST) Received: from sgc001.ocn.ne.jp (ov-orv-hkg005.ocn.ad.jp [210.232.239.110]) by vsxkg005.ocn.ad.jp (Postfix) with SMTP id 931798E7 for ; Fri, 3 Jun 2011 13:06:34 +0900 (JST) Received: from [192.168.1.120] (unknown [61.199.203.168]) by sgc001.ocn.ne.jp (Postfix) with ESMTP id 657CE75F for ; Fri, 3 Jun 2011 13:06:34 +0900 (JST) Message-ID: <4DE85DCA.1080107@metrosystems.co.jp> Date: Fri, 03 Jun 2011 13:06:34 +0900 From: Shigeru Hanada User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: ALTER FOREIGN TABLE: unsupported features Content-Type: multipart/mixed; boundary="------------030304040900030102060709" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/7 X-Sequence-Number: 6781 This is a multi-part message in MIME format. --------------030304040900030102060709 Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Hi, I noticed that ALTER FOREIGN TABLE document mentions unsupported features: - table inheritance - oid system column - CHECK constraint - per-column FDW options http://developer.postgresql.org/pgdocs/postgres/sql-alterforeigntable.html These features have been proposed once, but were not committed. On the other hand, CREATE FOREIGN TABLE document seems fine as is, it doesn't mention any unsupported feature. Please find attached a patch for the document correction. The patch also replaces the phrase "table" with "foreign table" for wording consistency. Regards, -- Shigeru Hanada --------------030304040900030102060709 Content-Type: text/plain; name="alter_foreign_table_doc.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="alter_foreign_table_doc.patch" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfZm9yZWlnbl90YWJsZS5zZ21s IGIvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9mb3JlaWduX3RhYmxlLnNnbWwKaW5kZXggYzJl YmRhYy4uYWJkMzM1YiAxMDA2NDQKKioqIGEvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9mb3Jl aWduX3RhYmxlLnNnbWwKLS0tIGIvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9mb3JlaWduX3Rh YmxlLnNnbWwKKioqKioqKioqKioqKioqIEFMVEVSIEZPUkVJR04gVEFCTEUgPHJlcGxhY2Vh YmxlIGNsYXNzPSIKKioqIDY1LDcxICoqKioKICAgICAgIDxwYXJhPgogICAgICAgIFRoaXMg Zm9ybSBkcm9wcyBhIGNvbHVtbiBmcm9tIGEgZm9yZWlnbiB0YWJsZS4KICAgICAgICBZb3Ug d2lsbCBuZWVkIHRvIHNheSA8bGl0ZXJhbD5DQVNDQURFPC8+IGlmCiEgICAgICAgYW55dGhp bmcgb3V0c2lkZSB0aGUgdGFibGUgZGVwZW5kcyBvbiB0aGUgY29sdW1uOyBmb3IgZXhhbXBs ZSwKICAgICAgICB2aWV3cy4KICAgICAgICBJZiA8bGl0ZXJhbD5JRiBFWElTVFM8L2xpdGVy YWw+IGlzIHNwZWNpZmllZCBhbmQgdGhlIGNvbHVtbgogICAgICAgIGRvZXMgbm90IGV4aXN0 LCBubyBlcnJvciBpcyB0aHJvd24uIEluIHRoaXMgY2FzZSBhIG5vdGljZQotLS0gNjUsNzEg LS0tLQogICAgICAgPHBhcmE+CiAgICAgICAgVGhpcyBmb3JtIGRyb3BzIGEgY29sdW1uIGZy b20gYSBmb3JlaWduIHRhYmxlLgogICAgICAgIFlvdSB3aWxsIG5lZWQgdG8gc2F5IDxsaXRl cmFsPkNBU0NBREU8Lz4gaWYKISAgICAgICBhbnl0aGluZyBvdXRzaWRlIHRoZSBmb3JlaWdu IHRhYmxlIGRlcGVuZHMgb24gdGhlIGNvbHVtbjsgZm9yIGV4YW1wbGUsCiAgICAgICAgdmll d3MuCiAgICAgICAgSWYgPGxpdGVyYWw+SUYgRVhJU1RTPC9saXRlcmFsPiBpcyBzcGVjaWZp ZWQgYW5kIHRoZSBjb2x1bW4KICAgICAgICBkb2VzIG5vdCBleGlzdCwgbm8gZXJyb3IgaXMg dGhyb3duLiBJbiB0aGlzIGNhc2UgYSBub3RpY2UKKioqKioqKioqKioqKioqIEFMVEVSIEZP UkVJR04gVEFCTEUgPHJlcGxhY2VhYmxlIGNsYXNzPSIKKioqIDEyNSwxMzEgKioqKgogICAg ICA8dGVybT48bGl0ZXJhbD5PUFRJT05TICggWyBBREQgfCBTRVQgfCBEUk9QIF0gPHJlcGxh Y2VhYmxlIGNsYXNzPSJQQVJBTUVURVIiPm9wdGlvbjwvcmVwbGFjZWFibGU+IFsnPHJlcGxh Y2VhYmxlIGNsYXNzPSJQQVJBTUVURVIiPnZhbHVlPC9yZXBsYWNlYWJsZT4nXSBbLCAuLi4g XSApPC9saXRlcmFsPjwvdGVybT4KICAgICAgPGxpc3RpdGVtPgogICAgICAgPHBhcmE+CiEg ICAgICAgQ2hhbmdlIG9wdGlvbnMgZm9yIHRoZSBmb3JlaWduIHRhYmxlIG9yIHRoZSBjb2x1 bW4gb2YgdGhlIGZvcmVpZ24gdGFibGUuCiAgICAgICAgPGxpdGVyYWw+QUREPC8+LCA8bGl0 ZXJhbD5TRVQ8Lz4sIGFuZCA8bGl0ZXJhbD5EUk9QPC8+CiAgICAgICAgc3BlY2lmeSB0aGUg YWN0aW9uIHRvIGJlIHBlcmZvcm1lZC4gIDxsaXRlcmFsPkFERDwvPiBpcyBhc3N1bWVkCiAg ICAgICAgaWYgbm8gb3BlcmF0aW9uIGlzIGV4cGxpY2l0bHkgc3BlY2lmaWVkLiAgT3B0aW9u IG5hbWVzIG11c3QgYmUKLS0tIDEyNSwxMzEgLS0tLQogICAgICA8dGVybT48bGl0ZXJhbD5P UFRJT05TICggWyBBREQgfCBTRVQgfCBEUk9QIF0gPHJlcGxhY2VhYmxlIGNsYXNzPSJQQVJB TUVURVIiPm9wdGlvbjwvcmVwbGFjZWFibGU+IFsnPHJlcGxhY2VhYmxlIGNsYXNzPSJQQVJB TUVURVIiPnZhbHVlPC9yZXBsYWNlYWJsZT4nXSBbLCAuLi4gXSApPC9saXRlcmFsPjwvdGVy bT4KICAgICAgPGxpc3RpdGVtPgogICAgICAgPHBhcmE+CiEgICAgICAgQ2hhbmdlIG9wdGlv bnMgZm9yIHRoZSBmb3JlaWduIHRhYmxlLgogICAgICAgIDxsaXRlcmFsPkFERDwvPiwgPGxp dGVyYWw+U0VUPC8+LCBhbmQgPGxpdGVyYWw+RFJPUDwvPgogICAgICAgIHNwZWNpZnkgdGhl IGFjdGlvbiB0byBiZSBwZXJmb3JtZWQuICA8bGl0ZXJhbD5BREQ8Lz4gaXMgYXNzdW1lZAog ICAgICAgIGlmIG5vIG9wZXJhdGlvbiBpcyBleHBsaWNpdGx5IHNwZWNpZmllZC4gIE9wdGlv biBuYW1lcyBtdXN0IGJlCioqKioqKioqKioqKioqKiBBTFRFUiBGT1JFSUdOIFRBQkxFIDxy ZXBsYWNlYWJsZSBjbGFzcz0iCioqKiAxNDcsMTYyICoqKioKICAgIDwvcGFyYT4KICAKICAg IDxwYXJhPgohICAgIFlvdSBtdXN0IG93biB0aGUgdGFibGUgdG8gdXNlIDxjb21tYW5kPkFM VEVSIEZPUkVJR04gVEFCTEU8Lz4uCiAgICAgVG8gY2hhbmdlIHRoZSBzY2hlbWEgb2YgYSBm b3JlaWduIHRhYmxlLCB5b3UgbXVzdCBhbHNvIGhhdmUKICAgICA8bGl0ZXJhbD5DUkVBVEU8 L2xpdGVyYWw+IHByaXZpbGVnZSBvbiB0aGUgbmV3IHNjaGVtYS4KLSAgICBUbyBhZGQgdGhl IHRhYmxlIGFzIGEgbmV3IGNoaWxkIG9mIGEgcGFyZW50IHRhYmxlLCB5b3UgbXVzdCBvd24g dGhlCi0gICAgcGFyZW50IHRhYmxlIGFzIHdlbGwuCiAgICAgVG8gYWx0ZXIgdGhlIG93bmVy LCB5b3UgbXVzdCBhbHNvIGJlIGEgZGlyZWN0IG9yIGluZGlyZWN0IG1lbWJlciBvZiB0aGUg bmV3CiAgICAgb3duaW5nIHJvbGUsIGFuZCB0aGF0IHJvbGUgbXVzdCBoYXZlIDxsaXRlcmFs PkNSRUFURTwvbGl0ZXJhbD4gcHJpdmlsZWdlIG9uCiEgICAgdGhlIHRhYmxlJ3Mgc2NoZW1h LiAgKFRoZXNlIHJlc3RyaWN0aW9ucyBlbmZvcmNlIHRoYXQgYWx0ZXJpbmcgdGhlIG93bmVy CiEgICAgZG9lc24ndCBkbyBhbnl0aGluZyB5b3UgY291bGRuJ3QgZG8gYnkgZHJvcHBpbmcg YW5kIHJlY3JlYXRpbmcgdGhlIHRhYmxlLgohICAgIEhvd2V2ZXIsIGEgc3VwZXJ1c2VyIGNh biBhbHRlciBvd25lcnNoaXAgb2YgYW55IHRhYmxlIGFueXdheS4pCiAgICA8L3BhcmE+CiAg IDwvcmVmc2VjdDE+CiAgCi0tLSAxNDcsMTYxIC0tLS0KICAgIDwvcGFyYT4KICAKICAgIDxw YXJhPgohICAgIFlvdSBtdXN0IG93biB0aGUgZm9yZWlnbiB0YWJsZSB0byB1c2UgPGNvbW1h bmQ+QUxURVIgRk9SRUlHTiBUQUJMRTwvPi4KICAgICBUbyBjaGFuZ2UgdGhlIHNjaGVtYSBv ZiBhIGZvcmVpZ24gdGFibGUsIHlvdSBtdXN0IGFsc28gaGF2ZQogICAgIDxsaXRlcmFsPkNS RUFURTwvbGl0ZXJhbD4gcHJpdmlsZWdlIG9uIHRoZSBuZXcgc2NoZW1hLgogICAgIFRvIGFs dGVyIHRoZSBvd25lciwgeW91IG11c3QgYWxzbyBiZSBhIGRpcmVjdCBvciBpbmRpcmVjdCBt ZW1iZXIgb2YgdGhlIG5ldwogICAgIG93bmluZyByb2xlLCBhbmQgdGhhdCByb2xlIG11c3Qg aGF2ZSA8bGl0ZXJhbD5DUkVBVEU8L2xpdGVyYWw+IHByaXZpbGVnZSBvbgohICAgIHRoZSBm b3JlaWduIHRhYmxlJ3Mgc2NoZW1hLiAgKFRoZXNlIHJlc3RyaWN0aW9ucyBlbmZvcmNlIHRo YXQgYWx0ZXJpbmcgdGhlCiEgICAgb3duZXIgZG9lc24ndCBkbyBhbnl0aGluZyB5b3UgY291 bGRuJ3QgZG8gYnkgZHJvcHBpbmcgYW5kIHJlY3JlYXRpbmcgdGhlCiEgICAgZm9yZWlnbiB0 YWJsZS4KISAgICBIb3dldmVyLCBhIHN1cGVydXNlciBjYW4gYWx0ZXIgb3duZXJzaGlwIG9m IGFueSBmb3JlaWduIHRhYmxlIGFueXdheS4pCiAgICA8L3BhcmE+CiAgIDwvcmVmc2VjdDE+ CiAgCioqKioqKioqKioqKioqKiBBTFRFUiBGT1JFSUdOIFRBQkxFIDxyZXBsYWNlYWJsZSBj bGFzcz0iCioqKiAxOTcsMjAzICoqKioKICAgICAgICA8dGVybT48cmVwbGFjZWFibGUgY2xh c3M9IlBBUkFNRVRFUiI+bmV3X25hbWU8L3JlcGxhY2VhYmxlPjwvdGVybT4KICAgICAgICA8 bGlzdGl0ZW0+CiAgICAgICAgIDxwYXJhPgohICAgICAgICAgTmV3IG5hbWUgZm9yIHRoZSB0 YWJsZS4KICAgICAgICAgPC9wYXJhPgogICAgICAgIDwvbGlzdGl0ZW0+CiAgICAgICA8L3Zh cmxpc3RlbnRyeT4KLS0tIDE5NiwyMDIgLS0tLQogICAgICAgIDx0ZXJtPjxyZXBsYWNlYWJs ZSBjbGFzcz0iUEFSQU1FVEVSIj5uZXdfbmFtZTwvcmVwbGFjZWFibGU+PC90ZXJtPgogICAg ICAgIDxsaXN0aXRlbT4KICAgICAgICAgPHBhcmE+CiEgICAgICAgICBOZXcgbmFtZSBmb3Ig dGhlIGZvcmVpZ24gdGFibGUuCiAgICAgICAgIDwvcGFyYT4KICAgICAgICA8L2xpc3RpdGVt PgogICAgICAgPC92YXJsaXN0ZW50cnk+CioqKioqKioqKioqKioqKiBBTFRFUiBGT1JFSUdO IFRBQkxFIDxyZXBsYWNlYWJsZSBjbGFzcz0iCioqKiAyMzYsMjQyICoqKioKICAgICAgICA8 dGVybT48cmVwbGFjZWFibGUgY2xhc3M9IlBBUkFNRVRFUiI+bmV3X293bmVyPC9yZXBsYWNl YWJsZT48L3Rlcm0+CiAgICAgICAgPGxpc3RpdGVtPgogICAgICAgICA8cGFyYT4KISAgICAg ICAgIFRoZSB1c2VyIG5hbWUgb2YgdGhlIG5ldyBvd25lciBvZiB0aGUgdGFibGUuCiAgICAg ICAgIDwvcGFyYT4KICAgICAgICA8L2xpc3RpdGVtPgogICAgICAgPC92YXJsaXN0ZW50cnk+ Ci0tLSAyMzUsMjQxIC0tLS0KICAgICAgICA8dGVybT48cmVwbGFjZWFibGUgY2xhc3M9IlBB UkFNRVRFUiI+bmV3X293bmVyPC9yZXBsYWNlYWJsZT48L3Rlcm0+CiAgICAgICAgPGxpc3Rp dGVtPgogICAgICAgICA8cGFyYT4KISAgICAgICAgIFRoZSB1c2VyIG5hbWUgb2YgdGhlIG5l dyBvd25lciBvZiB0aGUgZm9yZWlnbiB0YWJsZS4KICAgICAgICAgPC9wYXJhPgogICAgICAg IDwvbGlzdGl0ZW0+CiAgICAgICA8L3Zhcmxpc3RlbnRyeT4KKioqKioqKioqKioqKioqIEFM VEVSIEZPUkVJR04gVEFCTEUgPHJlcGxhY2VhYmxlIGNsYXNzPSIKKioqIDI0NSwyNTEgKioq KgogICAgICAgIDx0ZXJtPjxyZXBsYWNlYWJsZSBjbGFzcz0iUEFSQU1FVEVSIj5uZXdfc2No ZW1hPC9yZXBsYWNlYWJsZT48L3Rlcm0+CiAgICAgICAgPGxpc3RpdGVtPgogICAgICAgICA8 cGFyYT4KISAgICAgICAgIFRoZSBuYW1lIG9mIHRoZSBzY2hlbWEgdG8gd2hpY2ggdGhlIHRh YmxlIHdpbGwgYmUgbW92ZWQuCiAgICAgICAgIDwvcGFyYT4KICAgICAgICA8L2xpc3RpdGVt PgogICAgICAgPC92YXJsaXN0ZW50cnk+Ci0tLSAyNDQsMjUwIC0tLS0KICAgICAgICA8dGVy bT48cmVwbGFjZWFibGUgY2xhc3M9IlBBUkFNRVRFUiI+bmV3X3NjaGVtYTwvcmVwbGFjZWFi bGU+PC90ZXJtPgogICAgICAgIDxsaXN0aXRlbT4KICAgICAgICAgPHBhcmE+CiEgICAgICAg ICBUaGUgbmFtZSBvZiB0aGUgc2NoZW1hIHRvIHdoaWNoIHRoZSBmb3JlaWduIHRhYmxlIHdp bGwgYmUgbW92ZWQuCiAgICAgICAgIDwvcGFyYT4KICAgICAgICA8L2xpc3RpdGVtPgogICAg ICAgPC92YXJsaXN0ZW50cnk+CioqKioqKioqKioqKioqKiBBTFRFUiBGT1JFSUdOIFRBQkxF IDxyZXBsYWNlYWJsZSBjbGFzcz0iCioqKiAyNjIsMjcyICoqKioKICAgICA8cGFyYT4KICAg ICAgQ29uc2lzdGVuY3kgd2l0aCB0aGUgZm9yZWlnbiBzZXJ2ZXIgaXMgbm90IGNoZWNrZWQg d2hlbiBhIGNvbHVtbiBpcwogICAgICBhZGRlZCBvciByZW1vdmVkIHdpdGggPGxpdGVyYWw+ QUREIENPTFVNTjwvbGl0ZXJhbD4gb3IKISAgICAgPGxpdGVyYWw+RFJPUCBDT0xVTU48L2xp dGVyYWw+LCBhIHN5c3RlbSA8bGl0ZXJhbD5vaWQ8Lz4gY29sdW1uIGlzIGFkZGVkCiEgICAg IG9yIHJlbW92ZWQsIGEgPGxpdGVyYWw+Q0hFQ0s8Lz4gb3IgPGxpdGVyYWw+Tk9UIE5VTEw8 Lz4gY29uc3RyYWludCBpcwogICAgICBhZGRlZCwgb3IgY29sdW1uIHR5cGUgaXMgY2hhbmdl ZCB3aXRoIDxsaXRlcmFsPlNFVCBEQVRBIFRZUEU8Lz4uICBJdCBpcyB0aGUKISAgICAgdXNl cidzIHJlc3BvbnNpYmlsaXR5IHRvIGVuc3VyZSB0aGF0IHRoZSB0YWJsZSBkZWZpbml0aW9u IG1hdGNoZXMgdGhlCiEgICAgIHJlbW90ZSBzaWRlLgogICAgIDwvcGFyYT4KICAKICAgICA8 cGFyYT4KLS0tIDI2MSwyNzAgLS0tLQogICAgIDxwYXJhPgogICAgICBDb25zaXN0ZW5jeSB3 aXRoIHRoZSBmb3JlaWduIHNlcnZlciBpcyBub3QgY2hlY2tlZCB3aGVuIGEgY29sdW1uIGlz CiAgICAgIGFkZGVkIG9yIHJlbW92ZWQgd2l0aCA8bGl0ZXJhbD5BREQgQ09MVU1OPC9saXRl cmFsPiBvcgohICAgICA8bGl0ZXJhbD5EUk9QIENPTFVNTjwvbGl0ZXJhbD4sIGEgPGxpdGVy YWw+Tk9UIE5VTEw8Lz4gY29uc3RyYWludCBpcwogICAgICBhZGRlZCwgb3IgY29sdW1uIHR5 cGUgaXMgY2hhbmdlZCB3aXRoIDxsaXRlcmFsPlNFVCBEQVRBIFRZUEU8Lz4uICBJdCBpcyB0 aGUKISAgICAgdXNlcidzIHJlc3BvbnNpYmlsaXR5IHRvIGVuc3VyZSB0aGF0IHRoZSBmb3Jl aWduIHRhYmxlIGRlZmluaXRpb24gbWF0Y2hlcwohICAgICB0aGUgcmVtb3RlIHNpZGUuCiAg ICAgPC9wYXJhPgogIAogICAgIDxwYXJhPgoqKioqKioqKioqKioqKiogQUxURVIgRk9SRUlH TiBUQUJMRSBteXNjaGVtYS5kaXN0cmlidXRvcgoqKiogMzA4LDMxNCAqKioqCiAgCiAgICA8 cGFyYT4KICAgICA8Y29tbWFuZD5BTFRFUiBGT1JFSUdOIFRBQkxFIERST1AgQ09MVU1OPC8+ IGNhbiBiZSB1c2VkIHRvIGRyb3AgdGhlIG9ubHkKISAgICBjb2x1bW4gb2YgYSBmb3JlaWdu IHRhYmxlLCBsZWF2aW5nIGEgemVyby1jb2x1bW4gdGFibGUuICBUaGlzIGlzIGFuCiAgICAg ZXh0ZW5zaW9uIG9mIFNRTCwgd2hpY2ggZGlzYWxsb3dzIHplcm8tY29sdW1uIGZvcmVpZ24g dGFibGVzLgogICAgPC9wYXJhPgogICA8L3JlZnNlY3QxPgotLS0gMzA2LDMxMiAtLS0tCiAg CiAgICA8cGFyYT4KICAgICA8Y29tbWFuZD5BTFRFUiBGT1JFSUdOIFRBQkxFIERST1AgQ09M VU1OPC8+IGNhbiBiZSB1c2VkIHRvIGRyb3AgdGhlIG9ubHkKISAgICBjb2x1bW4gb2YgYSBm b3JlaWduIHRhYmxlLCBsZWF2aW5nIGEgemVyby1jb2x1bW4gZm9yZWlnbiB0YWJsZS4gIFRo aXMgaXMgYW4KICAgICBleHRlbnNpb24gb2YgU1FMLCB3aGljaCBkaXNhbGxvd3MgemVyby1j b2x1bW4gZm9yZWlnbiB0YWJsZXMuCiAgICA8L3BhcmE+CiAgIDwvcmVmc2VjdDE+Cg== --------------030304040900030102060709--