PostgreSQL 10 Beta 2 Released

Posted on 2017-07-13 by PostgreSQL Global Development Group

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