agora inbox for pgsql-docs@postgresql.org  
help / color / mirror / Atom feed
From: Erik Wienhold <ewie@ewie.name>
To: elionescu@yahoo.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: incorrect (incomplete) description for "alter domain"
Date: Mon, 29 Jul 2024 14:56:05 +0200
Message-ID: <e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name> (raw)
In-Reply-To: <172225092461.915373.6103973717483380183@wrigleys.postgresql.org>
References: <172225092461.915373.6103973717483380183@wrigleys.postgresql.org>

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





view thread (9+ messages)  latest in thread

Message-ID: <e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name>
Permalink:  ../e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name/
Also on:    postgresql.org/message-id/e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: ewie@ewie.name, elionescu@yahoo.com, pgsql-docs@lists.postgresql.org
  Subject: Re: incorrect (incomplete) description for "alter domain"
  In-Reply-To: <e0e8271f-687d-4eef-bce0-b706165930b0@ewie.name>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox