Content-Length: 263079 | pFad | http://github.com/postgrespro/postgres/commit/049a7799dfce096923da27a9b0e4a3c7a0a47104

E1 docs: remove outdated note about unique indexes · postgrespro/postgres@049a779 · GitHub
Skip to content

Commit 049a779

Browse files
committed
docs: remove outdated note about unique indexes
Patch by Josh Kupershmidt Backpatch through 9.5
1 parent cf25b2a commit 049a779

File tree

1 file changed

+1
-5
lines changed

1 file changed

+1
-5
lines changed

doc/src/sgml/indices.sgml

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -655,11 +655,7 @@ CREATE UNIQUE INDEX <replaceable>name</replaceable> ON <replaceable>table</repla
655655

656656
<note>
657657
<para>
658-
The preferred way to add a unique constraint to a table is
659-
<literal>ALTER TABLE ... ADD CONSTRAINT</literal>. The use of
660-
indexes to enforce unique constraints could be considered an
661-
implementation detail that should not be accessed directly.
662-
One should, however, be aware that there's no need to manually
658+
There's no need to manually
663659
create indexes on unique columns; doing so would just duplicate
664660
the automatically-created index.
665661
</para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/049a7799dfce096923da27a9b0e4a3c7a0a47104

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy