Re: PostgreSQL 18 GA press release draft
Jonathan S. Katz <jkatz@postgresql.org>
From: "Jonathan S. Katz" <jkatz@postgresql.org>
To: jian he <jian.universality@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-12T01:51:31Z
Lists: pgsql-hackers
On 9/10/25 12:29 AM, jian he wrote: > On Wed, Sep 10, 2025 at 11:13 AM Jonathan S. Katz <jkatz@postgresql.org> wrote: >> >> Hi, >> >> Please review for the press release for the following: >> >> * Correctness and accuracy of what's described - we want to be >> technically correct, but we also need to explain why something matters >> to our users. > > PostgreSQL 18 adds [temporal > constraints](https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-CONSTRAINTS) > -- constraints over ranges -- for both `PRIMARY KEY` and `UNIQUE` > constraints using the `WITHOUT OVERLAPS` clause, and on `FOREIGN KEY` > constraints using the `PERIOD` clause. > > this link (https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-CONSTRAINTS) > seems not that appropriate, since it does not explain WITHOUT OVERLAPS, > link (https://www.postgresql.org/docs/devel/sql-createtable.html#SQL-CREATETABLE-PARMS-UNIQUE) > would be more appropriate? I like the suggestion and made the swap. Thanks! Jonathan