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.
>
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 |