Outdated note about unique indexes

Поиск
Список
Период
Сортировка
От Josh Kupershmidt
Тема Outdated note about unique indexes
Дата
Msg-id CAK3UJRE4wGWMjGOfUZcTAOn_k43ETi-jh6FsLF7XX3=Qmkdt3A@mail.gmail.com
обсуждение исходный текст
Список pgsql-docs
Hi,

I noticed that the note on a page about unique indexes


says "The preferred way to add a unique constraint to a table is ALTER TABLE ... ADD CONSTRAINT. The use of indexes to enforce unique constraints could be considered an implementation detail that should not be accessed directly... ".

That note has been there forever, in particular since before we supported CONCURRENTLY, which is pretty darn important in many uses nowadays. Since it seems like some users have taken this suggestion seriously, e.g. on stackoverflow[1], how about we remove this outdated suggestion? There is already a previous mention a few sections earlier[2] suggesting the use of CONCURRENTLY, so I don't think we really need to reiterate that suggestion here.

Josh


Вложения

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

Предыдущее
От: Monica Gamazo
Дата:
Сообщение: Re: Omission of "(or C)" in psql's "pset title" header
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Outdated note about unique indexes