Re: what can depend on index

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: what can depend on index
Дата
Msg-id AANLkTi=u0ELrPV8s09kvVHrhBeqj-TcMqQ3UDvWAPjRP@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what can depend on index  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Why Select Count(*) from table - took over 20 minutes?  (Ozz Nixon <ozznixon@gmail.com>)
Список pgsql-general
Дерево обсуждения


On 26 October 2010 16:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Szymon Guz <mabewlun@gmail.com> writes:
> today I noticed that in the documentation there is DROP INDEX CASCADE.
> I've got one question: what is that for? What can depend on index?

Unique constraints and foreign key constraints, for starters.

But even if there weren't anything, we'd still provide the CASCADE
syntax for future-proofing purposes.

                       regards, tom lane


Thanks for the answer, I didn't know about the foreign key, I only thought about the future use.

regards
Szymon

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

Предыдущее
От: Szymon Guz
Дата:
Сообщение: Re: what can depend on index
Следующее
От: Ozz Nixon
Дата:
Сообщение: Why Select Count(*) from table - took over 20 minutes?