🌐 AI搜索 & 代理 主页
Skip to content

Commit dad1e25

Browse files
committed
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
1 parent 9e2c584 commit dad1e25

File tree

1 file changed

+10
-4
lines changed

1 file changed

+10
-4
lines changed

doc/src/sgml/release-18.sgml

Lines changed: 10 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1891,21 +1891,27 @@ Author: Thomas Munro <tmunro@postgresql.org>
18911891
<!--
18921892
Author: Peter Eisentraut <peter@eisentraut.org>
18931893
2024-09-17 [fc0438b4e] Add temporal PRIMARY KEY and UNIQUE constraints
1894+
Author: Peter Eisentraut <peter@eisentraut.org>
1895+
2024-09-17 [89f908a6d] Add temporal FOREIGN KEY contraints
18941896
-->
18951897

18961898
<listitem>
18971899
<para>
18981900
Allow the specification of non-overlapping <link
18991901
linkend="sql-createtable-parms-primary-key"><literal>PRIMARY
1900-
KEY</literal></link> and <link
1901-
linkend="sql-createtable-parms-unique"><literal>UNIQUE</literal></link>
1902+
KEY</literal></link>, <link linkend="sql-createtable-parms-unique">
1903+
<literal>UNIQUE</literal></link>, and
1904+
<link linkend="sql-createtable-parms-references">foreign key</link>
19021905
constraints (Paul A. Jungwirth)
19031906
<ulink url="&commit_baseurl;fc0438b4e">&sect;</ulink>
1907+
<ulink url="&commit_baseurl;89f908a6d">&sect;</ulink>
19041908
</para>
19051909

19061910
<para>
1907-
This is specified by <literal>WITHOUT OVERLAPS</literal> on the
1908-
last specified column.
1911+
This is specified by <literal>WITHOUT OVERLAPS</literal> for
1912+
<literal>PRIMARY KEY</literal> and <literal>UNIQUE</literal>, and by
1913+
<literal>PERIOD</literal> for foreign keys, all applied to the last
1914+
specified column.
19091915
</para>
19101916
</listitem>
19111917

0 commit comments

Comments
 (0)