Re: Foreign keys and indexes - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Foreign keys and indexes
Date
Msg-id 46657CD2.6040101@g2switchworks.com
Whole thread Raw
In response to Re: Foreign keys and indexes  (Marc Compte <mcompte@sigte.udg.es>)
List pgsql-general
Marc Compte wrote:
> Thanks to everyone for the prompt reply :)
>
> Good thing about answers is when they raise up new questiosn, so you
> can keep on learning all the time.
>
> This one answer, for instance, brings me another question. Does having
> a composite primary mean the system will create an individual index on
> each of the fields? or is the index created on the composition only?
>
> For instance, in the implementation of a N:M relationship, declaring
> the primary as (foreign1, foreign2) will create two indexes? or just one?

Just one (and please don't top post.  :) )

pgsql-general by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: Encrypted column
Next
From: Oliver Elphick
Date:
Subject: Re: Foreign keys and indexes