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.96) (envelope-from ) id 1vx87s-00Gsfd-0J for pgsql-general@arkaria.postgresql.org; Mon, 02 Mar 2026 18:36:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx87q-002Kmv-1R for pgsql-general@arkaria.postgresql.org; Mon, 02 Mar 2026 18:36:14 +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.96) (envelope-from ) id 1vx87q-002Kmm-04 for pgsql-general@lists.postgresql.org; Mon, 02 Mar 2026 18:36:14 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vx87n-000000003dO-3ur7 for pgsql-general@lists.postgresql.org; Mon, 02 Mar 2026 18:36:14 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-679f23befd6so2285155eaf.1 for ; Mon, 02 Mar 2026 10:36:11 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772476570; cv=none; d=google.com; s=arc-20240605; b=PsABxATspU4osQWCgp5cZWzW0PPsH9RaJw7odIe+fbmDMPNrbwc0YMo7rFavtogRun NxSMtoDSbc+7kCOduUQdOtHnLMY9K7gl9Oja4fiesPmrnsQGm5BYCyHmB0KSUQyqmrXD 0ZyumWKkw9LvTxK4CpHzpI+3czJ5HLIkL+gs+fKCRkE0pKzSNDIZaBZeB02BOOml/KfT UzQ6UQ1+OZSyO3Qe2dafw7pJpYdHNwvWuZoO/w/SaomrJZH0AFg3ABOOMPjpIM5uiDUT epfHfjLxfUC/hhjKmb39ygVDgX7x2EsixcAiuapBs+LbB4ke705M2+4Wx1/RHldu9Zm7 2qxA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :dkim-signature; bh=pS5s0RC+9SXlcr4iPj8ZYBc7tcCISs90VWnFxRJU/jw=; fh=TCnXh5c2fXGCpopItOLaeE99aK25XmasS1csVRsKnRY=; b=KEhNL76Sc8QZ3EN/7FmaelLYP3IgV5gXUgtbhlPRAYa3nPMMgPmU+UtOZNo7BxBl0Z jpNnry560+UxdUBqZoWQCzVmH9Y/Rk8Q73ps/TsB6i5a5dfekUz+LhoqYe5b33yt8m4S yDLkFukQK32fDlX4BO86+8BTopIcl53URPU+gFpGGyy2enY2/6m7H2068oqra4iCp/fO uMw9mmWoW7NNB+hhs07KtRojPxJbZ3GvdJA6tHEy3SP/+E/g7gJPM3uQlVME3P07uIJB t3ujrxmISos0gxc4EMpNMETlqezkjYZKTgNJjIe8xI5Y7b4qInnEmxIh9YvbeAdi1cBU IZXQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772476570; x=1773081370; darn=lists.postgresql.org; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=pS5s0RC+9SXlcr4iPj8ZYBc7tcCISs90VWnFxRJU/jw=; b=mOzTFlXsEzQbIUwyh9FB8q8DkXf//si/F5P8z4cEuMZljIWJpGF7TPmvUkjdXygWUJ zVVd9gb9zpc7UxRVVE0L81L09GobKv7Wudjh3RY/UDyKUuQ6l1TRmcMSfV/NerYbJTib 0nIGXShFZrOsc+rgPI+02iiYP3+KWJHK62aK/8kP56tIh7u3uvE5I6Ftj+MYRS7Oy0uB gh0B1/X3JIj9JAJa/XuMb8jf25Ezb8/mqOFXcBofloAyXhVTKe6ECdo30Jo01hgXw3z3 llP67e8VHNMrtLldbJKRqaR9NmgFWuf1C2zOziHimD9m+7qOZepx6kKahEQDqYvWYCLJ /DHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772476570; x=1773081370; h=to:subject:message-id:date:from:references:in-reply-to:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=pS5s0RC+9SXlcr4iPj8ZYBc7tcCISs90VWnFxRJU/jw=; b=Dfw2cEhKfFHzafXZA2uPvgXtsQEVTReMZ8sRYKYb89TOipT/Uet22IxAl2Y/zL0ZiS nVVA1BlhP53Ob+ryKMEW8q9nlOojOAC/Exw+BqqX9oOk70m8t2jEkdt6sU9sl6Ib94YJ IvdOzQb/97aVSQYJm1I/c60d3sxju9BFovvypfZ+NLtfmpq6XF7AwKorvWVb/ddZFCuw chLnsT6qwc7kilJK4nKItJns1pZ/xHmSa3Ny/3nORDQUYXHl3qGxcVfwLNCdHkJbob7l DLSFOaZkQ9xULElp4gJB1A3jXnqVONBqS4BvrO093sztC0Po4E14PVZUNKB4S/Mn2A7+ 2GPA== X-Gm-Message-State: AOJu0YwO+bfMAIeO4t3SyDLzwFDahmGTCJhEOTQE4Uh8+09nPbWM5C42 bprpMOiWWJfnVkJWn9HBRH1v8GWzvqmxMsGUqD3O6lCdNfIN8DkPwA93MhVwwTsjRCUvQw9P7x2 iyMOXi629HTaE9C6wynP5G6c39xCwaZuczNsH X-Gm-Gg: ATEYQzy19oI9eOXF6x6QQvfQBEMfQEcKYS45BiaFAes8isFmPeTJhdv2hVLD999Wc7j BYATpohg3ja0gH+QwGiKvezYLlHYzTQbXmtU8GfvDsuw/xOujqFkKVNQWbnplt912LKbRbWoV11 IURbcQkgc2KtBkkTEjJcu+udXoLEaMtzBL8hS//aBbrwVYvhn1BTQR6xQG7MQ+UPVQLtsfJ/ZJ0 q5HQ5yQh1Wj+Fc+KoVnR6WEywZXi4L2ILpYWQv/05EClBQUmVgm+sr1uvTyZJjpV1ymM1M3uxX7 82usSvE= X-Received: by 2002:a05:6820:604:b0:679:e4c0:e021 with SMTP id 006d021491bc7-679faf46c37mr7055408eaf.56.1772476569894; Mon, 02 Mar 2026 10:36:09 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:53c9:0:b0:61f:afd9:5129 with HTTP; Mon, 2 Mar 2026 10:36:09 -0800 (PST) In-Reply-To: <4mdo74l7xtv7yezgtpn3okojofyf6ihqttjm67cwngyiadgjf2@c6aqv4ruxrqp> References: <4mdo74l7xtv7yezgtpn3okojofyf6ihqttjm67cwngyiadgjf2@c6aqv4ruxrqp> From: "David G. Johnston" Date: Mon, 2 Mar 2026 11:36:09 -0700 X-Gm-Features: AaiRm52d645ii6Utu0Xd0DGolK2fRzI5o2Jw-uCh-tMADsT52SV28wVJbSzBDFI Message-ID: Subject: Re: Documentation weirdness To: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000005244a8064c0edcef" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005244a8064c0edcef Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, March 2, 2026, Peter J. Holzer wrote: > On 2026-03-01 19:08:48 -0700, David G. Johnston wrote: > > On Sun, Mar 1, 2026 at 6:38=E2=80=AFPM Igor Korot = wrote: > > > > Hi, ALL, > > I'm looking at https://www.postgresql.org/ > docs/current/sql-createtable.html > > and see some weird stuff. > > > > When I try to search for "PRIMARY KEY" I eventually hit following: > > > > [quote] > > PRIMARY KEY (column constraint) > > PRIMARY KEY ( column_name [, ... ] [, column_name WITHOUT OVERLAPS = ] > ) > > [ INCLUDE ( column_name [, ...]) ] (table constraint) > > [/quote] > > > > Now I want to check what "column_constraint" is. > > > > > > You read in an underscore in the parenthetical that isn't there. That > said, I > > concur that using a label here that so closely matches something that > exists > > within the page, to mean something else, is just asking for this kind o= f > > confusion. > > Would it be possible to set (column constraint) and (table constraint) > in the normal body font instead of monospace? That would make it clearer > that these phrases aren't part of the syntax but descriptive. > > Not sure, but I don=E2=80=99t like that as the sole solution anyway. Too s= ubtle. If three words is too long, replacing constraint with variant, instead of adding it, would suffice IMO. David J. --0000000000005244a8064c0edcef Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, March 2, 2026, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On= 2026-03-01 19:08:48 -0700, David G. Johnston wrote:
> On Sun, Mar 1, 2026 at 6:38=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:
>
>=C2=A0 =C2=A0 =C2=A0Hi, ALL,
>=C2=A0 =C2=A0 =C2=A0I'm looking at https://www.post= gresql.org/docs/current/sql-createtable.html
>=C2=A0 =C2=A0 =C2=A0and see some weird stuff.
>
>=C2=A0 =C2=A0 =C2=A0When I try to search for "PRIMARY KEY" I = eventually hit following:
>
>=C2=A0 =C2=A0 =C2=A0[quote]
>=C2=A0 =C2=A0 =C2=A0PRIMARY KEY (column constraint)
>=C2=A0 =C2=A0 =C2=A0PRIMARY KEY ( column_name [, ... ] [, column_name W= ITHOUT OVERLAPS ] )
>=C2=A0 =C2=A0 =C2=A0[ INCLUDE ( column_name [, ...]) ] (table constrain= t)
>=C2=A0 =C2=A0 =C2=A0[/quote]
>
>=C2=A0 =C2=A0 =C2=A0Now I want to check what "column_constraint&qu= ot; is.
>
>
> You read in an underscore in the parenthetical that isn't there.= =C2=A0 That said, I
> concur that using a label here that so closely matches something that = exists
> within the page, to mean something else, is just asking for this kind = of
> confusion.

Would it be possible to set (column constraint) and (table constraint)
in the normal body font instead of monospace? That would make it clearer that these phrases aren't part of the syntax but descriptive.


Not sure, but I don=E2=80=99t like that as= the sole solution anyway.=C2=A0 Too subtle.=C2=A0 If three words is too lo= ng, replacing constraint with variant, instead of adding it, would suffice = IMO.

David J.

--0000000000005244a8064c0edcef--