postgres.git / summary / log / commit / refs
commit dad1e259dfa95edd07bf9a890fbb103dc35057ce
Author: Bruce Momjian <bruce@momjian.us>
Date: Tue Sep 16 15:48:48 2025 +0000
First released in: 18.0
doc PG 18 relnotes: add mention of temporal foreign key constr.
Reported-by: Yugo Nagata
Author: Yugo Nagata
Discussion: https://postgr.es/m/20250901200148.baca5744b27419c87c323362@sraoss.co.jp
Backpatch-through: 18 only
doc/src/sgml/release-18.sgml | 14 ++++++++++----
1 file changed, 10 insertions(+), 4 deletions(-)
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 <tmunro@postgresql.org>
<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2024-09-17 [fc0438b4e] Add temporal PRIMARY KEY and UNIQUE constraints
+Author: Peter Eisentraut <peter@eisentraut.org>
+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>
[parent: 9e2c58417342]