Re: [DOCS] Primary Key index

2010-08-26 Thread Tom Lane
"Kevin Grittner" writes: > Thom Brown wrote: >> Yeah, I think that covers it well. :) > I found a typo. :-( Another revision attached. Applied to HEAD and 9.0, with a couple of trivial editorial adjustments. regards, tom lane -- Sent via pgsql-docs mailing list (pg

Re: [DOCS] Primary Key index

2010-08-26 Thread Kevin Grittner
Thom Brown wrote: > Yeah, I think that covers it well. :) I found a typo. :-( Another revision attached. -Kevin *** a/doc/src/sgml/ddl.sgml --- b/doc/src/sgml/ddl.sgml *** *** 550,555 CREATE TABLE products ( --- 550,560 + Adding a unique constraint

Re: [DOCS] Primary Key index

2010-08-26 Thread Thom Brown
On 26 August 2010 20:16, Kevin Grittner wrote: > Thom Brown wrote: > >> Looks good.  Do we usually got into fine details such as the name >> of the index?  They'll see the index name returned when they >> create the table or add the constraint anyway, and if they missed >> it they only need to do

Re: [DOCS] Primary Key index

2010-08-26 Thread Kevin Grittner
Thom Brown wrote: > Looks good. Do we usually got into fine details such as the name > of the index? They'll see the index name returned when they > create the table or add the constraint anyway, and if they missed > it they only need to do a "\dt tablename" to find out what it was. Hmmm...

Re: [DOCS] Primary Key index

2010-08-26 Thread Thom Brown
On 26 August 2010 18:50, Kevin Grittner wrote: > Thom Brown wrote: >> Kevin Grittner wrote: > >>> 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. :) > > Initial stab at it attached. > > I'm tor

Re: [DOCS] Primary Key index

2010-08-26 Thread Kevin Grittner
Thom Brown wrote: > Kevin Grittner wrote: >> 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. :) Initial stab at it attached. I'm torn on whether the paragraph I added to the foreign key cons

Re: [DOCS] Primary Key index

2010-08-25 Thread Thom Brown
On 25 August 2010 20:15, Kevin Grittner wrote: > Thom Brown wrote: >> On 18 August 2010 21:53, Peter Eisentraut 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 informat

Re: [DOCS] Primary Key index

2010-08-25 Thread Kevin Grittner
Thom Brown wrote: > On 18 August 2010 21:53, Peter Eisentraut 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 th

Re: [DOCS] Primary Key index

2010-08-18 Thread Thom Brown
On 18 August 2010 21:53, Peter Eisentraut wrote: > On ons, 2010-08-18 at 16:52 +0100, Thom Brown wrote: >> In response to a user asking a question about indexes on primary keys >> (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) >> I attach a patch to add information to the

Re: [DOCS] Primary Key index

2010-08-18 Thread Peter Eisentraut
On ons, 2010-08-18 at 16:52 +0100, Thom Brown wrote: > In response to a user asking a question about indexes on primary keys > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) > I attach a patch to add information to the Primary Keys section of the > Constraints page. While

Re: [DOCS] Primary Key index

2010-08-18 Thread Kevin Grittner
Thom Brown wrote: > Well I guess the question is: "where will most people first look > to find that piece of information out?" The OP mentioned looking in the Indexes section of the documentation for the answer. > As long as the information isn't digressing from the topic it's > mentioned in

Re: [DOCS] Primary Key index

2010-08-18 Thread Thom Brown
On 18 August 2010 17:09, Kevin Grittner wrote: > Thom Brown wrote: > >> In response to a user asking a question about indexes on primary >> keys >> > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) >> I attach a patch to add information to the Primary Keys section of >> th

Re: [DOCS] Primary Key index

2010-08-18 Thread Kevin Grittner
Thom Brown wrote: > In response to a user asking a question about indexes on primary > keys > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) > I attach a patch to add information to the Primary Keys section of > the Constraints page. While the information already exists

[DOCS] Primary Key index

2010-08-18 Thread Thom Brown
In response to a user asking a question about indexes on primary keys (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) 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 t