Re: generated constraint name

From: Yaroslav Saburov <y(dot)saburov(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: generated constraint name
Date: 2025-04-08 06:10:53
Message-ID: D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

You do not provide the output of the table description, but write that the system generated the name $2

> 7 квіт. 2025 р. о 16:34 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> пише:
>
> 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

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2025-04-08 18:00:29 gen_random_uuid random source clarification
Previous Message Tom Lane 2025-04-08 04:28:07 Re: Possible documentation inaccuracy in optimizer README