[ANNOUNCE] 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
-----

* Downloads Page
   https://www.postgresql.org/download/

* Beta Testing Information
   https://www.postgresql.org/developer/beta/

* 10 Beta Release Notes
   https://www.postgresql.org/docs/devel/static/release-10.html

* What's New in 10
   https://wiki.postgresql.org/wiki/New_in_postgres_10

* 10 Open Items
   https://wiki.postgresql.org/wiki/PostgreSQL_10_Open_Items