On Thu, 1 May 2025 22:44:50 -0400 Bruce Momjian <[email protected]> wrote:
> I have committd the first draft of the PG 18 release notes. The item > count looks strong: I noticed that the following commit seems to be missing from the release notes: 2024-09-17 [89f908a6d] Add temporal FOREIGN KEY contraints I believe this is worth including, especially with a mention of the new keyword PERIOD, since that would help users discover that a new keyword has been introduced. I've attached a draft patch to fix the existing release note entry for temporal (non-overlapping) PRIMARY KEY and UNIQUE constraints. Regards, Yugo Nagata -- Yugo Nagata <[email protected]>
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 874f3113ccb..75cf99b6390 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -1891,21 +1891,27 @@ Author: Thomas Munro <[email protected]> <!-- Author: Peter Eisentraut <[email protected]> 2024-09-17 [fc0438b4e] Add temporal PRIMARY KEY and UNIQUE constraints +Author: Peter Eisentraut <[email protected]> +2024-09-17 [89f908a6d] Add temporal FOREIGN KEY contraints --> <listitem> <para> Allow the specification of non-overlapping <link linkend="sql-createtable-parms-primary-key"><literal>PRIMARY - KEY</literal></link> and <link - linkend="sql-createtable-parms-unique"><literal>UNIQUE</literal></link> + KEY</literal></link>, <link linkend="sql-createtable-parms-unique"> + <literal>UNIQUE</literal></link>, and + <link linkend="sql-createtable-parms-references">foreign key</link> constraints (Paul A. Jungwirth) <ulink url="&commit_baseurl;fc0438b4e">§</ulink> + <ulink url="&commit_baseurl;89f908a6d">§</ulink> </para> <para> - This is specified by <literal>WITHOUT OVERLAPS</literal> on the - last specified column. + This is specified by <literal>WITHOUT OVERLAPS</literal> for + <literal>PRIMARY KEY</literal> and <literal>UNIQUE</literal>, and by + <literal>PERIOD</literal> for foreign keys, all applied to the last + specified column. </para> </listitem>
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml index 874f3113ccb..75cf99b6390 100644 --- a/doc/src/sgml/release-18.sgml +++ b/doc/src/sgml/release-18.sgml @@ -1891,21 +1891,27 @@ Author: Thomas Munro <[email protected]> <!-- Author: Peter Eisentraut <[email protected]> 2024-09-17 [fc0438b4e] Add temporal PRIMARY KEY and UNIQUE constraints +Author: Peter Eisentraut <[email protected]> +2024-09-17 [89f908a6d] Add temporal FOREIGN KEY contraints --> <listitem> <para> Allow the specification of non-overlapping <link linkend="sql-createtable-parms-primary-key"><literal>PRIMARY - KEY</literal></link> and <link - linkend="sql-createtable-parms-unique"><literal>UNIQUE</literal></link> + KEY</literal></link>, <link linkend="sql-createtable-parms-unique"> + <literal>UNIQUE</literal></link>, and + <link linkend="sql-createtable-parms-references">foreign key</link> constraints (Paul A. Jungwirth) <ulink url="&commit_baseurl;fc0438b4e">§</ulink> + <ulink url="&commit_baseurl;89f908a6d">§</ulink> </para> <para> - This is specified by <literal>WITHOUT OVERLAPS</literal> on the - last specified column. + This is specified by <literal>WITHOUT OVERLAPS</literal> for + <literal>PRIMARY KEY</literal> and <literal>UNIQUE</literal>, and by + <literal>PERIOD</literal> for foreign keys, all applied to the last + specified column. </para> </listitem>
