Re: Multicolumn foreign keys need useless unique indices?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Multicolumn foreign keys need useless unique indices?
Дата
Msg-id GNELIHDDFBOCMGBFGEFOEEDNCEAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Multicolumn foreign keys need useless unique indices?  (Antti Haapala <antti.haapala@iki.fi>)
Ответы Re: Multicolumn foreign keys need useless unique indices?  (Antti Haapala <antti.haapala@iki.fi>)
Re: Multicolumn foreign keys need useless unique indices?  (Rod Taylor <rbt@rbt.ca>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: TOAST docs
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: fixpoint