MIME-Version: 1.0
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 3 Apr 2026 10:18:41 -0700
Message-ID: 
 <CAKFQuwbsGWx5msYbRsWrRs+ss1k0utDHEhVq5unAKODQ9YOf9w@mail.gmail.com>
Subject: Docs: Create table description for constraints markup fix and label
 tweaks
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000004eb44e064e9184ca"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbsGWx5msYbRsWrRs%2Bss1k0utDHEhVq5unAKODQ9YOf9w%40mail.gmail.com>
Precedence: bulk

--0000000000004eb44e064e9184ca
Content-Type: multipart/alternative; boundary="0000000000004eb44e064e9184c8"

--0000000000004eb44e064e9184c8
Content-Type: text/plain; charset="UTF-8"

Hi,

Responding to a recent report on -general [1] I found a markup bug in the
primary key description under create table.  0001 fixes this.

The complaint itself was about using "column constraint" as a descriptive
label in a syntax area when "column constraint" is an actual defined syntax
label.  0002 adds the word "variant" to the six places "(table/column
constraint)" is used in this manner.

David J.

[1]
https://www.postgresql.org/message-id/CA+FnnTzeE30E4kfK4=+MLe4DBORu4CdYvPQgWUYakRxfwsbEtg@mail.gmail.com

--0000000000004eb44e064e9184c8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">Hi,</div><div class=3D"gmail_default" style=3D"font-fam=
ily:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif">Responding to a recent report =
on -general [1] I found a markup bug in the primary key description=C2=A0un=
der create table.=C2=A0 0001 fixes this.</div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gm=
ail_default" style=3D"font-family:arial,helvetica,sans-serif">The complaint=
 itself was about using &quot;column constraint&quot; as a descriptive labe=
l in a syntax area when &quot;column constraint&quot; is an actual defined =
syntax label.=C2=A0 0002 adds the word &quot;variant&quot; to the six place=
s &quot;(table/column constraint)&quot; is used in this manner.</div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br=
></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif">David J.</div><div class=3D"gmail_default" style=3D"font-family:a=
rial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"=
font-family:arial,helvetica,sans-serif">[1]=C2=A0<a href=3D"https://www.pos=
tgresql.org/message-id/CA+FnnTzeE30E4kfK4=3D+MLe4DBORu4CdYvPQgWUYakRxfwsbEt=
g@mail.gmail.com">https://www.postgresql.org/message-id/CA+FnnTzeE30E4kfK4=
=3D+MLe4DBORu4CdYvPQgWUYakRxfwsbEtg@mail.gmail.com</a></div><div class=3D"g=
mail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div></=
div>

--0000000000004eb44e064e9184c8--

--0000000000004eb44e064e9184ca
Content-Type: application/octet-stream;
	name="v1-0002-pgsql-doc-Make-constraint-type-labels-not-match-s.patch"
Content-Disposition: attachment;
	filename="v1-0002-pgsql-doc-Make-constraint-type-labels-not-match-s.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnj5z9ho0>
X-Attachment-Id: f_mnj5z9ho0

