Re: generated constraint name

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: generated constraint name
Дата
Msg-id CAKFQuwZn3KTfC75+3u8W31CtJNnUcs5ZQQGUG=wcQW3FLSvx1Q@mail.gmail.com
обсуждение исходный текст
Ответ на generated constraint name  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: generated constraint name
Re: generated constraint name
Список pgsql-docs
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 по дате отправления: