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

Re: Are Indices automatically generated for primary keys?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Clemens Eisserer" <linuxhippy(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Are Indices automatically generated for primary keys?
Date: 2010-08-18 14:24:37
Message-ID: 4C6BA6D5020000250003482D@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Clemens Eisserer <linuxhippy(at)gmail(dot)com> wrote:
 
> Its quite harsh to imply I didn't look for documentation.
 
Sorry; I didn't mean to be harsh.  PostgreSQL has excellent
documentation, and we strive to make it better all the time. 
Sometimes people coming from some other products aren't used to that
-- I was just trying to point you in the direction of being able to
find things in the future, to save you trouble and delay.
 
> I looked at the "Indexes and ORDER BY" which doesn't mention it,
> or I've overlook it.
> Doesn't make a difference anyway.
 
Well, it very much does make a difference, because when someone
makes the effort to find something in our documentation, and in
spite of their best efforts they can't, we tend to consider that a
bug in the documentation.  I'll take a look at the page you
mentioned and see if I can work in a suitable reference.  I'm sure
you can see, though, why the *main* place it was documented was the
statement which is generally used to create a primary key.
 
Thanks for responding with the info on where you looked.
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Clemens EissererDate: 2010-08-18 14:33:43
Subject: Re: [PERFORM] Are Indices automatically generated for primary keys?
Previous:From: Clemens EissererDate: 2010-08-18 14:15:26
Subject: Re: Are Indices automatically generated for primary keys?

pgsql-general by date

Next:From: Clemens EissererDate: 2010-08-18 14:33:43
Subject: Re: [PERFORM] Are Indices automatically generated for primary keys?
Previous:From: Clemens EissererDate: 2010-08-18 14:15:26
Subject: Re: Are Indices automatically generated for primary keys?

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