RnJvbSAxOWJjMDZmNmM4YTIxNDc1ZjNjYTAxZTlmNzk4OGFjMDA4M2NhYTIxIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQ0KRnJvbTogIkRhdmlkIEcuIEpvaG5zdG9uIiA8RGF2aWQuRy5Kb2huc3Rv
bkBHbWFpbC5jb20+DQpEYXRlOiBGcmksIDMgQXByIDIwMjYgMTA6MDY6MDcgLTA3MDANClN1Ympl
Y3Q6IFtQQVRDSCB2MSAyLzJdIHBnc3FsOiBkb2M6IE1ha2UgY29uc3RyYWludCB0eXBlIGxhYmVs
cyBub3QgbWF0Y2gNCiBzeW50YXggdmVyYmlhZ2UNCg0KSW4gQ1JFQVRFIFRBQkxFLCB1bmlxdWUs
IHByaW1hcnkga2V5LCBhbmQgZm9yZWlnbiBrZXkgaW5kZXhlcyBhbGwgaGF2ZQ0KdGFibGUgYW5k
IGNvbHVtbiB2YXJpYW50cy4gIEluIHRoZSBkZXNjcmlwdGlvbiB0aGUgbGFiZWwgdXNlZCB0bw0K
aWRlbnRpZnkgdGhlIHZhcmlhbnQgbWF0Y2hlZCB0aGUgbGFiZWwgdXNlZCBpbiB0aGUgc3ludGF4
LiAgU2luY2UgdGhlDQpsYWJlbCBhcHBlYXJzIGluIGEgc3ludGF4IGJsdWIgdGhpcyBjb3VsZCBs
ZWFkIHRvIGNvbmZ1c2lvbiBhcyByZXBvcnRlZC4NCg0KVG8gZml4LCBhZGQgdGhlIHdvcmQgJ3Zh
cmlhbnQnIHRvIHRoZSBzaXggbGFiZWxzLg0KLS0tDQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVf
dGFibGUuc2dtbCB8IDEyICsrKysrKy0tLS0tLQ0KIDEgZmlsZSBjaGFuZ2VkLCA2IGluc2VydGlv
bnMoKyksIDYgZGVsZXRpb25zKC0pDQoNCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2Ny
ZWF0ZV90YWJsZS5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbA0KaW5k
ZXggNGMzODA4Y2RiNDUuLjgzZWZjMWYyYjZjIDEwMDY0NA0KLS0tIGEvZG9jL3NyYy9zZ21sL3Jl
Zi9jcmVhdGVfdGFibGUuc2dtbA0KKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUu
c2dtbA0KQEAgLTEwMDksOSArMTAwOSw5IEBAIFdJVEggKCBNT0RVTFVTIDxyZXBsYWNlYWJsZSBj
bGFzcz0icGFyYW1ldGVyIj5udW1lcmljX2xpdGVyYWw8L3JlcGxhY2VhYmxlPiwgUkVNDQogICAg
PC92YXJsaXN0ZW50cnk+DQogDQogICAgPHZhcmxpc3RlbnRyeSBpZD0ic3FsLWNyZWF0ZXRhYmxl
LXBhcm1zLXVuaXF1ZSI+DQotICAgIDx0ZXJtPjxsaXRlcmFsPlVOSVFVRSBbIE5VTExTIFsgTk9U
IF0gRElTVElOQ1QgXTwvbGl0ZXJhbD4gKGNvbHVtbiBjb25zdHJhaW50KTwvdGVybT4NCisgICAg
PHRlcm0+PGxpdGVyYWw+VU5JUVVFIFsgTlVMTFMgWyBOT1QgXSBESVNUSU5DVCBdPC9saXRlcmFs
PiAoY29sdW1uIGNvbnN0cmFpbnQgdmFyaWFudCk8L3Rlcm0+DQogICAgIDx0ZXJtPjxsaXRlcmFs
PlVOSVFVRSBbIE5VTExTIFsgTk9UIF0gRElTVElOQ1QgXSAoIDxyZXBsYWNlYWJsZSBjbGFzcz0i
cGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFibGU+IFssIC4uLiBdIFssIDxyZXBsYWNl
YWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFibGU+IFdJVEhPVVQg
T1ZFUkxBUFMgXSApPC9saXRlcmFsPg0KLSAgICA8b3B0aW9uYWw+IDxsaXRlcmFsPklOQ0xVREUg
KCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+Y29sdW1uX25hbWU8L3JlcGxhY2VhYmxl
PiBbLCAuLi5dKTwvbGl0ZXJhbD4gPC9vcHRpb25hbD4gKHRhYmxlIGNvbnN0cmFpbnQpPC90ZXJt
Pg0KKyAgICA8b3B0aW9uYWw+IDxsaXRlcmFsPklOQ0xVREUgKCA8cmVwbGFjZWFibGUgY2xhc3M9
InBhcmFtZXRlciI+Y29sdW1uX25hbWU8L3JlcGxhY2VhYmxlPiBbLCAuLi5dKTwvbGl0ZXJhbD4g
PC9vcHRpb25hbD4gKHRhYmxlIGNvbnN0cmFpbnQgdmFyaWFudCk8L3Rlcm0+DQogDQogICAgIDxs
aXN0aXRlbT4NCiAgICAgIDxwYXJhPg0KQEAgLTEwODcsOSArMTA4Nyw5IEBAIFdJVEggKCBNT0RV
TFVTIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5udW1lcmljX2xpdGVyYWw8L3JlcGxh
Y2VhYmxlPiwgUkVNDQogICAgPC92YXJsaXN0ZW50cnk+DQogDQogICAgPHZhcmxpc3RlbnRyeSBp
ZD0ic3FsLWNyZWF0ZXRhYmxlLXBhcm1zLXByaW1hcnkta2V5Ij4NCi0gICAgPHRlcm0+PGxpdGVy
YWw+UFJJTUFSWSBLRVk8L2xpdGVyYWw+IChjb2x1bW4gY29uc3RyYWludCk8L3Rlcm0+DQorICAg
IDx0ZXJtPjxsaXRlcmFsPlBSSU1BUlkgS0VZPC9saXRlcmFsPiAoY29sdW1uIGNvbnN0cmFpbnQg
dmFyaWFudCk8L3Rlcm0+DQogICAgIDx0ZXJtPjxsaXRlcmFsPlBSSU1BUlkgS0VZICggPHJlcGxh
Y2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmNvbHVtbl9uYW1lPC9yZXBsYWNlYWJsZT4gWywgLi4u
IF0gWywgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmNvbHVtbl9uYW1lPC9yZXBsYWNl
YWJsZT4gV0lUSE9VVCBPVkVSTEFQUyBdICkNCi0gICAgPG9wdGlvbmFsPiBJTkNMVURFICggPHJl
cGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmNvbHVtbl9uYW1lPC9yZXBsYWNlYWJsZT4gWywg
Li4uXSk8L29wdGlvbmFsPjwvbGl0ZXJhbD4gKHRhYmxlIGNvbnN0cmFpbnQpPC90ZXJtPg0KKyAg
ICA8b3B0aW9uYWw+IElOQ0xVREUgKCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+Y29s
dW1uX25hbWU8L3JlcGxhY2VhYmxlPiBbLCAuLi5dKTwvb3B0aW9uYWw+PC9saXRlcmFsPiAodGFi
bGUgY29uc3RyYWludCB2YXJpYW50KTwvdGVybT4NCiAgICAgPGxpc3RpdGVtPg0KICAgICAgPHBh
cmE+DQogICAgICAgVGhlIDxsaXRlcmFsPlBSSU1BUlkgS0VZPC9saXRlcmFsPiBjb25zdHJhaW50
IHNwZWNpZmllcyB0aGF0IGEgY29sdW1uIG9yDQpAQCAtMTIwMywxNCArMTIwMywxNCBAQCBXSVRI
ICggTU9EVUxVUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRlcmFs
PC9yZXBsYWNlYWJsZT4sIFJFTQ0KICAgIDwvdmFybGlzdGVudHJ5Pg0KIA0KICAgIDx2YXJsaXN0
ZW50cnkgaWQ9InNxbC1jcmVhdGV0YWJsZS1wYXJtcy1yZWZlcmVuY2VzIj4NCi0gICAgPHRlcm0+
PGxpdGVyYWw+UkVGRVJFTkNFUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+cmVmdGFi
bGU8L3JlcGxhY2VhYmxlPiBbICggPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnJlZmNv
bHVtbjwvcmVwbGFjZWFibGU+ICkgXSBbIE1BVENIIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1l
dGVyIj5tYXRjaHR5cGU8L3JlcGxhY2VhYmxlPiBdIFsgT04gREVMRVRFIDxyZXBsYWNlYWJsZSBj
bGFzcz0icGFyYW1ldGVyIj5yZWZlcmVudGlhbF9hY3Rpb248L3JlcGxhY2VhYmxlPiBdIFsgT04g
VVBEQVRFIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5yZWZlcmVudGlhbF9hY3Rpb248
L3JlcGxhY2VhYmxlPiBdPC9saXRlcmFsPiAoY29sdW1uIGNvbnN0cmFpbnQpPC90ZXJtPg0KKyAg
ICA8dGVybT48bGl0ZXJhbD5SRUZFUkVOQ0VTIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVy
Ij5yZWZ0YWJsZTwvcmVwbGFjZWFibGU+IFsgKCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRl
ciI+cmVmY29sdW1uPC9yZXBsYWNlYWJsZT4gKSBdIFsgTUFUQ0ggPHJlcGxhY2VhYmxlIGNsYXNz
PSJwYXJhbWV0ZXIiPm1hdGNodHlwZTwvcmVwbGFjZWFibGU+IF0gWyBPTiBERUxFVEUgPHJlcGxh
Y2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnJlZmVyZW50aWFsX2FjdGlvbjwvcmVwbGFjZWFibGU+
IF0gWyBPTiBVUERBVEUgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnJlZmVyZW50aWFs
X2FjdGlvbjwvcmVwbGFjZWFibGU+IF08L2xpdGVyYWw+IChjb2x1bW4gY29uc3RyYWludCB2YXJp
YW50KTwvdGVybT4NCiANCiAgICA8dGVybT48bGl0ZXJhbD5GT1JFSUdOIEtFWSAoIDxyZXBsYWNl
YWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFibGU+IFssIC4uLiBd
IFssIFBFUklPRCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+Y29sdW1uX25hbWU8L3Jl
cGxhY2VhYmxlPiBdICkNCiAgICAgUkVGRVJFTkNFUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFt
ZXRlciI+cmVmdGFibGU8L3JlcGxhY2VhYmxlPiBbICggPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJh
bWV0ZXIiPnJlZmNvbHVtbjwvcmVwbGFjZWFibGU+IFssIC4uLiBdIFssIFBFUklPRCA8cmVwbGFj
ZWFibGUgY2xhc3M9InBhcmFtZXRlciI+cmVmY29sdW1uPC9yZXBsYWNlYWJsZT4gXSApIF0NCiAg
ICAgWyBNQVRDSCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bWF0Y2h0eXBlPC9yZXBs
YWNlYWJsZT4gXQ0KICAgICBbIE9OIERFTEVURSA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRl
ciI+cmVmZXJlbnRpYWxfYWN0aW9uPC9yZXBsYWNlYWJsZT4gXQ0KICAgICBbIE9OIFVQREFURSA8
cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+cmVmZXJlbnRpYWxfYWN0aW9uPC9yZXBsYWNl
YWJsZT4gXTwvbGl0ZXJhbD4NCi0gICAgKHRhYmxlIGNvbnN0cmFpbnQpPC90ZXJtPg0KKyAgICAo
dGFibGUgY29uc3RyYWludCB2YXJpYW50KTwvdGVybT4NCiANCiAgICAgPGxpc3RpdGVtPg0KICAg
ICAgPHBhcmE+DQotLSANCjIuNDMuMA0KDQo=
--0000000000004eb44e064e9184ca
Content-Type: application/octet-stream;
	name="v1-0001-pgsql-doc-Fix-malformed-sgml-element-nesting-for-.patch"
