PostgreSQL 10 Beta 2 Released

The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 10 is available for download. This release contains previews of all of the features which will be available in the final release of version 10, including fixes to many of the issues found in the first beta. Users are encouraged to begin testing their applications against 10 beta2.

Upgrading to Beta2

PostgreSQL 10 beta2 requires an upgrade from beta1 or earlier either using pg_dump / pg_restore or pg_upgrade.

Changes Since Beta1

Any bugfixes applied to 9.6 or earlier that also affected 10 are included in beta2. Our users and contributors also reported bugs against 10 beta 1, and many of them have been fixed in this release. We urge our community to re-test to ensure that these bugs are actually fixed, including:

Fix memory leaks in new partitioning code

Don’t explicitly mark range partitioning columns as NOT NULL

Fix compilation with BSD authentication

Try next host after timeout in libpq with multiple hosts specified

Verify that the server constructed SCRAM none correctly

Fix table sync in logical replication for tables with columns in different order

Fix pg_dump:ing collations from pre-10 servers

Fix crash in BRIN index auto summarization

Generate pg_basebackup temporary slot name from backend pid, not client

Make ALTER SEQUENCE fully transactional

Allow COPY (query) TO to be parallelized

Fix ALTER SUBSCRIPTION grammar ambiguity

Don’t set application_name in logical replication workers

Allow query cancel of walsender backends

Prevent BEFORE triggers from violating partition constraints

Mark to_tsvector(regconfig, json[b]) functions as immutable

Apply RLS policies to partitioned tables

Add MSVC build system support for ICU and fix ICU support on Windows

Disallow set returning functions inside CASE or COALESCE

Teach PL/pgSQL about partitioned tables

Don’t downcase entries in shared_preload_libraries et al

Prevent table partitions from being turned into views

Fix IF NOT EXISTS in CREATE STATISTICS

Fix memory leaks in in ICU encoding conversion

Fix import of system collations

Fix logical replication with replication identity full

Support tcp_keepalive_idle option on Solaris

Don’t require schema public to exist for pg_dump -c

Fix transition tables for partition/inheritance, writable CTEs and ON CONFLICT

Change pg_ctl -w to detect server-ready state by watching status in postmaster.pid

Forbid gen_random_uuid() when built with --disable-strong-random

Allow libpq to use multiple hostaddrs to go with multiple hostnames

Fix COPY handling of transition tables with indexes

On Windows, retry process creation in case shared memory reservation fails

Note that some known issues remain unfixed. Before reporting a bug in the beta, please check the Open Items page.

Beta Schedule

This is the second beta release of version 10. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2017. For further information please see the Beta Testing page.

Links