Re: generated constraint name - Mailing list pgsql-docs

From David G. Johnston
Subject Re: generated constraint name
Date
Msg-id CAKFQuwZn3KTfC75+3u8W31CtJNnUcs5ZQQGUG=wcQW3FLSvx1Q@mail.gmail.com
Whole thread Raw
In response to generated constraint name  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: generated constraint name
Re: generated constraint name
List pgsql-docs
On Sunday, April 6, 2025, PG Doc comments form <noreply@postgresql.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.

pgsql-docs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Re[2]: Suggestion for docs, section "4.2.3 Subscripts": bounds and base
Next
From: "David G. Johnston"
Date:
Subject: Re: Suggestion for docs, section "4.2.3 Subscripts": bounds and base