Skip to content

Commit e1c9652

Browse files
peterepetere
committed
Finalize 8.5alpha2 release notes, with updates from Josh Berkus
1 parent 7bd9358 commit e1c9652

File tree

1 file changed

+74
-68
lines changed

1 file changed

+74
-68
lines changed

‎doc/src/sgml/release-8.5.sgml

Lines changed: 74 additions & 68 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/release-8.5.sgml,v 1.5 2009/10/20 19:52:58 petere Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/release-8.5.sgml,v 1.6 2009/10/21 19:43:06 petere Exp $ -->
22

33
<sect1 id="release-8-5">
44
<title>Release 8.5alpha2</title>
@@ -52,60 +52,51 @@
5252
reported.
5353
</para>
5454
</sect2>
55+
<sect2>
56+
<title>Testing</title>
57+
<para>
58+
The primary reason we release alphas is to get users to test new
59+
features as early as possible. If you are interested in helping
60+
with organized testing, please see
61+
<ulink url="http://wiki.postgresql.org/wiki/HowToBetaTest">the
62+
testing information page</ulink>.
63+
</para>
64+
</sect2>
5565
<sect2>
5666
<title>Changes</title>
5767
<sect3>
5868
<title>SQL Features</title>
5969
<itemizedlist>
60-
<listitem override="box">
61-
<para>
62-
<emphasis>Modify the definition of window-function PARTITION
63-
BY and ORDER BY clauses so that their elements are always
64-
taken as simple expressions over the query's input
65-
columns.</>
66-
</para>
67-
</listitem>
6870
<listitem>
6971
<para>
70-
<emphasis>Fix bug with WITH RECURSIVE immediately inside WITH
71-
RECURSIVE.</>
72-
</para>
73-
</listitem>
74-
<listitem>
75-
<para>
76-
<emphasis>Define a new, more extensible syntax for COPY options.</>
77-
</para>
78-
</listitem>
79-
<listitem>
80-
<para>
81-
<emphasis>Add ALTER DEFAULT PRIVILEGES command, which allows
82-
users to adjust the privileges that will be applied to
83-
subsequently-created objects.</>
72+
<emphasis>Add SQL-compliant triggers on columns, which fire only if
73+
certain columns are named in the UPDATE's SET list.</>
8474
</para>
8575
</listitem>
8676
<listitem>
8777
<para>
88-
<emphasis>Support use of function argument names to identify which
89-
actual arguments match which function parameters. The syntax
90-
uses AS, for example funcname(value AS arg1, anothervalue AS
91-
arg2).</>
78+
<emphasis>Add CREATE LIKE INCLUDING COMMENTS and STORAGE, and INCLUDING
79+
ALL shortcut to allow users to make an exact copy of a table including
80+
all options and features.</>
9281
</para>
9382
</listitem>
9483
<listitem>
9584
<para>
96-
<emphasis>Add CREATE LIKE INCLUDING COMMENTS and STORAGE, and INCLUDING
97-
ALL shortcut.</>
85+
<emphasis>Define a new, more extensible syntax for COPY options
86+
in order to support additional COPY options in the future.</>
9887
</para>
9988
</listitem>
10089
<listitem>
10190
<para>
102-
<emphasis>Add GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS IN SCHEMA.</>
91+
<emphasis>Modify the definition of window-function PARTITION
92+
BY and ORDER BY clauses so that their elements are always
93+
taken as simple expressions over the query's input
94+
columns. This fixes a bug.</>
10395
</para>
10496
</listitem>
10597
<listitem>
10698
<para>
107-
<emphasis>Add SQL-compliant triggers on columns, ie fire only if
108-
certain columns are named in the UPDATE's SET list.</>
99+
<emphasis>Fix bug with nested WITH RECURSIVE statements.</>
109100
</para>
110101
</listitem>
111102
<listitem>
@@ -171,7 +162,16 @@
171162
<listitem>
172163
<para>
173164
<emphasis>Implement &quot;join removal&quot; for cases where the inner side
174-
of a left join is unique and is not referenced above the join.</>
165+
of a left join is unique and is not referenced above the join. This should
166+
speed up many ORM-generated and reporting tool queries.</emphasis>
167+
</para>
168+
</listitem>
169+
<listitem>
170+
<para>
171+
<emphasis>Remove the use of the flat files pg_auth and
172+
pg_database in order to improve performance. (Warning: pgbouncer
173+
and possibly other tools currently suggest referring to the pg_auth
174+
file for its user database. Such schemes will no longer work.)</emphasis>
175175
</para>
176176
</listitem>
177177
<listitem>
@@ -249,7 +249,7 @@
249249
<listitem>
250250
<para>
251251
<emphasis>Make it possibly to specify server configuration parameters
252-
per user and per database. psql has gained a drds command to
252+
per user-database combination. Add a \drds command to psql to
253253
display the settings.</>
254254
</para>
255255
</listitem>
@@ -258,6 +258,14 @@
258258
<emphasis>Allow the collection of statistics on sequences.</>
259259
</para>
260260
</listitem>
261+
<listitem>
262+
<para>
263+
<emphasis>Increase the maximum value of extra_float_digits to
264+
3, and have pg_dump use that value when the backend is new
265+
enough to allow it, because it is possible to need 3 extra
266+
digits for float4 values (but not for float8 values).</>
267+
</para>
268+
</listitem>
261269
<listitem>
262270
<para>
263271
Add the ability to include the SQLSTATE error code of any error
@@ -274,26 +282,27 @@
274282
</listitem>
275283
</itemizedlist>
276284
</sect3>
277-
<sect3>
278-
<title>Server Configuration</title>
279-
<itemizedlist>
280-
<listitem>
281-
<para>
282-
<emphasis>Increase the maximum value of extra_float_digits to
283-
3, and have pg_dump use that value when the backend is new
284-
enough to allow it, because it is possible to need 3 extra
285-
digits for float4 values (but not for float8 values).</>
286-
</para>
287-
</listitem>
288-
</itemizedlist>
289-
</sect3>
290285
<sect3>
291286
<title>Security</title>
292287
<itemizedlist>
288+
<listitem>
289+
<para>
290+
<emphasis>Add ALTER DEFAULT PRIVILEGES command, which allows
291+
users to adjust the privileges that will be applied to
292+
subsequently-created objects.</>
293+
</para>
294+
</listitem>
295+
<listitem>
296+
<para>
297+
<emphasis>Add GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS IN SCHEMA.
298+
This makes it easier to manage permissions on database objects.</emphasis>
299+
</para>
300+
</listitem>
293301
<listitem>
294302
<para>
295303
<emphasis>Support &quot;samehost&quot; and &quot;samenet&quot; specifications
296-
in pg_hba.conf.</emphasis>
304+
in pg_hba.conf. This allows users with dynamic server addresses to run
305+
PostgreSQL without frequently modifying pg_hba.conf</emphasis>
297306
</para>
298307
</listitem>
299308
<listitem>
@@ -374,14 +383,6 @@
374383
the postmaster from a boot-time script.</emphasis>
375384
</para>
376385
</listitem>
377-
<listitem>
378-
<para>
379-
<emphasis>Remove the use of the flat files pg_auth and
380-
pg_database. (At least pgbouncer currently suggests referring
381-
to the pg_auth file for its user database. Such schemes will
382-
no longer work.)</emphasis>
383-
</para>
384-
</listitem>
385386
<listitem>
386387
<para>
387388
pg_dump/pg_restore --clean now drops large objects.
@@ -434,6 +435,14 @@
434435
code without having to create a function for it.</>
435436
</para>
436437
</listitem>
438+
<listitem>
439+
<para>
440+
<emphasis>Support use of function argument names to identify which
441+
actual arguments match which function parameters. The syntax
442+
uses AS, for example funcname(value AS arg1, anothervalue AS
443+
arg2).</>
444+
</para>
445+
</listitem>
437446
<listitem>
438447
<para>
439448
<emphasis>Fix/improve bytea and boolean support in PL/Python. Data type
@@ -459,7 +468,7 @@
459468
</listitem>
460469
<listitem>
461470
<para>
462-
<emphasis>Allow plpgsql IN parameters to be assigned to.</>
471+
<emphasis>PL/pgSQL IN parameters now accept value assignments.</>
463472
</para>
464473
</listitem>
465474
<listitem>
@@ -470,8 +479,8 @@
470479
</listitem>
471480
<listitem>
472481
<para>
473-
<emphasis>Allow MOVE FORWARD n, MOVE BACKWARD n, MOVE FORWARD ALL, MOVE
474-
BACKWARD ALL in PL/pgSQL.</>
482+
<emphasis>Allow cursor commands MOVE FORWARD n, MOVE BACKWARD n,
483+
MOVE FORWARD ALL, MOVE BACKWARD ALL in PL/pgSQL.</>
475484
</para>
476485
</listitem>
477486
<listitem>
@@ -498,7 +507,9 @@
498507
<itemizedlist>
499508
<listitem>
500509
<para>
501-
<emphasis>Assorted improvements in contrib/hstore.</>
510+
<emphasis>Multiple improvements in contrib/hstore, including
511+
raising limits on keys and values, conversions to and from
512+
records and arrays, and support for GROUP BY and DISTINCT.</emphasis>
502513
</para>
503514
</listitem>
504515
<listitem>
@@ -528,8 +539,8 @@
528539
</itemizedlist>
529540
</sect3>
530541
<sect3>
531-
<title>Programming Tools</title>
532-
<itemizedlist>
542+
<title>Development</title>
543+
<itemizedlist>
533544
<listitem>
534545
<para>
535546
<emphasis>Add ECPG function that returns the current transaction status.</>
@@ -543,14 +554,9 @@
543554
<listitem>
544555
<para>
545556
<emphasis>Make libpq reject non-numeric and out-of-range port numbers with a
546-
suitable error message.</>
557+
suitable error message.</emphasis>
547558
</para>
548559
</listitem>
549-
</itemizedlist>
550-
</sect3>
551-
<sect3>
552-
<title>Development</title>
553-
<itemizedlist>
554560
<listitem>
555561
<para>
556562
Functions which conflict with C++ reserved words have been renamed,

0 commit comments

Comments
 (0)