Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: tim(dot)needham2(at)gmail(dot)com
Subject: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Date: 2023-12-04 20:28:53
Message-ID: 170172173304.398200.5115088275142308182@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tim Needham 2023-12-04 20:38:20 Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Previous Message Laurenz Albe 2023-12-04 20:10:05 Re: Postgres Partitions Limitations (5.11.2.3)