Re: generated constraint name

Поиск
Список
Период
Сортировка
От Yaroslav Saburov
Тема Re: generated constraint name
Дата
Msg-id D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com
обсуждение исходный текст
Ответ на Re: generated constraint name  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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.g.johnston@gmail.com> пише:

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 по дате отправления: