Index: release-9.0.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/release-9.0.sgml,v retrieving revision 2.34 diff -c -r2.34 release-9.0.sgml *** release-9.0.sgml 16 Jun 2010 18:46:18 -0000 2.34 --- release-9.0.sgml 24 Jun 2010 17:13:16 -0000 *************** *** 1,4 **** ! Release 9.0 --- 1,4 ---- ! Release 9.0 *************** *** 55,61 **** The DO statement permits ad-hoc or anonymous code blocks. Functions can now be called using named parameters. PL/pgSQL is now installed by default, and PL/Perl and PL/Python ! have been enhanced in several ways. --- 55,61 ---- The DO statement permits ad-hoc or anonymous code blocks. Functions can now be called using named parameters. PL/pgSQL is now installed by default, and PL/Perl and PL/Python ! have been enhanced in several ways, including support for Python3. *************** *** 290,296 **** PL/pgSQL Variables - Have PL/pgSQL throw an error if a variable name conflicts with a --- 290,295 ---- *************** *** 333,342 **** --- 332,363 ---- + + + Other Incompatibilities + + + + Remove support for platforms that don't have a working 64-bit + integer data types (Tom Lane) + + + + It is believed all supported platforms have working 64-bit integer + data types. + + + + Changes + + Version 9.0 has an unprecedented number of new major features, + and over 200 enhancements, improvements, new commands, + new functions, and other changes. + Server *************** *** 573,578 **** --- 594,604 ---- Authentication + + Version 9.0 further extends PostgreSQL's support for multiple + authentication methods, including RADIUS and improved LDAP support. + + *************** *** 624,629 **** --- 650,661 ---- Monitoring + + With increased use of PostgreSQL in high-end production systems, + users need increased monitoring. PostgresSQL 9.0 continues to add + more ways to monitor PostgreSQL applications. + + *************** *** 635,642 **** ! This allows DBAs to characterize database traffic ! and troubleshoot problems by source application. --- 667,674 ---- ! This allows DBAs to characterize database traffic ! and troubleshoot problems by source application. *************** *** 646,651 **** --- 678,689 ---- linkend="guc-log-line-prefix">log_line_prefix (Guillaume Smet) + + + This allows users to compile statistics on errors and messages + by type. + + *************** *** 653,658 **** --- 691,701 ---- Write to the Windows event log in UTF16 encoding (Itagaki Takahiro) + + + Now there is true multi-lingual support for PostgreSQL log messages + on Windows. + *************** *** 704,710 **** psql \drds command shows these settings. Backwards-compatible system views do not show this information. The primary use of this feature is setting schema ! search_path. --- 747,753 ---- psql \drds command shows these settings. Backwards-compatible system views do not show this information. The primary use of this feature is setting schema ! search_path. *************** *** 820,828 **** ! This allows operations that do not return a result, like ! SELECT INTO, to return a count of the number of rows ! processed. --- 863,871 ---- ! For drivers which support this feature, this saves an entire ! round-trip to the client, allowing result counts and pagination ! to be calculated without a second COUNT query. *************** *** 1798,1803 **** --- 1841,1858 ---- + + + PL/Perl subroutines are now given perl-visible names (Tim Bunce) + + + + PL/Perl subroutines are anonymous subrefs; this change adds entries + to the Perl symbol table for them, making profiling and code coverage + tools much more usable. + + + *************** *** 2653,2658 **** --- 2708,2727 ---- Binary Upgrade Support + + + Add /contrib/pg_upgrade + to support in-place upgrades (Bruce) + + + + This avoids the requirement of dumping/reloading the database when + upgrading to a new major release of PostgreSQL and speeds up offline + upgrades by orders of magnitude. It supports upgrades to 9.0 + from PostgreSQL 8.3 and 8.4. + + + Add support for preservation of all - Add /contrib/pg_upgrade - to support in-place upgrades (Bruce) - - - - This avoids the requirement of dumping/reloading the database when - upgrading to a new major release of PostgreSQL. It supports upgrades - from PostgreSQL 8.3 and 8.4. - - - - - Add multi-threaded option ( ! This filter dictionary removes accents from tokens. --- 2805,2813 ---- ! This filter dictionary removes accents from tokens, and ! makes full-text searches over multiple languages much ! easier. *************** *** 2775,2781 **** ! New functions and operators were also added. --- 2833,2840 ---- ! New functions and operators were also added. These improvements ! make HStore a full-functional key-value store embedded in PostgreSQL.