Skip site navigation (1) Skip section navigation (2)

Re: Primary Key index

From: Thom Brown <thom(at)linux(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Primary Key index
Date: 2010-08-25 19:21:15
Message-ID: AANLkTimDi72ry2YH=URABA6n=n-eO8nGpf4pxUEcRH38@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
On 25 August 2010 20:15, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Thom Brown <thom(at)linux(dot)com> wrote:
>> On 18 August 2010 21:53, Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Responses

pgsql-docs by date

Next:From: Mariano ReingartDate: 2010-08-25 20:04:09
Subject: Compiling and Linking Dynamically-Loaded Functions on Windows
Previous:From: Kevin GrittnerDate: 2010-08-25 19:15:03
Subject: Re: Primary Key index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group