Rewording for ALTER TABLE ... ADD table_constraint_using_index
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.
Josh
Attachments:
alter_table_table_constraint_using_index.difftext/plain; charset=US-ASCII; name=alter_table_table_constraint_using_index.diffDownload+4-4
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 <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.