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