Re: Primary Key index

On 25 August 2010 20:15, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> Thom Brown <thom@linux.com> wrote:
>> On 18 August 2010 21:53, Peter Eisentraut <peter_e@gmx.net> wrote:
>>> On ons, 2010-08-18 at 16:52 +0100, Thom Brown wrote:
>
>>>> I attach a patch to add information to the Primary Keys section
>>>> of the Constraints page.  While the information already exists
>>>> on the CREATE TABLE, I don't think a brief mention on the page
>>>> specifically concerning primary keys could hurt.
>>>>
>>>> So here's a patch to add it.  Worth adding?
>>>
>>> <firstterm> is probably not appropriate here, because you are not
>>> defining the term for the first time.
>>>
>> That is true.
>
> It looks like discussion died here.  Do you want to propose a new
> patch?  (I'd be happy to give it a shot if you'd rather.)

Sure, go for it. :)

> In any
> event, we should probably mention this for all three constraint
> types which automatically create an index: PRIMARY KEY, UNIQUE, and
> EXCLUSION.

Agreed, and I didn't actually think about the fact that exclusion
constraints add indexes.

--
Thom Brown
Registered Linux user: #516935