Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6h96-0024oi-Ia for pgsql-docs@arkaria.postgresql.org; Sat, 25 Nov 2023 01:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r6h95-00Geiw-6v for pgsql-docs@arkaria.postgresql.org; Sat, 25 Nov 2023 01:07:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6h94-00GeTn-TX for pgsql-docs@lists.postgresql.org; Sat, 25 Nov 2023 01:07:42 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6h92-007DnY-4q for pgsql-docs@postgresql.org; Sat, 25 Nov 2023 01:07:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=BNZHWXdEUJm+iYZmGXC88p08MdNg6kMJmScOix3TQI4=; b=Bms8rCKI1u7UYhf6cRfQV9tmxh r3Ls1aJrhn+8bYMBz/iEHOEHMd1DtCKXsqUj74ixnqmX9d7izR1JHgbPRcdnSHigWNiaDyXylMNI/ fmhAhHx/Q7lvVCHl7FW+M6oqyXz9FmpLbKJ4h/18ov3BkVcm1mAdgpUL4WhoqdAim19SDzwsr6KrU lz1tzim46mNkqTx0CNPMYdrnlitrvwWkDw797fTdqBErkGYjuel4ED9TdYVF+erRQjw0mrWSZBG3R v7zIY+bcs54d/AGcnPlexwObK+6LrSCXQx/5jP3qPKh42eoksfG6QaPsahbFI3Vn+c9uPuiw6FVAN bocIYJ3g==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1r6h91-004y1N-0e; Fri, 24 Nov 2023 20:07:39 -0500 Date: Fri, 24 Nov 2023 20:07:39 -0500 From: Bruce Momjian To: Josh Kupershmidt Cc: pgsql-docs Subject: Re: [DOCS] Rewording for ALTER TABLE ... ADD table_constraint_using_index Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 26, 2015 at 07:31:53PM -0400, Josh Kupershmidt wrote: > I'd like to propose the following slight rewording for the note about ALTER > TABLE ... ADD table_constraint_using_index. The existing text says one may > "install it [the existing index] as an official constraint". > > The "official constraint" phrase sounds like weasel wording to me -- how is a > UNIQUE constraint more "official" than an UNIQUE index? Then "install" makes it > sound like some installation process is going on that you should be aware of. I > like "convert" slightly better instead. Nine year old patch, but still valid, so applied to master. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.