Re: generated constraint name

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "y(dot)saburov(at)gmail(dot)com" <y(dot)saburov(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: generated constraint name
Date: 2025-04-07 13:34:38
Message-ID: CAKFQuwZn3KTfC75+3u8W31CtJNnUcs5ZQQGUG=wcQW3FLSvx1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Sunday, April 6, 2025, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/ddl-alter.html
> Description:
>
> url:
> https://www.postgresql.org/docs/current/ddl-alter.html#
> DDL-ALTER-REMOVING-A-CONSTRAINT
>
> (If you are dealing with a generated constraint name like $2, don't forget
> that you'll need to double-quote it to make it a valid identifier.)
>
> If I have a constraint with the name $2, are there other constraints with
> names $1, $3 ... ?
>

I feel like that whole parenthetical should just go away. The point of the
comment is to remind the user of how identifier values work with respect to
mandatory double quoting. The name itself, other than having a $, has no
special importance.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2025-04-07 13:51:41 Re: Suggestion for docs, section "4.2.3 Subscripts": bounds and base
Previous Message Laurenz Albe 2025-04-07 13:16:24 Re: Re[2]: Suggestion for docs, section "4.2.3 Subscripts": bounds and base