Foreign keys

Поиск
Список
Период
Сортировка
Искать
От
Dean Gibson (DB Administrator)
Тема
Foreign keys
Дата
Msg-id
52B1E31C.8010000@ultimeth.com
Список
Дерево обсуждения
Foreign keys "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
Re: Foreign keys Kevin Grittner <kgrittn@ymail.com>
Re: Foreign keys "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
Re: Foreign keys Rob Sargent <robjsargent@gmail.com>
I have general question about FOREIGN KEYs:

  1. Suppose I have table A with primary key X, and another table B with field Y.
  2. When I 'ALTER TABLE "B"  ADD FOREIGN KEY( "Y" )  REFERENCES "A"  ON UPDATE CASCADE  ON DELETE CASCADE', that clearly spends some time building a separate index.  Since there is already a unique index on X, presumably (?) the index being built is on Y.
  3. However, the PostgreSQL documentation seems to indicate that it's a good idea to also separately create an index on Y.
  4. Why, and why is the FOREIGN KEY index different from the ones on X and Y in any way but trivial?
  5. If I need the separate index on Y, should it be built before or after the FOREIGN KEY constraint?

-- 
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.
В списке pgsql-general по дате отправления
От: Rahila Syed
Дата:
От: Rob Sargent
Дата:
Сообщение: Re: Foreign keys
FAQ