Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?

Поиск
Список
Период
Сортировка
От Tim Needham
Тема Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Дата
Msg-id CAAGa=sK9nT5XuhT=TdqmP8NM57dWECh708ierHzCAEGBp1ShFQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?