|
1 |
| -<!-- $PostgreSQL: pgsql/doc/src/sgml/release-9.0.sgml,v 2.39.2.1 2010/07/27 19:01:04 petere Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/release-9.0.sgml,v 2.39.2.2 2010/07/29 21:18:16 tgl Exp $ --> |
2 | 2 |
|
3 | 3 | <sect1 id="release-9-0">
|
4 | 4 | <title>Release 9.0</title>
|
|
8 | 8 | <simpara>2010-??-??</simpara>
|
9 | 9 | </note>
|
10 | 10 |
|
| 11 | + <para>CURRENT AS OF 2010-07-29</para> |
| 12 | + |
11 | 13 | <sect2>
|
12 | 14 | <title>Overview</title>
|
13 | 15 |
|
|
16 | 18 | <productname>PostgreSQL</> adds features that have been requested
|
17 | 19 | for years, like easy-to-use replication, a mass permission
|
18 | 20 | facility, and anonymous blocks. While past major releases have
|
19 |
| - been quite conservative in their scope, this release shows a |
20 |
| - bold new desire to provide facilities that every new and existing |
21 |
| - user of <productname>PostgreSQL</> will embrace. This has all |
22 |
| - been done with few incompatibilities. The major areas of |
23 |
| - enhancement are: |
| 21 | + been conservative in their scope, this release shows a |
| 22 | + bold new desire to provide facilities that new and existing |
| 23 | + users of <productname>PostgreSQL</> will embrace. This has all |
| 24 | + been done with few incompatibilities. Major enhancements are: |
24 | 25 | </para>
|
25 | 26 |
|
26 | 27 | <itemizedlist>
|
|
54 | 55 | <para>
|
55 | 56 | Broadly enhanced stored procedure support.
|
56 | 57 | The <link linkend="SQL-DO"><command>DO</></link> statement permits
|
57 |
| - ad-hoc or anonymous code blocks. Functions can now be called using named |
| 58 | + anonymous code blocks. Functions can now be called using named |
58 | 59 | parameters. PL/pgSQL is now installed by default, and PL/Perl and
|
59 | 60 | PL/Python have been enhanced in several ways, including support for
|
60 | 61 | Python3.
|
|
132 | 133 | <sect2>
|
133 | 134 |
|
134 | 135 | <title>Migration to Version 9.0</title>
|
135 |
| - <para>CURRENT AS OF 2010-07-08</para> |
136 | 136 |
|
137 | 137 | <para>
|
138 | 138 | A dump/restore using <application>pg_dump</application>
|
|
183 | 183 | <para>
|
184 | 184 | Adjust <link
|
185 | 185 | linkend="guc-log-temp-files"><varname>log_temp_files</></link> to
|
186 |
| - use default file sizes units of kilobytes (Robert Haas) |
| 186 | + use default file size units of kilobytes (Robert Haas) |
187 | 187 | </para>
|
188 | 188 | </listitem>
|
189 | 189 |
|
|
428 | 428 | <para>
|
429 | 429 | This feature is called Streaming Replication.
|
430 | 430 | Previously <acronym>WAL</> files could be sent to standby systems only
|
431 |
| - as 16 megabytes files; this allows master changes to be sent to the |
| 431 | + as 16 megabytes files; Streaming Replication allows master changes to be sent to the |
432 | 432 | standby with very little delay. There are new <filename>postgresql.conf</>
|
433 | 433 | and <filename>recovery.conf</> settings to enable this
|
434 | 434 | feature, as well as extensive <link
|
|
503 | 503 | Outer joins where the inner side is unique and not referenced in
|
504 | 504 | the query are unnecessary and are therefore now removed. This will
|
505 | 505 | accelerate many automatically generated queries, such as those created
|
506 |
| - by object-relational mappers. |
| 506 | + by object-relational mappers (ORM). |
507 | 507 | </para>
|
508 | 508 | </listitem>
|
509 | 509 |
|
|
819 | 819 | </para>
|
820 | 820 |
|
821 | 821 | <para>
|
822 |
| - This lets DBAs and security staff to audit when database settings |
| 822 | + This lets DBAs and security staff audit when database settings |
823 | 823 | were changed.
|
824 | 824 | </para>
|
825 | 825 |
|
|
1002 | 1002 | <para>
|
1003 | 1003 | Add <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER
|
1004 | 1004 | DEFAULT PRIVILEGES</></link> command to control privileges
|
1005 |
| - of all newly-created objects (Petr Jelinek) |
| 1005 | + of newly-created objects (Petr Jelinek) |
1006 | 1006 | </para>
|
1007 | 1007 |
|
1008 | 1008 | <para>
|
1009 |
| - This greatly simplifies the assignment of object priveleges in |
1010 |
| - a complex database application. Defaults currently support tables |
| 1009 | + This greatly simplifies the assignment of object privileges in |
| 1010 | + a complex database application. Defaults currently support tables, |
1011 | 1011 | views, sequences, and functions. Defaults may be assigned on a
|
1012 | 1012 | per-schema basis or database-wide.
|
1013 | 1013 | </para>
|
|
1085 | 1085 |
|
1086 | 1086 | <para>
|
1087 | 1087 | This allows <command>UPDATE tab SET col = col + 1</> to work on
|
1088 |
| - columns that have a unique indexes or are marked as primary keys, |
| 1088 | + columns that have a unique indexes or are marked as primary key, |
1089 | 1089 | but <literal>DEFERRABLE INITIALLY DEFERRED</> must be used to mark
|
1090 | 1090 | the constraint as deferred.
|
1091 | 1091 | </para>
|
1092 | 1092 | </listitem>
|
1093 | 1093 |
|
1094 | 1094 | <listitem>
|
1095 | 1095 | <para>
|
1096 |
| - Generalize uniqueness constraints by allowing arbitrary operator |
| 1096 | + Exclusion Constraints: generalize uniqueness constraints by allowing arbitrary operator |
1097 | 1097 | comparisons, not just equality (Jeff Davis)
|
1098 | 1098 | </para>
|
1099 | 1099 |
|
|
1661 | 1661 | <listitem>
|
1662 | 1662 | <para>
|
1663 | 1663 | Implement anonymous functions using the <link
|
1664 |
| - linkend="SQL-DO"><command>DO</></link> statement (Petr |
1665 |
| - Jelinek, Joshua Tolley, Hannu Valtonen) |
| 1664 | + linkend="SQL-DO"><command>DO</></link> statement, a.k.a anonymous |
| 1665 | + blocks (Petr Jelinek, Joshua Tolley, Hannu Valtonen) |
1666 | 1666 | </para>
|
1667 | 1667 |
|
1668 | 1668 | <para>
|
|
1861 | 1861 | </para>
|
1862 | 1862 |
|
1863 | 1863 | <para>
|
1864 |
| - This can be enabled with the server variable <link |
| 1864 | + This can be globally enabled with the server variable <link |
1865 | 1865 | linkend="guc-plperl-use-strict">plperl.use_strict</link>.
|
1866 | 1866 | </para>
|
1867 | 1867 | </listitem>
|
|
2030 | 2030 | </para>
|
2031 | 2031 | </listitem>
|
2032 | 2032 |
|
| 2033 | + <listitem> |
| 2034 | + <para> |
| 2035 | + Show <literal>\timing</> output when enabled, regardless of |
| 2036 | + <quote>quiet</> mode (Peter Eisentraut) |
| 2037 | + </para> |
| 2038 | + </listitem> |
| 2039 | + |
2033 | 2040 | </itemizedlist>
|
2034 | 2041 |
|
2035 | 2042 | <sect5>
|
|
2305 | 2312 | <listitem>
|
2306 | 2313 | <para>
|
2307 | 2314 | Add the <literal>string</> data type in <application>ecpg</>
|
2308 |
| - Informix-compatibility mode (Zoltan Boszormenyi) |
| 2315 | + Informix-compatibility mode (Boszormenyi Zoltan) |
2309 | 2316 | </para>
|
2310 | 2317 | </listitem>
|
2311 | 2318 |
|
|
2369 | 2376 | <listitem>
|
2370 | 2377 | <para>
|
2371 | 2378 | Allow <application>ecpg</> to use noise words <literal>FROM</> and
|
2372 |
| - <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Zoltan |
2373 |
| - Boszormenyi) |
| 2379 | + <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Boszormenyi |
| 2380 | + Zoltan) |
2374 | 2381 | </para>
|
2375 | 2382 | </listitem>
|
2376 | 2383 |
|
|
0 commit comments