Folks, I was writing up a query on pg_constraint, and the columns whose descriptions I've changed here were pretty hard to puzzle out, as they were only distinct up to the difference between F and P, which isn't always easy to see. Please find attached a patch to disambiguate them.
Best, David. -- David Fetter <david(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
>From 4202229a9319fa2f307b2761696775a2c5905fcd Mon Sep 17 00:00:00 2001 From: David Fetter <da...@fetter.org> Date: Wed, 5 May 2021 15:48:53 -0700 Subject: [PATCH v1] Clarify some column descriptions in pg_constraint To: hackers MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------2.31.1" This is a multi-part message in MIME format. --------------2.31.1 Content-Type: text/plain; charset=UTF-8; format=fixed Content-Transfer-Encoding: 8bit diff --git doc/src/sgml/catalogs.sgml doc/src/sgml/catalogs.sgml index 492ed348b3..2c501f21f7 100644 --- doc/src/sgml/catalogs.sgml +++ doc/src/sgml/catalogs.sgml @@ -2664,7 +2664,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l (references <link linkend="catalog-pg-operator"><structname>pg_operator</structname></link>.<structfield>oid</structfield>) </para> <para> - If a foreign key, list of the equality operators for PK = FK comparisons + If a foreign key, list of the equality operators for establishing whether primary key columns are equal to the corresponding foreign key columns (PK = FK) </para></entry> </row> @@ -2674,7 +2674,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l (references <link linkend="catalog-pg-operator"><structname>pg_operator</structname></link>.<structfield>oid</structfield>) </para> <para> - If a foreign key, list of the equality operators for PK = PK comparisons + If a foreign key, list of the equality operators for establishing whether primary key columns are equal (PK = PK) </para></entry> </row> @@ -2684,7 +2684,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l (references <link linkend="catalog-pg-operator"><structname>pg_operator</structname></link>.<structfield>oid</structfield>) </para> <para> - If a foreign key, list of the equality operators for FK = FK comparisons + If a foreign key, list of the equality operators for establishing whether foreign key columns are equal (FK = FK) </para></entry> </row> --------------2.31.1--