11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.74 2001/01/27 11:12:53 petere Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.75 2001/01/29 18:58:45 momjian Exp $
33-->
44
55 <appendix id="release">
@@ -119,7 +119,7 @@ Subqueries in FROM are now supported.
119119
120120 <para>
121121 <programlisting>
122- Last updated from CVS logs:2000-12-11
122+ Last updated from CVS logs:2001-01-29
123123
124124Bug Fixes
125125---------
@@ -162,14 +162,21 @@ Fix INSERT...SELECT with rules (Tom)
162162Fix FOR UPDATE inside views and subselects (Tom)
163163Fix OVERLAPS operators conform to SQL92 spec regarding NULLs (Tom)
164164Fix lpad() and rpad() to handle length less than input string (Tom)
165+ Fix use of NOTIFY in some rules (Tom)
166+ Overhaul btree code (Tom)
167+ Fix NOT NULL use in Pl/PgSQL variables (Tom)
168+ Overhaul GIST code (Oleg)
169+ Fix CLUSTER to preserve constraints and column default (Tom)
170+ Improved deadlock detection handling (Tom)
171+ Allow multiple SERIAL columns in a table (Tom)
165172
166173Enhancements
167174------------
168175Add OUTER JOINs (Tom)
169176Function manager overhaul (Tom)
170177Allow ALTER TABLE RENAME on indexes(Tom)
171178Improve CLUSTER(Tom)
172- Improve ps status display for more platforms (Peter E )
179+ Improve ps status display for more platforms(Marc )
173180Improve CREATE FUNCTION failure message(Ross)
174181JDBC improvements (Peter, Travis Bauer, Christopher Cain, William Webber,
175182 Gunnar)
@@ -184,12 +191,12 @@ ODBC cleanups/improvements (Nick Gorham, Stephan Szabo, Zoltan Kovacs,
184191 Michael Fork)
185192Allow renaming of temp tables (Tom)
186193Overhaul memory manager contexts (Tom)
187- pg_dumpall uses CREATE USER or CREATE GROUP rather using COPY (Peter E)
194+ pg_dump uses CREATE USER or CREATE GROUP rather using COPY (Peter E)
188195Overhaul pg_dump (Philip Warner)
189- Allow pg_hba.conf secondary password file to specifyonly username (Peter E)
196+ Allow pg_hba.conf secondary password file to specify username (Peter E)
190197Allow TEMPORARY or TEMP keyword when creating temporary tables (Bruce)
191198New memory leak checker (Karel)
192- New SET SESSION CHARACTERISTICS (Thomas)
199+ New SET SESSION CHARACTERISTICSand SET DefaultXactIsoLevel (Thomas, Peter E )
193200Allow nested block comments (Thomas)
194201Add WITHOUT TIME ZONE type qualifier (Thomas)
195202New ALTER TABLE ADD CONSTRAINT (Stephan)
@@ -228,16 +235,26 @@ Allow postmaster to listen on a specific IP address (David J. MacKenzie)
228235Allow socket path name to be specified in hostname by using leading slash
229236 (David J. MacKenzie)
230237Allow CREATE DATABASE to specify template database (Tom)
238+ New pg_dump --globals-only option (Peter E)
239+ New utility to convert MySQL schema dumps to SQL92 and PostgreSQL (Thomas)
240+ New /contrib/rserv replication toolkit (Vadim)
241+ New file format for COPY BINARY (Tom)
242+ New /contrib/oid2name to map numeric files to table names (B Palmer)
243+ New "idle in transaction" ps status message (Marc)
244+ Update to pgaccess 0.98.7 (Constantin Teodorescu)
231245
232246Types
233247-----
234248Fix INET/CIDR type ordering and add new functions (Tom)
235249Make OID behave as an unsigned type (Tom)
236250Allow BIGINT as synonym for INT8 (Peter E)
237251New int2 and int8 comparison operators (Tom)
238- New BIT and BIT VARYING types (Adriaan Joubert, Tom, Peter E )
252+ New BIT and BIT VARYING types (Adriaan Joubert, Tom)
239253CHAR() no longer faster than VARCHAR() because of TOAST (Tom)
240254New GIST seg/cube examples (Gene Selkov)
255+ Improved round(numeric) handling (Tom)
256+ Fix CIDR output formatting (Tom)
257+ New CIDR abbrev() function (Tom)
241258
242259Performance
243260-----------
@@ -253,7 +270,7 @@ Source Code
253270-----------
254271New function manager call conventions (Tom)
255272SGI portability fixes (David Kaelbling)
256- New configure --enable-syslog option (Peter E )
273+ New configure --enable-syslog option (Marc )
257274New BSDI README (Bruce)
258275configure script moved to top level, not /src (Peter E)
259276Makefile/configuration/compilation overhaul (Peter E)
@@ -280,6 +297,9 @@ Add IBM S/390 support (Neale Ferguson)
280297Moved macmanuf to /contrib (Larry Rosenman)
281298Syslog improvements (Larry Rosenman)
282299New template0 database that contains no user additions(Tom)
300+ New /contrib/cube and /contrib/seg GIST sample code (Gene Selkov)
301+ Allow *BSD's libedit instead of readline (Peter)
302+ Improved assembly language source code format (Bruce)
283303 </programlisting>
284304 </para>
285305 </sect2>