pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedrelease-9.0.sgml changes
5+ messages / 3 participants
[nested] [flat]
* release-9.0.sgml changes
@ 2010-07-09 21:24 Erik Rijkers <er@xs4all.nl>
2010-07-10 00:27 ` Re: release-9.0.sgml changes Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Erik Rijkers @ 2010-07-09 21:24 UTC (permalink / raw)
To: pgsql-docs
Some readability improvements (I hope),
and some typos
Erik Rijkers
Attachments:
release-9.0.sgml.diff (application/octet-stream, 6.0K) download
--- doc/src/sgml/release-9.0.sgml.orig 2010-07-09 21:26:26.000000000 +0200
+++ doc/src/sgml/release-9.0.sgml 2010-07-09 23:18:16.000000000 +0200
@@ -16,11 +16,10 @@
<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:
+ 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,10 +53,9 @@
<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.
+ 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,7 +181,7 @@
<para>
Adjust <link
linkend="guc-log-temp-files"><varname>log_temp_files</></link> to
- use default file sizes units of kilobytes (Robert Haas)
+ use default file size units of kilobytes (Robert Haas)
</para>
</listitem>
@@ -428,7 +426,7 @@
<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
+ 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,7 +501,7 @@
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.
+ by object-relational mappers (ORM).
</para>
</listitem>
@@ -819,7 +817,7 @@
</para>
<para>
- This lets DBAs and security staff to audit when database settings
+ This lets DBAs and security staff audit when database settings
were changed.
</para>
@@ -1002,12 +1000,12 @@
<para>
Add <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER
DEFAULT PRIVILEGES</></link> command to control privileges
- of all newly-created objects (Petr Jelinek)
+ of newly-created objects (Petr Jelinek)
</para>
<para>
This greatly simplifies the assignment of object priveleges in
- a complex database application. Defaults currently support tables
+ 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,7 +1083,7 @@
<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,
+ 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,7 +1091,7 @@
<listitem>
<para>
- Generalize uniqueness constraints by allowing arbitrary operator
+ Exclusion Constraints: generalize uniqueness constraints by allowing arbitrary operator
comparisons, not just equality (Jeff Davis)
</para>
@@ -1661,8 +1659,8 @@
<listitem>
<para>
Implement anonymous functions using the <link
- linkend="SQL-DO"><command>DO</></link> statement (Petr
- Jelinek, Joshua Tolley, Hannu Valtonen)
+ linkend="SQL-DO"><command>DO</></link> statement, a.k.a anonymous
+ blocks (Petr Jelinek, Joshua Tolley, Hannu Valtonen)
</para>
<para>
@@ -1861,7 +1859,7 @@
</para>
<para>
- This can be enabled with the server variable <link
+ This can be globally enabled with the server variable <link
linkend="guc-plperl-use-strict">plperl.use_strict</link>.
</para>
</listitem>
@@ -2010,7 +2008,7 @@
<listitem>
<para>
- Fix <command>psql --file -</> to properly honor <link
+ Fix <command>psql --file -</> (i.e. STDIN) to properly honor <link
linkend="R1-APP-PSQL-3"><option>--single-transaction</></link>
(Bruce Momjian)
</para>
@@ -2305,7 +2303,7 @@
<listitem>
<para>
Add the <literal>string</> data type in <application>ecpg</>
- Informix-compatibility mode (Zoltan Boszormenyi)
+ Informix-compatibility mode (Boszormenyi Zoltan)
</para>
</listitem>
@@ -2369,8 +2367,8 @@
<listitem>
<para>
Allow <application>ecpg</> to use noise words <literal>FROM</> and
- <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Zoltan
- Boszormenyi)
+ <literal>IN</> in <command>FETCH</> and <command>MOVE</> (Boszormenyi
+ Zoltan)
</para>
</listitem>
@@ -2904,7 +2902,7 @@
<listitem>
<para>
- Improve <filename>/contrib/dblink</>s handling of dropped columns
+ Improve <filename>/contrib/dblink</>'s handling of dropped columns
(Tom Lane)
</para>
* Re: release-9.0.sgml changes
2010-07-09 21:24 release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
@ 2010-07-10 00:27 ` Robert Haas <robertmhaas@gmail.com>
2010-07-10 08:09 ` Re: release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
2010-07-12 18:29 ` Re: release-9.0.sgml changes Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 5+ messages in thread
From: Robert Haas @ 2010-07-10 00:27 UTC (permalink / raw)
To: Erik Rijkers <er@xs4all.nl>; +Cc: pgsql-docs
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.
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
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: release-9.0.sgml changes
2010-07-09 21:24 release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
2010-07-10 00:27 ` Re: release-9.0.sgml changes Robert Haas <robertmhaas@gmail.com>
@ 2010-07-10 08:09 ` Erik Rijkers <er@xs4all.nl>
2010-07-12 18:31 ` Re: release-9.0.sgml changes Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 5+ messages in thread
From: Erik Rijkers @ 2010-07-10 08:09 UTC (permalink / raw)
To: Robert Haas <robertmhaas@gmail.com>; +Cc: pgsql-docs
On Sat, July 10, 2010 02:27, 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 just thought it silly to parade such a minimal change in an overview of Major Enhancement Areas.
But obviously none of what I sent matters much. Maybe you (or someone) can just pick out & apply
the obvious typos?
Erik Rijkers
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: release-9.0.sgml changes
2010-07-09 21:24 release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
2010-07-10 00:27 ` Re: release-9.0.sgml changes Robert Haas <robertmhaas@gmail.com>
2010-07-10 08:09 ` Re: release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
@ 2010-07-12 18:31 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2010-07-12 18:31 UTC (permalink / raw)
To: Erik Rijkers <er@xs4all.nl>; +Cc: Robert Haas <robertmhaas@gmail.com>; pgsql-docs
Erik Rijkers wrote:
> On Sat, July 10, 2010 02:27, 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 just thought it silly to parade such a minimal change in an overview of Major Enhancement Areas.
>
> But obviously none of what I sent matters much. Maybe you (or someone) can just pick out & apply
> the obvious typos?
Done. I kept the pl/pgsql default install mention in the release notes.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: release-9.0.sgml changes
2010-07-09 21:24 release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
2010-07-10 00:27 ` Re: release-9.0.sgml changes Robert Haas <robertmhaas@gmail.com>
@ 2010-07-12 18:29 ` Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2010-07-12 18:29 UTC (permalink / raw)
To: Robert Haas <robertmhaas@gmail.com>; +Cc: Erik Rijkers <er@xs4all.nl>; pgsql-docs
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. +
Attachments:
/rtmp/diff (text/x-diff, 8.6K) download
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>
end of thread, other threads:[~2010-07-12 18:31 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-09 21:24 release-9.0.sgml changes Erik Rijkers <er@xs4all.nl>
2010-07-10 00:27 ` Robert Haas <robertmhaas@gmail.com>
2010-07-10 08:09 ` Erik Rijkers <er@xs4all.nl>
2010-07-12 18:31 ` Bruce Momjian <bruce@momjian.us>
2010-07-12 18:29 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox