11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.97 2001/08/1421:21:40 momjian Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.98 2001/08/1423:38:20 momjian Exp $
33-->
44
55 <appendix id="release">
@@ -1245,7 +1245,7 @@ subselect+CASE fixes(Tom)
12451245Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren Sefcik)
12461246Fixes for CASE in WHERE join clauses(Tom)
12471247Fix BTScan abort(Tom)
1248- Repair the check for redundant UNIQUE and PRIMARY KEYindices (Thomas)
1248+ Repair the check for redundant UNIQUE and PRIMARY KEYindexes (Thomas)
12491249Improve it so that it checks for multi-column constraints(Thomas)
12501250Fix for Win32 making problem with MB enabled(Hiroki Kataoka)
12511251Allow BSD yacc and bison to compile pl code(Bruce)
@@ -1644,7 +1644,7 @@ Enhancements
16441644------------
16451645Add "vacuumdb" utility
16461646Speed up libpq by allocating memory better(Tom)
1647- EXPLAIN allindices used(Tom)
1647+ EXPLAIN allindexes used(Tom)
16481648Implement CASE, COALESCE, NULLIF expression(Thomas)
16491649New pg_dump table output format(Constantin)
16501650Add string min()/max() functions(Thomas)
@@ -2078,14 +2078,14 @@ Allow index use with OR clauses(Bruce)
20782078Allows "SELECT NULL ORDER BY 1;"
20792079Explain VERBOSE prints the plan, and now pretty-prints the plan to
20802080the postmaster log file(Bruce)
2081- AddIndices display to \d command(Bruce)
2081+ Addindexes display to \d command(Bruce)
20822082Allow GROUP BY on functions(David)
20832083New pg_class.relkind for large objects(Bruce)
20842084New way to send libpq NOTICE messages to a different location(Tom)
20852085New \w write command to psql(Bruce)
20862086New /contrib/findoidjoins scans oid columns to find join relationships(Bruce)
2087- Allow binary-compatibleindices to be considered when checking for valid
2088- indices for restriction clauses containing a constant(Thomas)
2087+ Allow binary-compatibleindexes to be considered when checking for valid
2088+ Indexes for restriction clauses containing a constant(Thomas)
20892089New ISBN/ISSN code in /contrib/isbn_issn
20902090Allow NOT LIKE, IN, NOT IN, BETWEEN, and NOT BETWEEN constraint(Thomas)
20912091New rewrite system fixes many problems with rules and views(Jan)
@@ -2551,7 +2551,7 @@ Real deadlock detection, no more timeouts(Bruce)
25512551Add SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,
25522552CURRENT_USER(Thomas)
25532553Modify constraint syntax to be SQL92-compliant(Thomas)
2554- Implement SQL92 PRIMARY KEY and UNIQUE clauses usingindices (Thomas)
2554+ Implement SQL92 PRIMARY KEY and UNIQUE clauses usingindexes (Thomas)
25552555Recognize SQL92 syntax for FOREIGN KEY. Throw elog notice(Thomas)
25562556Allow NOT NULL UNIQUE constraint clause (each allowed separately before)(Thomas)
25572557Allow Postgres-style casting ("::") of non-constants(Thomas)
@@ -2563,14 +2563,14 @@ Implement SQL92 binary and hexadecimal string decoding (b'10' and x'1F')(Thomas)
25632563Support SQL92 syntax for type coercion of literal strings
25642564(e.g. "DATETIME 'now'")(Thomas)
25652565Add conversions for int2, int4, and OID types to and from text(Thomas)
2566- Use shared lock when buildingindices (Vadim)
2566+ Use shared lock when buildingindexes (Vadim)
25672567Free memory allocated for an user query inside transaction block after
25682568this query is done, was turned off in <= 6.2.1(Vadim)
25692569New SQL statement CREATE PROCEDURAL LANGUAGE(Jan)
25702570New <productname>Postgres</productname> Procedural Language (PL) backend interface(Jan)
25712571Rename pg_dump -H option to -h(Bruce)
25722572Add Java support for passwords, European dates(Peter)
2573- Useindices for LIKE and ~, !~ operations(Bruce)
2573+ Useindexes for LIKE and ~, !~ operations(Bruce)
25742574Add hash functions for datetime and timespan(Thomas)
25752575Time Travel removed(Vadim, Bruce)
25762576Add paging for \d and \z, and fix \i(Bruce)
@@ -2588,7 +2588,7 @@ Regression tests time zone automatically set with "setenv PGTZ PST8PDT"(Thomas)
25882588Add pg_description table for info on tables, columns, operators, types, and
25892589aggregates(Bruce)
25902590Increase 16 char limit on system table/index names to 32 characters(Bruce)
2591- Rename systemindices (Bruce)
2591+ Rename systemindexes (Bruce)
25922592Add 'GERMAN' option to SET DATESTYLE(Thomas)
25932593Define an "ISO-style" timespan output format with "hh:mm:ss" fields(Thomas)
25942594Allow fractional values for delta times (e.g. '2.5 days')(Thomas)
@@ -3090,7 +3090,7 @@ fix join clauses for multiple tables(Vadim)
30903090fix hash, hashjoin for arrays(Vadim)
30913091fix btree for abstime type(Vadim)
30923092large object fixes(Raymond)
3093- fix buffer leak in hashindices (Vadim)
3093+ fix buffer leak in hashindexes (Vadim)
30943094fix rtree for use in inner scan (Vadim)
30953095fix gist for use in inner scan, cleanups (Vadim, Andrea)
30963096avoid unnecessary local buffers allocation (Vadim, Massimo)
@@ -3337,15 +3337,19 @@ Unused/uninialized variables corrected
33373337</author>
33383338</authorgroup>
33393339<date>
3340- Unknown
3340+ 1996-11-04
33413341</date>
33423342</docinfo>
33433343-->
33443344
33453345<para>
33463346
3347- Unknown
3348- Sorry, we stopped keeping track of changes from 1.02 to 1.09. Some of
3347+ <note>
3348+ <title>Release date</title>
3349+ <simpara>1996-11-04</simpara>
3350+ </note>
3351+
3352+ Sorry, we didn't keep track of changes from 1.02 to 1.09. Some of
33493353the changes listed in 6.0 were actually included in the 1.02.1 to 1.09
33503354releases.
33513355</para>
@@ -3865,8 +3869,8 @@ Bug fixes:
38653869 * allow the use of \; inside the monitor
38663870 * the LISTEN/NOTIFY asynchronous notification mechanism now work
38673871 * NOTIFY in rule action bodies now work
3868- * hashindices work, and access methods in general should perform better.
3869- creation of large btreeindices should be much faster. (thanks to Paul
3872+ * hashindexes work, and access methods in general should perform better.
3873+ creation of large btreeindexes should be much faster. (thanks to Paul
38703874 Aoki)
38713875
38723876Other changes and enhancements:
@@ -3919,7 +3923,7 @@ New documentation:
39193923
39203924 <note>
39213925 <title>Release date</title>
3922- <simpara>1995-03 -25</simpara>
3926+ <simpara>1995-05 -25</simpara>
39233927 </note>
39243928
39253929<!--