11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.96 2001/06/01 00:24:21 momjian Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.97 2001/08/14 21:21:40 momjian Exp $
33-->
44
55 <appendix id="release">
66 <title>Release Notes</title>
77
8+ <sect1 id="release-7-1-3">
9+ <title>Release 7.1.3</title>
10+
11+ <note>
12+ <title>Release date</title>
13+ <simpara>2001-08-15</simpara>
14+ </note>
15+
16+ <!--
17+ <docinfo>
18+ <authorgroup>
19+ <author>
20+ <firstname>Bruce</firstname>
21+ <surname>Momjian</surname>
22+ </author>
23+ </authorgroup>
24+ </docinfo>
25+ -->
26+
27+ <sect2>
28+ <title>Migration to version 7.1.3</title>
29+
30+ <para>
31+ A dump/restore is <emphasis>not</emphasis> required for those running
32+ 7.1.X.
33+ </para>
34+ </sect2>
35+
36+ <sect2>
37+ <title>Changes</title>
38+
39+ <para>
40+ <programlisting>
41+ Remove unused WAL segements of large transactions (Tom)
42+ Multiaction rule fix (Tom)
43+ Pl/pgSQL memory allocation fix (Jan)
44+ VACUUM buffer fix (Tom)
45+ Regression test fixes (Tom)
46+ pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types (Tom)
47+ Fix subselects with DISTINCT ON or LIMIT (Tom)
48+ BEOS fix
49+ Disable COPY TO/FROM a view (Tom)
50+ Cygwin build (Jason Tishler)
51+ </programlisting>
52+ </para>
53+ </sect2>
54+ </sect1>
55+
56+
857 <sect1 id="release-7-1-2">
958 <title>Release 7.1.2</title>
1059
@@ -1196,7 +1245,7 @@ subselect+CASE fixes(Tom)
11961245Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren Sefcik)
11971246Fixes for CASE in WHERE join clauses(Tom)
11981247Fix BTScan abort(Tom)
1199- Repair the check for redundant UNIQUE and PRIMARY KEYindexes (Thomas)
1248+ Repair the check for redundant UNIQUE and PRIMARY KEYindices (Thomas)
12001249Improve it so that it checks for multi-column constraints(Thomas)
12011250Fix for Win32 making problem with MB enabled(Hiroki Kataoka)
12021251Allow BSD yacc and bison to compile pl code(Bruce)
@@ -1595,7 +1644,7 @@ Enhancements
15951644------------
15961645Add "vacuumdb" utility
15971646Speed up libpq by allocating memory better(Tom)
1598- EXPLAIN allindexes used(Tom)
1647+ EXPLAIN allindices used(Tom)
15991648Implement CASE, COALESCE, NULLIF expression(Thomas)
16001649New pg_dump table output format(Constantin)
16011650Add string min()/max() functions(Thomas)
@@ -2029,14 +2078,14 @@ Allow index use with OR clauses(Bruce)
20292078Allows "SELECT NULL ORDER BY 1;"
20302079Explain VERBOSE prints the plan, and now pretty-prints the plan to
20312080the postmaster log file(Bruce)
2032- Addindexes display to \d command(Bruce)
2081+ AddIndices display to \d command(Bruce)
20332082Allow GROUP BY on functions(David)
20342083New pg_class.relkind for large objects(Bruce)
20352084New way to send libpq NOTICE messages to a different location(Tom)
20362085New \w write command to psql(Bruce)
20372086New /contrib/findoidjoins scans oid columns to find join relationships(Bruce)
2038- Allow binary-compatibleindexes to be considered when checking for valid
2039- Indexes for restriction clauses containing a constant(Thomas)
2087+ Allow binary-compatibleindices to be considered when checking for valid
2088+ indices for restriction clauses containing a constant(Thomas)
20402089New ISBN/ISSN code in /contrib/isbn_issn
20412090Allow NOT LIKE, IN, NOT IN, BETWEEN, and NOT BETWEEN constraint(Thomas)
20422091New rewrite system fixes many problems with rules and views(Jan)
@@ -2502,7 +2551,7 @@ Real deadlock detection, no more timeouts(Bruce)
25022551Add SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,
25032552CURRENT_USER(Thomas)
25042553Modify constraint syntax to be SQL92-compliant(Thomas)
2505- Implement SQL92 PRIMARY KEY and UNIQUE clauses usingindexes (Thomas)
2554+ Implement SQL92 PRIMARY KEY and UNIQUE clauses usingindices (Thomas)
25062555Recognize SQL92 syntax for FOREIGN KEY. Throw elog notice(Thomas)
25072556Allow NOT NULL UNIQUE constraint clause (each allowed separately before)(Thomas)
25082557Allow Postgres-style casting ("::") of non-constants(Thomas)
@@ -2514,14 +2563,14 @@ Implement SQL92 binary and hexadecimal string decoding (b'10' and x'1F')(Thomas)
25142563Support SQL92 syntax for type coercion of literal strings
25152564(e.g. "DATETIME 'now'")(Thomas)
25162565Add conversions for int2, int4, and OID types to and from text(Thomas)
2517- Use shared lock when buildingindexes (Vadim)
2566+ Use shared lock when buildingindices (Vadim)
25182567Free memory allocated for an user query inside transaction block after
25192568this query is done, was turned off in <= 6.2.1(Vadim)
25202569New SQL statement CREATE PROCEDURAL LANGUAGE(Jan)
25212570New <productname>Postgres</productname> Procedural Language (PL) backend interface(Jan)
25222571Rename pg_dump -H option to -h(Bruce)
25232572Add Java support for passwords, European dates(Peter)
2524- Useindexes for LIKE and ~, !~ operations(Bruce)
2573+ Useindices for LIKE and ~, !~ operations(Bruce)
25252574Add hash functions for datetime and timespan(Thomas)
25262575Time Travel removed(Vadim, Bruce)
25272576Add paging for \d and \z, and fix \i(Bruce)
@@ -2539,7 +2588,7 @@ Regression tests time zone automatically set with "setenv PGTZ PST8PDT"(Thomas)
25392588Add pg_description table for info on tables, columns, operators, types, and
25402589aggregates(Bruce)
25412590Increase 16 char limit on system table/index names to 32 characters(Bruce)
2542- Rename systemindexes (Bruce)
2591+ Rename systemindices (Bruce)
25432592Add 'GERMAN' option to SET DATESTYLE(Thomas)
25442593Define an "ISO-style" timespan output format with "hh:mm:ss" fields(Thomas)
25452594Allow fractional values for delta times (e.g. '2.5 days')(Thomas)
@@ -3041,7 +3090,7 @@ fix join clauses for multiple tables(Vadim)
30413090fix hash, hashjoin for arrays(Vadim)
30423091fix btree for abstime type(Vadim)
30433092large object fixes(Raymond)
3044- fix buffer leak in hashindexes (Vadim)
3093+ fix buffer leak in hashindices (Vadim)
30453094fix rtree for use in inner scan (Vadim)
30463095fix gist for use in inner scan, cleanups (Vadim, Andrea)
30473096avoid unnecessary local buffers allocation (Vadim, Massimo)
@@ -3288,19 +3337,15 @@ Unused/uninialized variables corrected
32883337</author>
32893338</authorgroup>
32903339<date>
3291- 1996-11-04
3340+ Unknown
32923341</date>
32933342</docinfo>
32943343-->
32953344
32963345<para>
32973346
3298- <note>
3299- <title>Release date</title>
3300- <simpara>1996-11-04</simpara>
3301- </note>
3302-
3303- Sorry, we didn't keep track of changes from 1.02 to 1.09. Some of
3347+ Unknown
3348+ Sorry, we stopped keeping track of changes from 1.02 to 1.09. Some of
33043349the changes listed in 6.0 were actually included in the 1.02.1 to 1.09
33053350releases.
33063351</para>
@@ -3820,8 +3865,8 @@ Bug fixes:
38203865 * allow the use of \; inside the monitor
38213866 * the LISTEN/NOTIFY asynchronous notification mechanism now work
38223867 * NOTIFY in rule action bodies now work
3823- * hashindexes work, and access methods in general should perform better.
3824- creation of large btreeindexes should be much faster. (thanks to Paul
3868+ * hashindices work, and access methods in general should perform better.
3869+ creation of large btreeindices should be much faster. (thanks to Paul
38253870 Aoki)
38263871
38273872Other changes and enhancements:
@@ -3874,7 +3919,7 @@ New documentation:
38743919
38753920 <note>
38763921 <title>Release date</title>
3877- <simpara>1995-05 -25</simpara>
3922+ <simpara>1995-03 -25</simpara>
38783923 </note>
38793924
38803925<!--