Outdated note about unique indexes - Mailing list pgsql-docs

From Josh Kupershmidt
Subject Outdated note about unique indexes
Date
Msg-id CAK3UJRE4wGWMjGOfUZcTAOn_k43ETi-jh6FsLF7XX3=Qmkdt3A@mail.gmail.com
Whole thread Raw
List 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


Attachment

pgsql-docs by date:

Previous
From: Monica Gamazo
Date:
Subject: Re: Omission of "(or C)" in psql's "pset title" header
Next
From: Josh Berkus
Date:
Subject: Re: Outdated note about unique indexes