Re: are foreign keys realized as indexes?

Поиск
Список
Период
Сортировка
От Felix Kater
Тема Re: are foreign keys realized as indexes?
Дата
Msg-id 20070508141454.312b178e.fkater@googlemail.com
обсуждение исходный текст
Ответ на Re: are foreign keys realized as indexes?  (Raymond O'Donnell <rod@iol.ie>)
Ответы Re: are foreign keys realized as indexes?  (Raymond O'Donnell <rod@iol.ie>)
Re: are foreign keys realized as indexes?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Tue, 08 May 2007 12:48:30 +0100
Raymond O'Donnell <rod@iol.ie> wrote:

> You can do that, but you'll lose the enforcement of referential
> integrity, which is what foreign keys give you.

If I get you right:

There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?

Felix

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: are foreign keys realized as indexes?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: are foreign keys realized as indexes?