Thread

Re: PG 18 relnotes and RC1

Jonathan S. Katz <jkatz@postgresql.org> — 2025-09-18T19:05:52Z

On 9/18/25 2:33 PM, Jonathan S. Katz wrote:
> On 9/18/25 2:19 PM, Nathan Bossart wrote:

>> 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...
> 
> Let's hack on this together for a few and bring a proposal to the list.

Nathan & I hopped on a call to "pair program" on this. Given the point 
that his patch had been available on the list for awhile with limited 
public comments to date, we did the following:

* Kept everything except EXPLAIN enhancements and conflict logging. For 
the former, a lot of this wasn't in the default EXPLAIN path. For the 
latter, this was to respect the time period of the discussion.

* Did some minor wordsmithing and linking to help with overall 
accessibility, including Erik's typo catch.

Many thanks to Nathan for pulling this together. Please see v3. Feedback 
welcome.

Thanks,

Jonathan