Re: generated constraint name

On 07.04.25 15:34, David G. Johnston wrote:
> On Sunday, April 6, 2025, PG Doc comments form <noreply(at)postgresql(dot)org
> <mailto: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 <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 <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.

I think generated constraint names were generally "$1", "$2", etc. at
some point, instead of the more readable ones you get today. But this
must be ancient.