Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form? - Mailing list pgsql-docs

From Tim Needham
Subject Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Date
Msg-id CAAGa=sK9nT5XuhT=TdqmP8NM57dWECh708ierHzCAEGBp1ShFQ@mail.gmail.com
Whole thread Raw
Responses Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
List pgsql-docs
Bah, scratch that, sorry again. It's because "CONSTRAINT" is implied by the reference to CREATE DOMAIN, isn't it?
Sorry.

On Mon, Dec 4, 2023 at 8:29 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-alterdomain.html
Description:

(apologies, I managed to send this too soon, just now, somehow)

The example for ALTER DOMAIN shows:

ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5);

...yet the syntax suggests no CONSTRAINT-keyword (I'm guessing?) should be
used:

ALTER DOMAIN name ADD domain_constraint [ NOT VALID ]

When it should, I think?

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Next
From: "David G. Johnston"
Date:
Subject: Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?