| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Marc Compte <mcompte(at)sigte(dot)udg(dot)es> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Foreign keys and indexes |
| Date: | 2007-06-05 15:10:10 |
| Message-ID: | 46657CD2.6040101@g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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. :) )
| From | Date | Subject | |
|---|---|---|---|
| Next Message | volunteer | 2007-06-05 15:12:26 | lo or bytea streaming engine?? |
| Previous Message | Marko Kreen | 2007-06-05 15:09:43 | Re: Encrypted column |