Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u22Am-00Bv6G-UI for pgsql-docs@arkaria.postgresql.org; Tue, 08 Apr 2025 06:11:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u22Al-006D1U-Ay for pgsql-docs@arkaria.postgresql.org; Tue, 08 Apr 2025 06:10:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u22Al-006D1I-3C for pgsql-docs@lists.postgresql.org; Tue, 08 Apr 2025 06:10:59 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u22Ai-0044ei-2f for pgsql-docs@lists.postgresql.org; Tue, 08 Apr 2025 06:10:58 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-5e5e1a38c1aso6951147a12.2 for ; Mon, 07 Apr 2025 23:10:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744092655; x=1744697455; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=DPKfc/vZYtUdJSBWmZ/xVSDrd3ryv7uzUb4t5OBlcpc=; b=MyjDdIv5NeoRedGfl1nrX3JP5rtUUuXkrhKsW1PpKgtih+vP+OOiN/bagZzzCYPFWo Ul3VhS/e2+NQeUlYxWoTjDkZCNr167mkpVZEUUOUzdhQ5wOTy1OnvugVzCCONolnfobn usfOyvWk778PltsTgjYpW9SUr0RcXkzkMbasrHUUzS+eVYiLb2tNozkj1IgHBV8ayH3I kKTg1UpUsSKnkneaVflJf2WkeFcwxZ7eRnVkwGTJdt+C9g1nQXyc31VSJiG8qI8cmMdA Vb5ITuFkhdPjUJ+TKxsOm344Dts88r2E/hCbyTSu8ZCNu0fZmHfSG8q1B/wQP/MZlWBT ofZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744092655; x=1744697455; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=DPKfc/vZYtUdJSBWmZ/xVSDrd3ryv7uzUb4t5OBlcpc=; b=V6FCvLAD/TqkYdH+6wo249AxCFSjIMGYjADmY2Xmk+Kuj8DHLOv974sIWDndRfoNPE 9hzz93y4AO0mWyMBRDUWGLm1Uerf+rgBYDQGdOHpSvMhKphnpUbQC1ML08PMH1n/Sul+ MmajfaEoFnh4Nav+E9QFdYGhWEZEOTvLUXZWUf9kjUta1Qk5ZG6KHVUSQvnGr2SyQRBp WgduBrD2yFzmhi9wUjjYccA7+7KstcJMBcnltB9Fz9GeX/Y2eVLpn2XPjch2yKaBr+vp ZBGQ+HMHSibfr8Tz6Yp26rCqF1tleULLQLXARsabF51dpAVgXHgzmlSv0a4sp8bvUC1C ptqw== X-Gm-Message-State: AOJu0YxI+PnN7byeIt/5MrysfADwjGcnIu+ARh53qukMg063NEpUa9m+ diJ49b3IVSrrZK2rKWlcYHLzm2JRh2BxkgX1TxPT+pc26EX3q4f7puvX5w== X-Gm-Gg: ASbGncuObrdcsW4xQI/Rh93j5tmmXZT4/78woUu5KkwV7SE3sYExAiuXQufx48J19Aw KtDmSt6w3f7f7W8u/wHydq7OVIot0os8AZIVuS8H9xQGFmSBu78RfG0YbGQNiYNzmd56rmxSABG rz7cV167DI+6cLfsihPLRBzkIbqKQTifC4V/S4JbYDwUIWKxJhGYenEZ4LHsz6xD7l5PpXLpxZ1 /5kI5si48OalDsHWd7q8BbDlv0rBDhA8z1fFXe/SwkvnDEBmy424SvIv06qeN+5zogpqeikZT74 aMLfFqIIKLhGppeFgWmKO/9r9CaTs5sONSj1Fm4VlVhQVaQJzmT8224B46OAVmpsP2+bxT+cPbE = X-Google-Smtp-Source: AGHT+IFBv3gPz0SaESBzS4gNWZqHQp7UOmnG8eGP5zKRJa2i3L32tn+F8elfN16XsNj3XgRaYkVZ/Q== X-Received: by 2002:a05:6402:2706:b0:5eb:c90f:86ae with SMTP id 4fb4d7f45d1cf-5f0b3b61eaamr13301380a12.7.1744092655203; Mon, 07 Apr 2025 23:10:55 -0700 (PDT) Received: from smtpclient.apple ([178.92.243.1]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5f087ee77f5sm7489983a12.31.2025.04.07.23.10.54 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 07 Apr 2025 23:10:54 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-D99BCBDD-1D92-4A37-A04F-765F3F32B557 Content-Transfer-Encoding: 7bit From: Yaroslav Saburov Mime-Version: 1.0 (1.0) Subject: Re: generated constraint name Date: Tue, 8 Apr 2025 09:10:53 +0300 Message-Id: References: Cc: pgsql-docs@lists.postgresql.org In-Reply-To: To: "David G. Johnston" X-Mailer: iPhone Mail (19H390) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-D99BCBDD-1D92-4A37-A04F-765F3F32B557 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You do not provide the output of the table description, but write that the s= ystem generated the name $2 > 7 =D0=BA=D0=B2=D1=96=D1=82. 2025 =D1=80. =D0=BE 16:34 David G. Johnston =D0=BF=D0=B8=D1=88=D0=B5: >=20 > =EF=BB=BFOn Sunday, April 6, 2025, PG Doc comments form wrote: >> The following documentation comment has been logged on the website: >>=20 >> Page: https://www.postgresql.org/docs/17/ddl-alter.html >> Description: >>=20 >> url: >> https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING= -A-CONSTRAINT >>=20 >> (If you are dealing with a generated constraint name like $2, don't forge= t >> that you'll need to double-quote it to make it a valid identifier.) >>=20 >> If I have a constraint with the name $2, are there other constraints with= >> names $1, $3 ... ? >=20 > I feel like that whole parenthetical should just go away. The point of th= e comment is to remind the user of how identifier values work with respect t= o mandatory double quoting. The name itself, other than having a $, has no s= pecial importance. >=20 > David J. >=20 --Apple-Mail-D99BCBDD-1D92-4A37-A04F-765F3F32B557 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

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


7 =D0=BA=D0=B2=D1=96=D1=82. 2025 = ;=D1=80. =D0=BE 16:34 David G. Johnston <david.g.johnston@gmail.com> =D0= =BF=D0=B8=D1=88=D0=B5:

<= div dir=3D"ltr">=EF=BB=BFOn Sunday, April 6, 2025, PG Doc comments form <= noreply@postgresql.org> wro= te:
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/doc= s/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 i= dentifier values work with respect to mandatory double quoting.  The na= me itself, other than having a $, has no special importance.

<= /div>
David J.

= --Apple-Mail-D99BCBDD-1D92-4A37-A04F-765F3F32B557--