Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7Xg-0003rd-Ea for pgsql-docs@arkaria.postgresql.org; Tue, 20 Nov 2018 15:02:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gP7Xe-0000os-7z for pgsql-docs@arkaria.postgresql.org; Tue, 20 Nov 2018 15:02:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7Xd-0000of-VQ for pgsql-docs@lists.postgresql.org; Tue, 20 Nov 2018 15:02:18 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7XW-0005sK-JW for pgsql-docs@lists.postgresql.org; Tue, 20 Nov 2018 15:02:16 +0000 Received: from pool-71-190-177-59.nycmny.fios.verizon.net ([71.190.177.59] helo=Ph33r-Retina.home) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP7XP-00089p-AP; Tue, 20 Nov 2018 15:02:09 +0000 Subject: Re: Documentation for create unique index is insuficient and (because of that) incorrect To: Tom Lane Cc: Bruce Momjian , emilioplatzer@gmail.com, pgsql-docs@lists.postgresql.org References: <154031939560.30897.14677735588262722042@wrigleys.postgresql.org> <20181120020542.GH28656@momjian.us> <9ba37df7-156b-b983-65b5-85ed096818b9@postgresql.org> <11323.1542725958@sss.pgh.pa.us> From: "Jonathan S. Katz" Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= xsFNBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABzTFKb25hdGhhbiBT LiBLYXR6IDxqb25hdGhhbi5rYXR6QGV4Y292ZW50dXJlcy5jb20+wsGXBBMBCABBAhsDBQkH hh+ABQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAFiEE+oS2la8r95ogZD/x8QSccp8cZScFAltS iSUCGQEACgkQ8QSccp8cZSfqrQ//bcMXxIqELT+DMa2C5IR4K3kRsdgxC2mcdsO4XgRxNLQF uZYqKa85EEZ+O4O/oHV5AgckWRcxCUNI0qafwC+QNTc/lBecmMipbP1X2+A8RBiTBRpSgo9y BOQ2xmA70k32Rk4hLd9EVTb0eXe9DoJIXWOsMlqqpqEuXiaoH5a2Ww6DdpCMN1vQZ/HavbAG cXV3MXahiqmBhH6Y0v1kZTJYEOCw0w4U1Q/vdUKw9/jv+fidU6I/jafHAxda7pI+dtNOyUtC bmv+9+KreUeBqyBXGmNFDZ4wa4TvYfaw6VV3acNT5KgcefQpd7JlzM+Vq3zz1tnR4C50nEpg DEpf0ANyeZ48v5+M7ycoIbxAHzwzKsiTaVmMDYRdnxmlv18UaWc/wmoI0wFAtcGjfw5KJLQv oolZYP18S0mpH2Q8SxcXbqekDvsHVW04Jkult9xZSeijdzUzcumflCZ2Y5VQKNjG99eZh5Iq JcUdYJH5mdmdFWgZdYTT6tZWHCMBBDBqktzLmyBezrqT0+j3E5lL/30tkatrcDkNPd3lE/j1 OxG10xVvCqzBvksBR0VX/RLKmj2wvIMqKoCav1GgBIdVAuLSO4CyWkWRRawpcREwUvNKyL2E uPXqsqTzYrYRxUM7GmjY3x40/IiA0uJCuxYEIeelmOwFEnadvyFUJxseVsczl/DOwU0EW1KH AAEQAL/IaP7aEPQxt4+H/YfZ9WkR69hZb4jdlLacui/PnXw4IDtIHopZpBkDqJWdhOtIBn8n v5FLRfVtzQcjuIcQ0fbuqmzl3Hap7gPnHOvBH6pVhSa1bWBcbdIeBJVmDmJyHsyrYa4lnIfx WO9BRq8bN8/FBzh6udMAVuN93k72ZvdFosQYlxLdr9Q4FuFa98pnzuwGqfyGMj7hOCc4LnQL gJdByj8jRB1hxtXQG419UYgsPYJJyA1kDhdAeFAGiXLVhlXJ2dwNlC8DRjGtT/WSZQVn9b3I 9NWohzFNMkOyYyYkqb35vXjNLki8EXQ6yY8peWWalbpo3b9kjDUPBr2EWxDMrNxhg0rfc14H wklJz5yX2MY8wR0SOseOFn7MfEuoVsXqTqIAiSf4OuwZPZmPGFeJJViFwyVTi+Y5wQtPQ27G RvNSWhNkMQfGO1t+mTK6IvVzMYN7PNOYUAEFL3Rv6aFPITfAVna505v/uHkEKe4A2NXjw5hj OmyQvjhzkpxbUf3/u9M6SiddHHO3AcoBp5dckdyo4RcgFlBbz+GRs4ignKTMF2X3vTxrsgP2 DrmzKYcSJ92LCtsK3X2imWF9hjGQmYTDHL8fSKUK8SCYFPlZcF7vzvi5NdFSD3MTyScJqXSO h83EvGYBuiDHAuOOF107i2j/I9poHDL2GpN0nAspABEBAAHCwXwEGAEIACYWIQT6hLaVryv3 miBkP/HxBJxynxxlJwUCW1KHAAIbDAUJB4YfgAAKCRDxBJxynxxlJ0XjD/0QNlIRkI/huLgb IZES46UcrGm3T6oEAXRAZOsGG4qPPFoP9v4YGO1M5gwxMF97GX0A3KyOvryKGyPLqrLWSA/l oAAGtSS3woTMlUJ0stM31jDgAV7HHObRrrxUWbyZJU4rLDBY11MGkRBCqeGYpE7yf+tjAo0n ba1IZzy76E7B0ykSg4nIRPm+QOeGpcLLm04o8Ndjujdtq+SI2YokmVdLu3bEocisPu8Akmsf X7gaBONzTGH/nZ4zCp3qwEGFHGVmDJ5PhAvEWqmAMb+l2drSsdQJBhpLcJECAcK8/SJQ0ryd y1idlCCLi0U3Z4DYIBiC+M87lGtheeharJECLmDGjRE5Oi2H2pQQ0Ok1SwHIAj0MaeJOIvz0 bGd5WdmYUR0WHIjr5pKfiOhHx8JZUKWK1rNbYZbgRqpSUlSYCpdCDhbyi7EOiin6swMIehca zuamo6eL4jSILVqBcDuQadI4BU2x9jqzFiEX1HVAh9Q427qOubL4TY+xTbEFWMxwyPjXdSPy zgaD3N1KK0TBdjOCVZFEe7JDh1lGz00jVK+6nNeDUjGNzyoxnlRgLAVRwT75kcf0rNrVv06S VqcYOKZqrhUEl7mmIWH+BTfEsct9tKXK/hajfAIWZGCXDWPNjk7UeVRCkQv5mHMqutalyCqp 4MnZ+/WyYxsR4qcchRZhAg== Message-ID: Date: Tue, 20 Nov 2018 10:02:01 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <11323.1542725958@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="6WZtBOpXYqVK8pxgP3PR1OZPhY2NSq6JY" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6WZtBOpXYqVK8pxgP3PR1OZPhY2NSq6JY Content-Type: multipart/mixed; boundary="QF3Hvj7Kl3hV3XKTXmTRVRAv0yL0Ye8xs"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane Cc: Bruce Momjian , emilioplatzer@gmail.com, pgsql-docs@lists.postgresql.org Message-ID: Subject: Re: Documentation for create unique index is insuficient and (because of that) incorrect References: <154031939560.30897.14677735588262722042@wrigleys.postgresql.org> <20181120020542.GH28656@momjian.us> <9ba37df7-156b-b983-65b5-85ed096818b9@postgresql.org> <11323.1542725958@sss.pgh.pa.us> In-Reply-To: <11323.1542725958@sss.pgh.pa.us> --QF3Hvj7Kl3hV3XKTXmTRVRAv0yL0Ye8xs Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 11/20/18 9:59 AM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 11/19/18 9:05 PM, Bruce Momjian wrote: >>> On Tue, Oct 23, 2018 at 06:29:55PM +0000, PG Doc comments form wrote:= >>>> In https://www.postgresql.org/docs/11/static/indexes-unique.html the= re are >>>> omited clausules >=20 >>> The first URL is an example and is not intended to be the complete >>> syntax. >=20 >> In fairness, the "INCLUDE" clause was added, which is new to PostgreSQ= L >> 11, so it could raise the question as to why aren't other clauses ther= e. >=20 > Yes. That was a dumb idea; the correct fix is to take that out, becaus= e > it's not appropriate here. There might be room for an additional secti= on > later in the chapter that discusses INCLUDE, but we shouldn't be > cluttering the discussion of fundamental concepts like unique indexes > with that. Shows how closely I read the docs. +1 on removing INCLUDE from UNIQUE indexes. Also +1 on having a section on covering indexes. Jonathan --QF3Hvj7Kl3hV3XKTXmTRVRAv0yL0Ye8xs-- --6WZtBOpXYqVK8pxgP3PR1OZPhY2NSq6JY Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlv0IekACgkQ8QSccp8c ZSfDzxAAj7ziku75ouhZzcRFRLnEeYmGIFtzyldSeJsCiZpU4cOpwrNdpQCZVE1c rGFRtv97oRxm0nEzxgG9EguPwqcik39MT3h+OYcFWCJCPFLKbYCQX91wTmbSpVny feHCFGWHV2ixOBH6FZ1uuyq8yTN5s4P69PZLXwcvd8NU9Qzv9e58DlmgHeCS1IMp hoFXYX5e42gdk/Rc4Y1hm/E8Qjc8b0dyl77dr6mWiFgwpKajoICyznoUWzfzdLdg i39ZyelxsP5clKaElInmQBBG35JuvtK+lgMGy45dNAyp5Q1xLZkOWZhv/K3bZm/G pYL7LAMoKBUflk4ImE7HHPfQZ2Kf+9WYTEg+VxpPmRUWOyHxM6lWrjmNmdkMjShQ duuBmM/2WbVI4yXV0grpUuEuR8amxHz6uF+dkUcEe36IbnRCFEVQPKiquDbNLqm9 NHV6j0Upxtx+g6K13MQyD3ABIWbjABWdU5FbafUcr94PnQp4aiWoYCg24EF1Tyoh mb2eW9jV026AqmywRTxyWth+ZtGeCBkHMgxcD5keQ8J+3aQBwFHUR7unmuZ6ZRA7 ph/BEge+qkiP2+cdU5nYFvpP2Eif2BC5LpUIMzrqmgGSr+KoNtypbmFjdony7t5J 92zB6y1Ns+v/6MwmFCsIbggr1u98kQWtaLG6VZXvwKqJHnGqS5Y= =2NUz -----END PGP SIGNATURE----- --6WZtBOpXYqVK8pxgP3PR1OZPhY2NSq6JY--