Re: Multicolumn foreign keys need useless unique indices?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Antti Haapala" <antti(dot)haapala(at)iki(dot)fi>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multicolumn foreign keys need useless unique indices?
Date: 2002-09-13 08:27:20
Message-ID: GNELIHDDFBOCMGBFGEFOEEDNCEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> AFAIK, the extra index only slows down my inserts - it basically contains
> no usable information...

Not 100% true. It will speed up cascade delete and update...

> shouldn't the presence of _primary_key_ in
> multicol foreign key be enough to decide whether the whole key is unique
> or not?

Hmmm - thinking about it, I don't see why postgres would need the entire
thing to be unique...can't think of a reason at the moment. Stephen?

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antti Haapala 2002-09-13 09:04:25 Re: Multicolumn foreign keys need useless unique indices?
Previous Message Antti Haapala 2002-09-13 08:18:03 Multicolumn foreign keys need useless unique indices?