agora inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: Yaroslav Saburov <y.saburov@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: generated constraint name
Date: Tue, 8 Apr 2025 09:10:53 +0300
Message-ID: <D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com> (raw)
In-Reply-To: <CAKFQuwZn3KTfC75+3u8W31CtJNnUcs5ZQQGUG=wcQW3FLSvx1Q@mail.gmail.com>
References: <CAKFQuwZn3KTfC75+3u8W31CtJNnUcs5ZQQGUG=wcQW3FLSvx1Q@mail.gmail.com>

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

view thread (9+ messages)  latest in thread

Message-ID: <D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com>
Permalink:  ../D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com/
Also on:    postgresql.org/message-id/D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: y.saburov@gmail.com, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: generated constraint name
  In-Reply-To: <D6246810-ECE5-4CB5-AD04-C7BD257E18AD@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox