1
1
<!--
2
- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian Exp $
2
+ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.270 2004/07/26 00:26:42 momjian Exp $
3
3
-->
4
4
5
5
<appendix id="release">
@@ -32,8 +32,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
32
32
installer project has been created to ease installation, <ulink
33
33
url="http://pgfoundry.org/projects/pginstaller">
34
34
http://pgfoundry.org/projects/pginstaller</ulink>. This release
35
- supports Windows NT 4 and all later releases. It does not
36
- support earlier releases like Windows 95, 98, or ME because
35
+ supports NT-based Windows releases like NT4, Win2k, XP, Win2003.
36
+ Older releases like Windows 95, 98, and ME are not supported because
37
37
these operating systems do not have the infrastructure to
38
38
support PostgreSQL.
39
39
</para>
@@ -169,57 +169,52 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
169
169
<itemizedlist>
170
170
<listitem>
171
171
<para>
172
- GUC parameters SortMem and VacuumMem have been renamed to
173
- work_mem and maintenance_work_mem to better reflect their use.
174
- The original names still supported.
172
+ Server configuration parameters SortMem and VacuumMem have been
173
+ renamed to work_mem and maintenance_work_mem to better reflect
174
+ their use. The original names still supported.
175
175
</para>
176
176
</listitem>
177
177
178
178
<listitem>
179
179
<para>
180
- GUC parameters log_pid, log_timestamp, and log_source_port have been
181
- removed now that a more flexible log_line_prefix has been added.
180
+ Server configuration parameters log_pid, log_timestamp, and
181
+ log_source_port have been removed now that a more flexible
182
+ log_line_prefix has been added.
182
183
</para>
183
184
</listitem>
184
185
185
186
<listitem>
186
187
<para>
187
- GUC parameters virtual_host and tcpip_socket have been replaced
188
- with a more general listen_addresses. Also, the server now
189
- listens on localhost by default, which eliminates the need for
190
- the -i postmaster switch in many scenarios.
188
+ Server configuration parameters virtual_host and tcpip_socket
189
+ have been replaced with a more general listen_addresses. Also,
190
+ the server now listens on localhost by default, which eliminates
191
+ the need for the -i postmaster switch in many scenarios.
191
192
</para>
192
193
</listitem>
193
194
194
195
<listitem>
195
196
<para>
196
- GUC parameter syslog has been removed and replaced with a more
197
- logical log_destination variable to control the log output
198
- destination.
197
+ Server configuration parameter syslog has been removed and
198
+ replaced with a more logical log_destination variable to control
199
+ the log output destination.
199
200
</para>
200
201
</listitem>
201
202
202
203
<listitem>
203
204
<para>
204
- GUC parameter log_statement has been changed so it can restrict
205
- logging of just database modification or data definition
206
- statements.
205
+ Server configuration parameter log_statement has been changed so
206
+ it can restrict logging of just database modification or data
207
+ definition statements.
207
208
</para>
208
209
</listitem>
209
210
210
211
<listitem>
211
212
<para>
212
- GUC parameter max_expr_depth parameter has been replaced with
213
- max_stack_depth which measures the stack size rather than the
214
- number of stack levels used. This helps prevent session
215
- termination due to stack overflow caused by recursive functions.
216
- </para>
217
- </listitem>
218
-
219
- <listitem>
220
- <para>
221
- When matching GROUP BY names, prefer local FROM columns first, then SELECT
222
- aliases, and FROM columns in upper subqueries.
213
+ Server configuration parameter max_expr_depth parameter has been
214
+ replaced with max_stack_depth which measures the stack size
215
+ rather than the number of stack levels used. This helps prevent
216
+ session termination due to stack overflow caused by recursive
217
+ functions.
223
218
</para>
224
219
</listitem>
225
220
@@ -315,9 +310,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
315
310
</para>
316
311
<para>
317
312
Before this change some queries would not use an index if the data
318
- types did not exactly match. This improvement makes index usage more
313
+ types did not match exactly . This improvement makes index usage more
319
314
intuitive and consistent.
320
- match exactly
321
315
</para>
322
316
</listitem>
323
317
@@ -355,23 +349,6 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
355
349
</para>
356
350
</listitem>
357
351
358
- <listitem>
359
- <para>
360
- Optimizer improvements and subquery fixes (Tom)
361
- </para>
362
- <para>
363
- It is difficult to explain all the optimizer improvements that go
364
- into a release like this. They involve complex adjustments to the
365
- logic used to select indexes, join methods, and join order. They
366
- are difficult to explain, but the result is that the optimizer
367
- make quicker and better choices in how to execute queries,
368
- resulting in improved performance. The close relationship between
369
- our developers and users reporting problems allows us to make
370
- rapid and complex optimizer improvements that would be very
371
- difficult for lose-source companies to emulate.
372
- </para>
373
- </listitem>
374
-
375
352
<listitem>
376
353
<para>
377
354
Improve btree index performance for duplicate keys (Dmitry Tkach, Tom)
@@ -527,9 +504,9 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
527
504
528
505
<listitem>
529
506
<para>
530
- Add new read-only GUC variables to query server compile-time
531
- setting func_max_args, index_max_keys, namedatalen, blcksz ,
532
- have_int64_timestamp (Joe)
507
+ Add new read-only server configuration parameter to query server
508
+ compile-time setting func_max_args, index_max_keys, namedatalen,
509
+ blcksz, have_int64_timestamp (Joe)
533
510
</para>
534
511
</listitem>
535
512
@@ -548,8 +525,9 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
548
525
549
526
<listitem>
550
527
<para>
551
- Rename GUC parameters SortMem and VacuumMem to work_mem and
552
- maintenance_work_mem (Old names still supported) (Tom)
528
+ Rename server configuration parameters SortMem and VacuumMem to
529
+ work_mem and maintenance_work_mem (Old names still supported)
530
+ (Tom)
553
531
</para>
554
532
<para>
555
533
This change was made to clarify that index creation uses
@@ -560,14 +538,15 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
560
538
561
539
<listitem>
562
540
<para>
563
- Allow logging of session disconnections using GUC log_disconnections (Andrew)
541
+ Allow logging of session disconnections using server configuration
542
+ log_disconnections (Andrew)
564
543
</para>
565
544
</listitem>
566
545
567
546
<listitem>
568
547
<para>
569
- Add new GUC parameter to report useful session information at the
570
- start of each log line (Andrew)
548
+ Add new server configuration parameter log_line_prefix to report useful
549
+ session information at the start of each log line (Andrew)
571
550
</para>
572
551
<para>
573
552
Information includes user name, database name, remote IP address,
@@ -577,15 +556,16 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
577
556
578
557
<listitem>
579
558
<para>
580
- Remove GUC log_pid, log_timestamp, log_source_port;
581
- functionality superseded by log_line_prefix (Andrew)
559
+ Remove server configuration parameter log_pid, log_timestamp,
560
+ log_source_port; functionality superseded by log_line_prefix
561
+ (Andrew)
582
562
</para>
583
563
</listitem>
584
564
585
565
<listitem>
586
566
<para>
587
567
Replace the virtual_host and tcpip_socket parameters with a unified
588
- listen_addresses parameter (Tom)
568
+ listen_addresses parameter (Andrew, Tom)
589
569
</para>
590
570
</listitem>
591
571
@@ -603,15 +583,16 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
603
583
604
584
<listitem>
605
585
<para>
606
- Remove 'syslog' GUC variable, and add more logical 'log_destination'
607
- variable to control log output location (Magnus)
586
+ Remove 'syslog' server configuration parameter, and add more
587
+ logical 'log_destination' variable to control log output location
588
+ (Magnus)
608
589
</para>
609
590
</listitem>
610
591
611
592
<listitem>
612
593
<para>
613
- Change GUC log_statement to take values "all, mod, ddl, none" which
614
- controls the queries output (Bruce)
594
+ Change server configuration parameter log_statement to take values
595
+ "all, mod, ddl, none" which controls the queries output (Bruce)
615
596
</para>
616
597
<para>
617
598
This allows administrators to log only data definition changes or
@@ -628,7 +609,7 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
628
609
<listitem>
629
610
<para>
630
611
Allow configuration files to be placed outside the data directory using
631
- GUC variables (mlw)
612
+ server configuration parameters (mlw)
632
613
</para>
633
614
<para>
634
615
By default, configuration files sit in the top server directory.
@@ -678,7 +659,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
678
659
679
660
<listitem>
680
661
<para>
681
- Implement dollar quoting to simplify single-quote usage (Andrew)
662
+ Implement dollar quoting to simplify single-quote usage (Andrew, Tom,
663
+ David Fetter)
682
664
</para>
683
665
<para>
684
666
In previous releases, because single quotes had to be used to
@@ -720,17 +702,6 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
720
702
</para>
721
703
</listitem>
722
704
723
- <listitem>
724
- <para>
725
- When matching GROUP BY names, prefer local FROM columns first, then SELECT
726
- aliases, and then outer FROM columns (Tom)
727
- </para>
728
- <para>
729
- This change was made because it is considered more consistent than
730
- the previous behavior.
731
- </para>
732
- </listitem>
733
-
734
705
<listitem>
735
706
<para>
736
707
Change EXECUTE to return a completion tag matching the executed statement
@@ -780,8 +751,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
780
751
781
752
<listitem>
782
753
<para>
783
- Add new GUC default_with_oids to control the oid default during table
784
- creation (Neil)
754
+ Add new server configuration parameter default_with_oids to
755
+ control the oid default during table creation (Neil)
785
756
</para>
786
757
<para>
787
758
This allows administrators to default all CREATE TABLE commands to
@@ -1512,6 +1483,12 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
1512
1483
</para>
1513
1484
</listitem>
1514
1485
1486
+ <listitem>
1487
+ <para>
1488
+ psql now uses a lexical analyzer to process command strings
1489
+ </para>
1490
+ </listitem>
1491
+
1515
1492
<listitem>
1516
1493
<para>
1517
1494
New linked list data structure implementation (Neil)
@@ -1524,7 +1501,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.269 2004/07/25 04:18:05 momjian
1524
1501
1525
1502
<listitem>
1526
1503
<para>
1527
- Allow external interfaces to create their own GUC variables (Thomas
1504
+ Allow external interfaces to create their own server configuration
1505
+ parameters (Thomas
1528
1506
Hallgren)
1529
1507
</para>
1530
1508
</listitem>
@@ -2242,7 +2220,7 @@ DROP SCHEMA information_schema CASCADE;
2242
2220
<para>
2243
2221
The server-side autocommit setting was removed and
2244
2222
reimplemented in client applications and languages.
2245
- Server -side autocommit was causing too many problems with
2223
+ server -side autocommit was causing too many problems with
2246
2224
languages and applications that wanted to control their own
2247
2225
autocommit behavior, so autocommit was removed from the server
2248
2226
and added to individual client APIs as appropriate.
0 commit comments