Robert Haas wrote:
> On Fri, Jul 9, 2010 at 5:24 PM, Erik Rijkers <er@xs4all.nl> wrote:
> > Some readability improvements (I hope),
> > and some typos
>
> You seem to have removed the mention of PL/pgsql being installed by
> default, which doesn't seem right.
>
> I also notice that adjacent to one of your changes we have
> "privileges" spelled as "priveleges" - this is not a fault in your
> patch, but we should probably fix it.
Fixed.
> I don't think I agree with these:
>
> - Fix <command>psql --file -</> to properly honor <link
> + Fix <command>psql --file -</> (i.e. STDIN) to properly honor <link
> - Improve <filename>/contrib/dblink</>s handling of dropped columns
> + Improve <filename>/contrib/dblink</>'s handling of dropped columns
Agreed.
Remainder of patch applied. Thanks.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
Index: release-9.0.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/release-9.0.sgml,v
retrieving revision 2.40
retrieving revision 2.41
diff -c -c -r2.40 -r2.41
*** release-9.0.sgml 12 Jul 2010 17:47:39 -0000 2.40
--- release-9.0.sgml 12 Jul 2010 18:25:21 -0000 2.41
***************
*** 16,26 ****
<productname>PostgreSQL</> adds features that have been requested
for years, like easy-to-use replication, a mass permission
facility, and anonymous blocks. While past major releases have
! been quite conservative in their scope, this release shows a
! bold new desire to provide facilities that every new and existing
! user of <productname>PostgreSQL</> will embrace. This has all
! been done with few incompatibilities. The major areas of
! enhancement are:
</para>
<itemizedlist>
--- 16,25 ----
<productname>PostgreSQL</> adds features that have been requested
for years, like easy-to-use replication, a mass permission
facility, and anonymous blocks. While past major releases have
! been conservative in their scope, this release shows a
! bold new desire to provide facilities that new and existing
! users of <productname>PostgreSQL</> will embrace. This has all
! been done with few incompatibilities. Major enhancements are:
</para>
<itemizedlist>
***************
*** 54,63 ****
<para>
Broadly enhanced stored procedure support.
The <link linkend="SQL-DO"><command>DO</></link> 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.
</para>
</listitem>
--- 53,61 ----
<para>
Broadly enhanced stored procedure support.
The <link linkend="SQL-DO"><command>DO</></link> statement permits
! anonymous code blocks. Functions can now be called using named
! parameters. PL/Perl and PL/Python have been enhanced in several ways,
! including support for Python3.
</para>
</listitem>
***************
*** 183,189 ****
<para>
Adjust <link
linkend="guc-log-temp-files"><varname>log_temp_files</></link> to
! use default file sizes units of kilobytes (Robert Haas)
</para>
</listitem>
--- 181,187 ----
<para>
Adjust <link
linkend="guc-log-temp-files"><varname>log_temp_files</></link> to
! use default file size units of kilobytes (Robert Haas)
</para>
</listitem>
***************
*** 428,434 ****
<para>
This feature is called Streaming Replication.
Previously <acronym>WAL</> files could be sent to standby systems only
! as 16 megabytes files; this allows master changes to be sent to the
standby with very little delay. There are new <filename>postgresql.conf</>
and <filename>recovery.conf</> settings to enable this
feature, as well as extensive <link
--- 426,432 ----
<para>
This feature is called Streaming Replication.
Previously <acronym>WAL</> files could be sent to standby systems only
! as 16 megabytes files; Streaming Replication allows master changes to be sent to the
standby with very little delay. There are new <filename>postgresql.conf</>
and <filename>recovery.conf</> settings to enable this
feature, as well as extensive <link
***************
*** 503,509 ****
Outer joins where the inner side is unique and not referenced in
the query are unnecessary and are therefore now removed. This will
accelerate many automatically generated queries, such as those created
! by object-relational mappers.
</para>
</listitem>
--- 501,507 ----
Outer joins where the inner side is unique and not referenced in
the query are unnecessary and are therefore now removed. This will
accelerate many automatically generated queries, such as those created
! by object-relational mappers (ORM).
</para>
</listitem>
***************
*** 819,825 ****
</para>
<para>
! This lets DBAs and security staff to audit when database settings
were changed.
</para>
--- 817,823 ----
</para>
<para>
! This lets DBAs and security staff audit when database settings
were changed.
</para>
***************
*** 1002,1013 ****
<para>
Add <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER
DEFAULT PRIVILEGES</></link> command to control privileges
! of all newly-created objects (Petr Jelinek)
</para>
<para>
This greatly simplifies the assignment of object privileges in
! a complex database application. Defaults currently support tables
views, sequences, and functions. Defaults may be assigned on a
per-schema basis or database-wide.
</para>
--- 1000,1011 ----
<para>
Add <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER
DEFAULT PRIVILEGES</></link> command to control privileges
! of newly-created objects (Petr Jelinek)
</para>
<para>
This greatly simplifies the assignment of object privileges in
! a complex database application. Defaults currently support tables,
views, sequences, and functions. Defaults may be assigned on a
per-schema basis or database-wide.
</para>
***************
*** 1085,1091 ****
<para>
This allows <command>UPDATE tab SET col = col + 1</> to work on
! columns that have a unique indexes or are marked as primary keys,
but <literal>DEFERRABLE INITIALLY DEFERRED</> must be used to mark
the constraint as deferred.
</para>
--- 1083,1089 ----
<para>
This allows <command>UPDATE tab SET col = col + 1</> to work on
! columns that have a unique indexes or are marked as primary key,
but <literal>DEFERRABLE INITIALLY DEFERRED</> must be used to mark
the constraint as deferred.
</para>
***************
*** 1093,1099 ****
<listitem>
<para>
! Generalize uniqueness constraints by allowing arbitrary operator
comparisons, not just equality (Jeff Davis)
</para>
--- 1091,1097 ----
<listitem>
<para>
! Exclusion Constraints: generalize uniqueness constraints by allowing arbitrary operator
comparisons, not just equality (Jeff Davis)
</para>
***************
*** 1661,1668 ****
<listitem>
<para>
Implement anonymous functions using the <link
! linkend="SQL-DO"><command>DO</></link> statement (Petr
! Jelinek, Joshua Tolley, Hannu Valtonen)
</para>
<para>
--- 1659,1666 ----
<listitem>
<para>
Implement anonymous functions using the <link
! linkend="SQL-DO"><command>DO</></link> statement, a.k.a anonymous
! blocks (Petr Jelinek, Joshua Tolley, Hannu Valtonen)
</para>
<para>
***************
*** 1861,1867 ****
</para>
<para>
! This can be enabled with the server variable <link
linkend="guc-plperl-use-strict">plperl.use_strict</link>.
</para>
</listitem>
--- 1859,1865 ----
</para>
<para>
! This can be globally enabled with the server variable <link
linkend="guc-plperl-use-strict">plperl.use_strict</link>.
</para>
</listitem>
***************
*** 2305,2311 ****
<listitem>
<para>
Add the <literal>string</> data type in <application>ecpg</>
! Informix-compatibility mode (Zoltan Boszormenyi)
</para>
</listitem>
--- 2303,2309 ----
<listitem>
<para>
Add the <literal>string</> data type in <application>ecpg</>
! Informix-compatibility mode (Boszormenyi Zoltan)
</para>
</listitem>
***************
*** 2369,2376 ****
<listitem>
<para>
Allow <application>ecpg</> to use noise words <literal>FROM</> and
! <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Zoltan
! Boszormenyi)
</para>
</listitem>
--- 2367,2374 ----
<listitem>
<para>
Allow <application>ecpg</> to use noise words <literal>FROM</> and
! <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Boszormenyi
! Zoltan)
</para>
</listitem>
