On 11/6/18 9:35 PM, Amit Langote wrote: > On 2018/11/07 11:28, Noah Misch wrote: >> On Mon, Nov 05, 2018 at 10:49:30PM -0500, Jonathan S. Katz wrote: >>> On 11/5/18 9:58 PM, Amit Langote wrote: >>>> On 2018/11/06 11:25, Noah Misch wrote: >>>>> On Mon, Nov 05, 2018 at 04:01:59PM -0500, Jonathan S. Katz wrote: >>>>>> Attached is a draft of the press release for review. Please let me know >>>>>> if there are any corrections/suggestions. >>>>>> * Disallows the creation of a new partition from a trigger that is >>>>>> attached to its parent table to prevent a crash; this behavior could be >>>>>> modified in a future release >>>>>> * Fix that prevents crashes in triggers on tables with recently added >>>>>> columns >>>>> >>>>> I would replace these two with "Fix crashes in triggers". The details >>>>> are too >>>>> esoteric, for the first especially, to list here. >>>> >>>> +1 >>> >>> Thanks for the feedback. I made the suggested changes upthread as well >>> as the above. Please see attached. >> >> Looks good. > > Sorry, I looked at the updated .md file only now. > > * Fix several crashes with triggers on partitions > > One of the fixed bugs involving triggers is not related to partitions [1], > so I'm not sure about mentioning the phrase "on partitions" here.
Thanks. I left it as "Fix several crashes with triggers" - please see attached. I also added two additional bullet points based on the updates to the upcoming release. Thanks again for the feedback! Jonathan
2018-11-08 Cumulative Update ============================ The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.1, 10.6, 9.6.11, 9.5.13, 9.4.20, 9.3.25. This release fixes bugs reported over the last three months. All users using the affected versions of PostgreSQL should update during the next convenient upgrade period. Please see the notes on "Updating" below for any post-update steps that may be required if you are using `pg_stat_statements` in your installation. This update is also the final release for PostgreSQL 9.3, which is now end-of-life and will no longer receive any bug or security fixes. If your environment still uses PostgreSQL 9.3, please make plans to update to a community supported version as soon as possible. Please see our [versioning policy](https://www.postgresql.org/support/versioning/) for more information. Bug Fixes and Improvements -------------------------- This update also fixes numerous bugs that were reported in the last several months. Some of these issues affect only version 11, but many affect all supported versions. These releases include fixes that: * Ensure that if a parent partition has an index created in a tablespace, then all child indexes will be created in that same tablespace * Fix several crashes with triggers * Fix problems with applying `ON COMMIT DELETE ROWS` to a partitioned temporary table * Fix how `NULL` values are handled when using `LEFT JOIN` with a parallelized hash join * Several fixes around using named or defaulted arguments in `CALL` statements * Fix for strict aggregate functions (i.e. aggregates that cannot accept `NULL` inputs) with ORDER BY columns that enforces the strictness check * Fix with `CASE` statements where an expression was cast to an array type * Disable an optimization for updating expression indexes in order to prevent a crash * Fix a memory leak that occurred on a specific case of using a SP-GiST index * Fix for `pg_verify_checksums` incorrectly reporting on files that are not expected to have checksums * Prevent the PostgreSQL server from starting when `wal_level` is set to a value that cannot support an existing replication slot * Ensure that the server will process already-received NOTIFY and SIGTERM interrupts before waiting for client input * Allow PL/Ruby to work with newer versions of PostgreSQL * Fix for character-class checks on Windows for Unicode characters above U+FFFF, which affected full-text search as well as `contrib/ltree` and `contrib/pg_trgm` * Fix a case where `psql` would not report the receipt of a message from a `NOTIFY` call until after the next command * Fix build problems on macOS 10.14 (Mojave) * Several build fixes for the Windows platform This updates also contains tzdata release 2018g for DST law changes in Chile, Fiji, Morocco, and Russia (Volgograd), plus historical corrections for China, Hawaii, Japan, Macau, and North Korea. PostgreSQL 9.3 is End-of-Life (EOL) ----------------------------------- PostgreSQL 9.3 is now end-of-life and will no longer receive any bug or security fixes. We urge users to start planning an upgrade to a later version of PostgreSQL as soon as possible. Please see our [versioning policy](https://www.postgresql.org/support/versioning/) for more information. Updating -------- All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use `pg_upgrade` in order to apply this update release; you may simply shutdown PostgreSQL and update its binaries. If your system is using `pg_stat_statements` and you are running a version of PostgreSQL 10 or PostgreSQL 11, we advise that you execute the following command after upgrading: `ALTER EXTENSION pg_stat_statements UPDATE;` Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details. Links ----- * [Download](https://www.postgresql.org/download/) * [Release Notes](https://www.postgresql.org/docs/current/release.html) * [Security Page](https://www.postgresql.org/support/security/) * [Versioning Policy](https://www.postgresql.org/support/versioning/) * [Follow @postgresql on Twitter](https://twitter.com/postgresql)
signature.asc
Description: OpenPGP digital signature