Re: PG 18 relnotes and RC1

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: "Jonathan S. Katz" <jkatz@postgresql.org>, Peter Eisentraut <peter@eisentraut.org>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>, corey.huinker@gmail.com
Date: 2025-09-18T18:19:30Z
Lists: pgsql-hackers
On Thu, Sep 18, 2025 at 01:38:44PM -0400, Robert Haas wrote:
> That seems completely backwards to me. We should go with the version
> that was submitted weeks ago and upon which people have had the
> opportunity to comment unless you can justify each change that you now
> want to make at the last minute. Why for example should we drop
> mentioning the ability to return OLD.* and NEW.* in favor of mentioned
> UUIDv7? I'd argue that the former is more important than the latter,
> and I don't see how you can argue otherwise except by appealing to the
> research you've done over the last several weeks. But none of us have
> access to that or got a vote in it. These things ought to be decided
> by consensus. If you want your research to feed into the building of
> that consensus, you need to do it and present it earlier. For example,
> if you want to present survey results, I think that's a great way to
> help decide these kinds of things, but then other people should have
> the right to present their own survey results and so on in that
> conversation too.

Quick analysis of the differences:

    Common:
    * AIO
    * skip scan
    * pg_upgrade
    * UUIDv7
    * virtual generated columns
    * OAuth

    Only v1 (my patch):
    * OLD/NEW for RETURNING
    * temporal constraints
    * EXPLAIN enhancements

    Only v2 (Jonathan's):
    * conflict logging

While the EXPLAIN enhancements and conflict logging items seem like super
useful features, I can see how there might be disagreement over whether
they belong in the major features list.  I'm a little more surprised about
the omission of OLD/NEW and temporal contraints in v2, though.

That being said, I'm tempted to suggest we UNION the two lists, bikeshed
over the exact wording for a few hours, and then call it day...

-- 
nathan



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Add list of major features to the v18 release notes.

  2. add_commit_links.pl: error out if missing major version number

  3. doc PG 18 relnotes: Add migration note about tsearch

  4. Remove ts_locale.c's lowerstr()