Content-Disposition: attachment;
	filename="v1-0001-pgsql-doc-Fix-malformed-sgml-element-nesting-for-.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnj5z9ib1>
X-Attachment-Id: f_mnj5z9ib1

RnJvbSA3MTMwOWU4MWNkM2EzMWJjOTUzZTE3OGM4MGFiYzA0ZWNhYTAzNWIyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQ0KRnJvbTogIkRhdmlkIEcuIEpvaG5zdG9uIiA8RGF2aWQuRy5Kb2huc3Rv
bkBHbWFpbC5jb20+DQpEYXRlOiBGcmksIDMgQXByIDIwMjYgMTA6MDU6MzkgLTA3MDANClN1Ympl
Y3Q6IFtQQVRDSCB2MSAxLzJdIHBnc3FsOiBkb2M6IEZpeCBtYWxmb3JtZWQgc2dtbCBlbGVtZW50
IG5lc3RpbmcgZm9yDQogcHJpbWFyeSBrZXkNCg0KSW4gQ1JFQVRFIFRBQkxFLCB0aGUgcHJpbWFy
eSBrZXkgZGVzY3JpcHRpb24gaGFkIG1hbGZvcm1lZCBzZ21sIGVsZW1lbnQNCm5lc3RpbmcuICBU
aGUgSU5DTFVERSBjbGF1c2Ugd2FzIHBsYWNlZCBvdXRzaWRlIHRoZSBlbmNsb3NpbmcgbGl0ZXJh
bA0KZWxlbWVudC4gIEZpeCB0aGUgdHdvIHNnbWwgbWFya3VwIGlzc3Vlcy4NCi0tLQ0KIGRvYy9z
cmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwgfCA0ICsrLS0NCiAxIGZpbGUgY2hhbmdlZCwg
MiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQ0KDQpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9z
Z21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxl
LnNnbWwNCmluZGV4IDgwODI5YjIzOTQ1Li40YzM4MDhjZGI0NSAxMDA2NDQNCi0tLSBhL2RvYy9z
cmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwNCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvY3Jl
YXRlX3RhYmxlLnNnbWwNCkBAIC0xMDg4LDggKzEwODgsOCBAQCBXSVRIICggTU9EVUxVUyA8cmVw
bGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRlcmFsPC9yZXBsYWNlYWJsZT4s
IFJFTQ0KIA0KICAgIDx2YXJsaXN0ZW50cnkgaWQ9InNxbC1jcmVhdGV0YWJsZS1wYXJtcy1wcmlt
YXJ5LWtleSI+DQogICAgIDx0ZXJtPjxsaXRlcmFsPlBSSU1BUlkgS0VZPC9saXRlcmFsPiAoY29s
dW1uIGNvbnN0cmFpbnQpPC90ZXJtPg0KLSAgICA8dGVybT48bGl0ZXJhbD5QUklNQVJZIEtFWSAo
IDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFibGU+
IFssIC4uLiBdIFssIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwv
cmVwbGFjZWFibGU+IFdJVEhPVVQgT1ZFUkxBUFMgXSApPC9saXRlcmFsPg0KLSAgICA8b3B0aW9u
YWw+IDxsaXRlcmFsPklOQ0xVREUgKCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+Y29s
dW1uX25hbWU8L3JlcGxhY2VhYmxlPiBbLCAuLi5dKTwvbGl0ZXJhbD4gPC9vcHRpb25hbD4gKHRh
YmxlIGNvbnN0cmFpbnQpPC90ZXJtPg0KKyAgICA8dGVybT48bGl0ZXJhbD5QUklNQVJZIEtFWSAo
IDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFibGU+
IFssIC4uLiBdIFssIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwv
cmVwbGFjZWFibGU+IFdJVEhPVVQgT1ZFUkxBUFMgXSApDQorICAgIDxvcHRpb25hbD4gSU5DTFVE
RSAoIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5jb2x1bW5fbmFtZTwvcmVwbGFjZWFi
bGU+IFssIC4uLl0pPC9vcHRpb25hbD48L2xpdGVyYWw+ICh0YWJsZSBjb25zdHJhaW50KTwvdGVy
bT4NCiAgICAgPGxpc3RpdGVtPg0KICAgICAgPHBhcmE+DQogICAgICAgVGhlIDxsaXRlcmFsPlBS
SU1BUlkgS0VZPC9saXRlcmFsPiBjb25zdHJhaW50IHNwZWNpZmllcyB0aGF0IGEgY29sdW1uIG9y
DQotLSANCjIuNDMuMA0KDQo=
--0000000000004eb44e064e9184ca--