Re: Ideas to deal with table corruption

Поиск
Список
Период
Сортировка
От Corey Taylor
Тема Re: Ideas to deal with table corruption
Дата
Msg-id CADBz387cdv6JgKt7PqJa=6Lf7dVepq+DMpi5=m_tijJHS=RNmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Ideas to deal with table corruption  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: Ideas to deal with table corruption
Re: Ideas to deal with table corruption
Re: Ideas to deal with table corruption
Re: Ideas to deal with table corruption
Список pgsql-admin
On Sat, Jan 6, 2018 at 12:30 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
Don't forget to create indexes on the FK's in the table they reference!

Also, it would be nice to know the PostgreSQL version and O/S.


Is it possible for an index to not exist on those columns?


"A foreign key must reference columns that either are a primary key or form a unique constraint. This means that the referenced columns always have an index (the one underlying the primary key or unique constraint); so checks on whether a referencing row has a match will be efficient."

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Ideas to deal with table corruption
Следующее
От: scott ribe
Дата:
Сообщение: Re: Ideas to deal with table corruption