| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | elionescu(at)yahoo(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: incorrect (incomplete) description for "alter domain" |
| Date: | 2024-07-29 12:56:05 |
| Message-ID: | e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On 2024-07-29 13:02 +0200, PG Doc comments form wrote:
> In the Synopsis section of
> https://www.postgresql.org/docs/current/sql-alterdomain.html
> this is incorrect (incomplete):
> "ALTER DOMAIN name ADD domain_constraint [ NOT VALID ]"
> It should be
> "ALTER DOMAIN name ADD CONSTRAINT domain_constraint [ NOT VALID ]"
No, the docs are correct. domain_constraint refers to this syntax
defined by CREATE DOMAIN:
"where constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | CHECK (expression) }"
Also, PG 17 renames this to "domain_constraint" with commit 9895b35cb8
to align ALTER DOMAIN with CREATE DOMAIN.
--
Erik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-07-29 12:56:17 | Re: incorrect (incomplete) description for "alter domain" |
| Previous Message | PG Doc comments form | 2024-07-29 11:02:04 | incorrect (incomplete) description for "alter domain" |