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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-performance by date

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