From 712dc2338b23196edd94619f43f24d23139cc0a9 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 24 Nov 2023 20:07:14 -0500 Subject: [PATCH] doc: improve ALTER TABLE "offical constraint" wording Reported-by: Josh Kupershmidt Discussion: https://postgr.es/m/CAK3UJRF=KY_nx_TRQq+t6jOrtS2rry79ktkzPiMDhFx_K=dZAg@mail.gmail.com Author: Josh Kupershmidt Backpatch-through: master --- doc/src/sgml/ref/alter_table.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 2c4138e4e9..e1d207bc60 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -525,8 +525,8 @@ WITH ( MODULUS numeric_literal, REM Adding a constraint using an existing index can be helpful in situations where a new constraint needs to be added without blocking table updates for a long time. To do that, create the index using - CREATE INDEX CONCURRENTLY, and then install it as an - official constraint using this syntax. See the example below. + CREATE UNIQUE INDEX CONCURRENTLY, and then convert it to a + constraint using this syntax. See the example below. -- 2.11.4.GIT