Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZUkB0-0001Ac-7n for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2015 23:32:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZUkAz-0008Ej-PZ for pgsql-docs@arkaria.postgresql.org; Wed, 26 Aug 2015 23:32:17 +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 1ZUkAy-0008Bg-HB for pgsql-docs@postgresql.org; Wed, 26 Aug 2015 23:32:16 +0000 Received: from mail-qg0-x235.google.com ([2607:f8b0:400d:c04::235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZUkAw-0002XZ-5m for pgsql-docs@postgresql.org; Wed, 26 Aug 2015 23:32:15 +0000 Received: by qgeg42 with SMTP id g42so1788682qge.1 for ; Wed, 26 Aug 2015 16:32:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=HMit9WlmnLuF5AU0GIlijgFOMq83kF+AetVKhD3qHTE=; b=IK5RWOfq+VnxXHc7SIwk7n6Czh6Zw38gaZqPEx7844YRw9NZxTSdm8cphJch0T8kUT gSxMP+tNIeBodoKIjZ7wMT0HOaXFixYw30swfsX3NzoLIat9c1RneJu/hQiigrxznM6V /qyH67hDzD8AHrulYP7NELeLrOX23vcud0Oz6JCT0Wk/6fgXcIamoQh6pAaP2UojB7Pz H4DNX3HvmQaHOJ9/G2n/FVdAhoqg+6LOhb4jHiogOgemIa2VJrcKY7kc7aePHGZiznqc xOLrvxW30noSNlsRCZdf4WjoMsCc0HJHSG2xsyi3z0o0GJSya+d42kR1n50RhSeuWJyN SBUg== X-Received: by 10.140.130.196 with SMTP id 187mr2067722qhc.58.1440631933320; Wed, 26 Aug 2015 16:32:13 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.20.247 with HTTP; Wed, 26 Aug 2015 16:31:53 -0700 (PDT) From: Josh Kupershmidt Date: Wed, 26 Aug 2015 19:31:53 -0400 Message-ID: Subject: Rewording for ALTER TABLE ... ADD table_constraint_using_index To: pgsql-docs Content-Type: multipart/mixed; boundary=001a1134f126a3d07e051e3f42db X-Pg-Spam-Score: -2.7 (--) 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 --001a1134f126a3d07e051e3f42db Content-Type: multipart/alternative; boundary=001a1134f126a3d079051e3f42d9 --001a1134f126a3d079051e3f42d9 Content-Type: text/plain; charset=UTF-8 I'd like to propose the following slight rewording for the note about ALTER TABLE ... ADD table_constraint_using_index. The existing text says one may "install it [the existing index] as an official constraint". The "official constraint" phrase sounds like weasel wording to me -- how is a UNIQUE constraint more "official" than an UNIQUE index? Then "install" makes it sound like some installation process is going on that you should be aware of. I like "convert" slightly better instead. Josh --001a1134f126a3d079051e3f42d9 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I'd like to propose the following slight rewording for= the note about ALTER TABLE ... ADD=C2=A0table_constraint_using_index. The = existing text says one may "install it [the existing index] as an offi= cial constraint".

The "official constraint&quo= t; phrase sounds like weasel wording to me -- how is a UNIQUE constraint mo= re "official" than an UNIQUE index? Then "install" make= s it sound like some installation process is going on that you should be aw= are of. I like "convert" slightly better instead.

<= /div>
Josh
--001a1134f126a3d079051e3f42d9-- --001a1134f126a3d07e051e3f42db Content-Type: text/plain; charset=US-ASCII; name="alter_table_table_constraint_using_index.diff" Content-Disposition: attachment; filename="alter_table_table_constraint_using_index.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_idtf1f840 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dt bCBiL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbApuZXcgZmls ZSBtb2RlIDEwMDY0NAppbmRleCA5MmU5Y2U4Li43ODRmNWI0CioqKiBhL2Rv Yy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbAotLS0gYi9kb2Mvc3Jj L3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwKKioqKioqKioqKioqKioqIEFM VEVSIFRBQkxFIEFMTCBJTiBUQUJMRVNQQUNFIDxyZXBsYWNlYWIKKioqIDMy MCwzMjcgKioqKgogICAgICAgICBBZGRpbmcgYSBjb25zdHJhaW50IHVzaW5n IGFuIGV4aXN0aW5nIGluZGV4IGNhbiBiZSBoZWxwZnVsIGluCiAgICAgICAg IHNpdHVhdGlvbnMgd2hlcmUgYSBuZXcgY29uc3RyYWludCBuZWVkcyB0byBi ZSBhZGRlZCB3aXRob3V0IGJsb2NraW5nCiAgICAgICAgIHRhYmxlIHVwZGF0 ZXMgZm9yIGEgbG9uZyB0aW1lLiAgVG8gZG8gdGhhdCwgY3JlYXRlIHRoZSBp bmRleCB1c2luZwohICAgICAgICA8Y29tbWFuZD5DUkVBVEUgSU5ERVggQ09O Q1VSUkVOVExZPC8+LCBhbmQgdGhlbiBpbnN0YWxsIGl0IGFzIGFuCiEgICAg ICAgIG9mZmljaWFsIGNvbnN0cmFpbnQgdXNpbmcgdGhpcyBzeW50YXguICBT ZWUgdGhlIGV4YW1wbGUgYmVsb3cuCiAgICAgICAgPC9wYXJhPgogICAgICAg PC9ub3RlPgogICAgICA8L2xpc3RpdGVtPgotLS0gMzIwLDMyNyAtLS0tCiAg ICAgICAgIEFkZGluZyBhIGNvbnN0cmFpbnQgdXNpbmcgYW4gZXhpc3Rpbmcg aW5kZXggY2FuIGJlIGhlbHBmdWwgaW4KICAgICAgICAgc2l0dWF0aW9ucyB3 aGVyZSBhIG5ldyBjb25zdHJhaW50IG5lZWRzIHRvIGJlIGFkZGVkIHdpdGhv dXQgYmxvY2tpbmcKICAgICAgICAgdGFibGUgdXBkYXRlcyBmb3IgYSBsb25n IHRpbWUuICBUbyBkbyB0aGF0LCBjcmVhdGUgdGhlIGluZGV4IHVzaW5nCiEg ICAgICAgIDxjb21tYW5kPkNSRUFURSBVTklRVUUgSU5ERVggQ09OQ1VSUkVO VExZPC8+LCBhbmQgdGhlbiBjb252ZXJ0IGl0IHRvIGEKISAgICAgICAgY29u c3RyYWludCB1c2luZyB0aGlzIHN5bnRheC4gIFNlZSB0aGUgZXhhbXBsZSBi ZWxvdy4KICAgICAgICA8L3BhcmE+CiAgICAgICA8L25vdGU+CiAgICAgIDwv bGlzdGl0ZW0+Cg== --001a1134f126a3d07e051e3f42db Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --001a1134f126a3d07e051e3f42db--