Re: 2021-02-11 release announcement draft

From: Noah Misch <noah(at)leadboat(dot)com>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: 2021-02-11 release announcement draft
Date: 2021-02-08 23:11:52
Message-ID: 20210208231152.GA523729@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 08, 2021 at 05:40:41PM -0500, Jonathan S. Katz wrote:
> This update also fixes over 80 bugs that were reported in the last several
> months. Some of these issues only affect version 13, but may also apply to other
> supported versions.

Did you want s/may/many/?

> * Fix an issue with GiST indexes where concurrent insertions could lead to a
> corrupt index with entries placed in the wrong pages. You should `REINDEX` any
> affected GiST indexes.

For what it's worth, there's little way for a user to confirm whether an index
is affected. (If you've never had more than one connection changing the table
at a time, the table's indexes would be unaffected.)

> * Fix `CREATE INDEX CONCURRENTLY` to ensure rows from concurrent prepared
> transactions are included in the index.

Consider adding a sentence like "Installations that have enabled prepared
transactions should `REINDEX` any concurrently-built indexes." The release
notes say:

+ In installations that have enabled prepared transactions
+ (<varname>max_prepared_transactions</varname> &gt; 0),
+ it's recommended to reindex any concurrently-built indexes in
+ case this problem occurred when they were built.

> * Fix a failure when a PL/pgSQL procedure used `CALL` on another procedure that
> has `OUT` parameters did not call execute a `COMMIT` or `ROLLBACK`.

The release notes say the failure happened when the callee _did_ execute a
COMMIT or ROLLBACK:

+ <para>
+ A <command>CALL</command> in a PL/pgSQL procedure, to another
+ procedure that has OUT parameters, would fail if the called
+ procedure did a <command>COMMIT</command>
+ or <command>ROLLBACK</command>.
+ </para>

> For more details, please see the
> [release notes](https://www.postgresql.org/docs/current/release.html).

I recommend pointing this to https://www.postgresql.org/docs/release/, since
the above link now contains only v13 notes.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2021-02-08 23:35:36 Re: Proposal: Save user's original authenticated identity for logging
Previous Message Daniel Gustafsson 2021-02-08 23:11:05 Re: Support for NSS as a libpq TLS backend