Re: PostgreSQL 19 beta 1 release announcement draft

On 5/29/26 12:46 PM, Robert Haas wrote:
> On Thu, May 28, 2026 at 11:23 PM Jonathan S. Katz <jkatz(at)postgresql(dot)org> wrote:
>> Attached is the draft of the PostgreSQL 19 Beta 1 release announcement.
>> Please review for accuracy (e.g. are features described correctly? Did I
>> miss a revert), recommendations on additions or glaring omissions,
>> structure, etc.
>
> I asked Claude to analyze this for things that were missing. It
> mentioned these as things that should possibly be mentioned: INSERT ON
> CONFLICT SELECT, eager aggregation, IGNORE NULLS for window functions,
> pg_dumpall for non-text formats. Of those, I would personally judge
> eager aggregation to be the most significant.
>
> It also pointed out that the bit about GRANTED BY is misleading,
> because the syntax already existed, and already worked for roles.
> What's different is that for non-roles, it now can be used with values
> other than CURRENT_USER/CURRENT_ROLE and actually do something. It
> suggested that this was actually too minor to be included in a release
> note draft. I agree -- it's a small patch to fill a gap that few
> people will ever really be troubled by. Of course it will be useful to
> those who do run into it, but it's not really a headline feature IMHO.
Thanks - that was helpful. I went with:

* including INSERT ON CONFLICT SELECT RETURNING and eager aggregation
* removing the GRANTED BY section

I'll post the updated copy at the top of the thread shortly as I work
through the rest of the feedback and add in the relevant links.

Thanks,

Jonathan