Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 128756330F5 for ; Thu, 26 Aug 2010 17:14:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 88973-06-2 for ; Thu, 26 Aug 2010 20:14:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 9F28463305B for ; Thu, 26 Aug 2010 17:14:09 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 26 Aug 2010 15:14:08 -0500 Message-Id: <4C7684BE0200002500034CDC@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 26 Aug 2010 15:14:06 -0500 From: "Kevin Grittner" To: "Thom Brown" Cc: "Peter Eisentraut" , "pgsql-docs" Subject: Re: Primary Key index References: <1282164833.27661.5.camel@vanquo.pezone.net> <4C7525670200002500034BC1@gw.wicourts.gov> <4C7662FB0200002500034C51@gw.wicourts.gov> <4C7677520200002500034C80@gw.wicourts.gov> In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=__Part87AAB01E.2__=" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/95 X-Sequence-Number: 5919 This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__Part87AAB01E.2__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline Thom Brown wrote: > Yeah, I think that covers it well. :) I found a typo. :-( Another revision attached. -Kevin --=__Part87AAB01E.2__= Content-Type: text/plain; name="constraint-indexes-3.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="constraint-indexes-3.patch" KioqIGEvZG9jL3NyYy9zZ21sL2RkbC5zZ21sCi0tLSBiL2RvYy9zcmMvc2dtbC9kZGwuc2dtbAoq KioqKioqKioqKioqKioKKioqIDU1MCw1NTUgKioqKiBDUkVBVEUgVEFCTEUgcHJvZHVjdHMgKAot LS0gNTUwLDU2MCAtLS0tCiAgICAgPC9pbmRleHRlcm0+CiAgCiAgICAgPHBhcmE+CisgICAgIEFk ZGluZyBhIHVuaXF1ZSBjb25zdHJhaW50IHdpbGwgYXV0b21hdGljYWxseSBjcmVhdGUgYSB1bmlx dWUgYnRyZWUKKyAgICAgaW5kZXggb24gdGhlIGNvbHVtbiBvciBncm91cCBvZiBjb2x1bW5zIGRl Y2xhcmVkIGZvciB0aGUgY29uc3RyYWludC4KKyAgICA8L3BhcmE+CisgCisgICAgPHBhcmE+CiAg ICAgIEluIGdlbmVyYWwsIGEgdW5pcXVlIGNvbnN0cmFpbnQgaXMgdmlvbGF0ZWQgd2hlbiB0aGVy ZSBpcyBtb3JlIHRoYW4KICAgICAgb25lIHJvdyBpbiB0aGUgdGFibGUgd2hlcmUgdGhlIHZhbHVl cyBvZiBhbGwgb2YgdGhlCiAgICAgIGNvbHVtbnMgaW5jbHVkZWQgaW4gdGhlIGNvbnN0cmFpbnQg YXJlIGVxdWFsLgoqKioqKioqKioqKioqKioKKioqIDYyMyw2MjggKioqKiBDUkVBVEUgVEFCTEUg ZXhhbXBsZSAoCi0tLSA2MjgsNjM4IC0tLS0KICAgICA8L3BhcmE+CiAgCiAgICAgPHBhcmE+Cisg ICAgIEFkZGluZyBhIHByaW1hcnkga2V5IHdpbGwgYXV0b21hdGljYWxseSBjcmVhdGUgYSB1bmlx dWUgYnRyZWUgaW5kZXgKKyAgICAgb24gdGhlIGNvbHVtbiBvciBncm91cCBvZiBjb2x1bW5zIGRl Y2xhcmVkIGZvciB0aGUgcHJpbWFyeSBrZXkuCisgICAgPC9wYXJhPgorIAorICAgIDxwYXJhPgog ICAgICBBIHRhYmxlIGNhbiBoYXZlIGF0IG1vc3Qgb25lIHByaW1hcnkga2V5LiAgKFRoZXJlIGNh biBiZSBhbnkgbnVtYmVyCiAgICAgIG9mIHVuaXF1ZSBhbmQgbm90LW51bGwgY29uc3RyYWludHMs IHdoaWNoIGFyZSBmdW5jdGlvbmFsbHkgdGhlIHNhbWUKICAgICAgdGhpbmcsIGJ1dCBvbmx5IG9u ZSBjYW4gYmUgaWRlbnRpZmllZCBhcyB0aGUgcHJpbWFyeSBrZXkuKQoqKioqKioqKioqKioqKioK KioqIDgzMiw4MzcgKioqKiBDUkVBVEUgVEFCTEUgb3JkZXJfaXRlbXMgKAotLS0gODQyLDg1NyAt LS0tCiAgICAgPC9wYXJhPgogIAogICAgIDxwYXJhPgorICAgICBTaW5jZSBhIDxjb21tYW5kPkRF TEVURTwvY29tbWFuZD4gb2YgYSByb3cgZnJvbSBhIHJlZmVyZW5jZWQgdGFibGUKKyAgICAgb3Ig YW4gPGNvbW1hbmQ+VVBEQVRFPC9jb21tYW5kPiBvZiBhIHJlZmVyZW5jZWQgY29sdW1uIHdpbGwg cmVxdWlyZQorICAgICBhIHNjYW4gb2YgdGhlIHJlZmVyZW5jaW5nIHRhYmxlIGZvciByb3dzIG1h dGNoaW5nIHRoZSBvbGQgdmFsdWUsIGl0CisgICAgIGlzIG9mdGVuIGEgZ29vZCBpZGVhIHRvIGlu ZGV4IHRoZSByZWZlcmVuY2luZyBjb2x1bW5zLiAgQmVjYXVzZSBpdAorICAgICBpcyBub3QgYWx3 YXlzIG5lZWRlZCwgYW5kIHRoZXJlIGFyZSBtYW55IGNob2ljZXMgYXZhaWxhYmxlIG9uIGhvdwor ICAgICB0byBpbmRleCwgZGVjbGFyYXRpb24gb2YgYSBmb3JlaWduIGtleSBjb25zdHJhaW50IGRv ZXMgbm90CisgICAgIGF1dG9tYXRpY2FsbHkgY3JlYXRlIGFuIGluZGV4LgorICAgIDwvcGFyYT4K KyAKKyAgICA8cGFyYT4KICAgICAgTW9yZSBpbmZvcm1hdGlvbiBhYm91dCB1cGRhdGluZyBhbmQg ZGVsZXRpbmcgZGF0YSBpcyBpbiA8eHJlZgogICAgICBsaW5rZW5kPSJkbWwiPi4KICAgICA8L3Bh cmE+CioqKioqKioqKioqKioqKgoqKiogODc1LDg4MCAqKioqIENSRUFURSBUQUJMRSBjaXJjbGVz ICgKLS0tIDg5NSw5MDUgLS0tLQogICAgICBTZWUgYWxzbyA8bGluayBsaW5rZW5kPSJTUUwtQ1JF QVRFVEFCTEUtRVhDTFVERSI+PGNvbW1hbmQ+Q1JFQVRFCiAgICAgIFRBQkxFIC4uLiBDT05TVFJB SU5UIC4uLiBFWENMVURFPC8+PC9saW5rPiBmb3IgZGV0YWlscy4KICAgICA8L3BhcmE+CisgCisg ICAgPHBhcmE+CisgICAgIEFkZGluZyBhbiBleGNsdXNpb24gY29uc3RyYWludCB3aWxsIGF1dG9t YXRpY2FsbHkgY3JlYXRlIGFuIGluZGV4CisgICAgIG9mIHRoZSB0eXBlIHNwZWNpZmllZCBpbiB0 aGUgY29uc3RyYWludCBkZWNsYXJhdGlvbi4KKyAgICA8L3BhcmE+CiAgICA8L3NlY3QyPgogICA8 L3NlY3QxPgogIAo= --=__Part87AAB01E.2__=--