0002-Revert-doc-clarify-PERIOD-and-WITHOUT-OVERLAPS-in-CR.patch

text/plain

Filename: 0002-Revert-doc-clarify-PERIOD-and-WITHOUT-OVERLAPS-in-CR.patch
Type: text/plain
Part: 1
Message: Re: SQL:2011 application time

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: format-patch
Series: patch 0002
Subject: Revert "doc: clarify PERIOD and WITHOUT OVERLAPS in CREATE TABLE"
File+
doc/src/sgml/ref/create_table.sgml 5 7
From b8ae6cca6ad4446c3a1dd2d5356605c944d70072 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter@eisentraut.org>
Date: Wed, 15 May 2024 10:28:29 +0200
Subject: [PATCH 02/10] Revert "doc:  clarify PERIOD and WITHOUT OVERLAPS in
 CREATE TABLE"

This reverts commit c3db1f30cbaff4b96325615557de1f3528d5fd4a.
---
 doc/src/sgml/ref/create_table.sgml | 12 +++++-------
 1 file changed, 5 insertions(+), 7 deletions(-)

diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index a5bf80fb27e..ee169c5b772 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1183,13 +1183,11 @@ <title>Parameters</title>
       referent for its entire duration.  This column must be a range or
       multirange type.  In addition, the referenced table must have a primary
       key or unique constraint declared with <literal>WITHOUT
-      OVERLAPS</literal>. Finally, if the foreign key has a PERIOD
-      <replaceable class="parameter">column_name</replaceable> specification
-      the corresponding <replaceable class="parameter">refcolumn</replaceable>,
-      if present, must also be marked <literal>PERIOD</literal>.  If the
-      <replaceable class="parameter">refcolumn</replaceable> clause is omitted,
-      and thus the reftable's primary key constraint chosen, the primary key
-      must have its final column marked <literal>WITHOUT OVERLAPS</literal>.
+      OVERLAPS</literal>.  Finally, if one side of the foreign key uses
+      <literal>PERIOD</literal>, the other side must too.  If the <replaceable
+      class="parameter">refcolumn</replaceable> list is omitted, the
+      <literal>WITHOUT OVERLAPS</literal> part of the primary key is treated
+      as if marked with <literal>PERIOD</literal>.
      </para>
 
      <para>
-- 
2.44.0