From 6f2943b52e9f4af3c4488c0373a3490e38c032a7 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 14 Aug 2001 21:21:40 +0000 Subject: [PATCH] Add HISTORY for 7.1.3. Packaging done. --- HISTORY | 37 ++++++++++++++--- doc/src/sgml/release.sgml | 87 +++++++++++++++++++++++++++++---------- 2 files changed, 97 insertions(+), 27 deletions(-) diff --git a/HISTORY b/HISTORY index 30fce9b50d..ccd757d136 100644 --- a/HISTORY +++ b/HISTORY @@ -1,4 +1,30 @@ - ------------------------------------------------------------------------ + ------------------------------------------------------------------------ + Release 7.1.3 + ------------------------------------------------------------------------ + + +Release 7.1.3 (2001-08-15) + +Migration to v7.1.3 + +A dump/restore is not required for those running 7.1.X. + +Changes +------- +Remove unused WAL segements of large transactions (Tom) +Multiaction rule fix (Tom) +Pl/pgSQL memory allocation fix (Jan) +VACUUM buffer fix (Tom) +Regression test fixes (Tom) +pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types (Tom) +Fix subselects with DISTINCT ON or LIMIT (Tom) +BEOS fix +Disable COPY TO/FROM a view (Tom) +Cygwin build (Jason Tishler) + + + + ------------------------------------------------------------------------ Release 7.1.2 ------------------------------------------------------------------------ @@ -2348,11 +2374,10 @@ Unused/uninialized variables corrected ------------------------------------------------------------------------ -Release v1.09 (1996-11-04) +Release v1.09 -Sorry, we didn't keep track of changes from 1.02 to 1.09. Some of the -changes listed in 6.0 were actually included in the 1.02.1 to 1.09 -releases. +Sorry, we stopped keeping track of changes from 1.02 to 1.09. Some of the +changes listed in 6.0 were actually included in the 1.02.1 to 1.09 releases. @@ -2758,7 +2783,7 @@ New documentation: ------------------------------------------------------------------------ -Postgres95 Release 0.02 (1995-05-25) +Postgres95 Release 0.02 (1995-03-25) Detailed Change List diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index be14cece47..67ff41bbad 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,10 +1,59 @@ Release Notes + + Release 7.1.3 + + + Release date + 2001-08-15 + + + + + + Migration to version 7.1.3 + + + A dump/restore is not required for those running + 7.1.X. + + + + + Changes + + + +Remove unused WAL segements of large transactions (Tom) +Multiaction rule fix (Tom) +Pl/pgSQL memory allocation fix (Jan) +VACUUM buffer fix (Tom) +Regression test fixes (Tom) +pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types (Tom) +Fix subselects with DISTINCT ON or LIMIT (Tom) +BEOS fix +Disable COPY TO/FROM a view (Tom) +Cygwin build (Jason Tishler) + + + + + + Release 7.1.2 @@ -1196,7 +1245,7 @@ subselect+CASE fixes(Tom) Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren Sefcik) Fixes for CASE in WHERE join clauses(Tom) Fix BTScan abort(Tom) -Repair the check for redundant UNIQUE and PRIMARY KEY indexes(Thomas) +Repair the check for redundant UNIQUE and PRIMARY KEY indices(Thomas) Improve it so that it checks for multi-column constraints(Thomas) Fix for Win32 making problem with MB enabled(Hiroki Kataoka) Allow BSD yacc and bison to compile pl code(Bruce) @@ -1595,7 +1644,7 @@ Enhancements ------------ Add "vacuumdb" utility Speed up libpq by allocating memory better(Tom) -EXPLAIN all indexes used(Tom) +EXPLAIN all indices used(Tom) Implement CASE, COALESCE, NULLIF expression(Thomas) New pg_dump table output format(Constantin) Add string min()/max() functions(Thomas) @@ -2029,14 +2078,14 @@ Allow index use with OR clauses(Bruce) Allows "SELECT NULL ORDER BY 1;" Explain VERBOSE prints the plan, and now pretty-prints the plan to the postmaster log file(Bruce) -Add indexes display to \d command(Bruce) +Add Indices display to \d command(Bruce) Allow GROUP BY on functions(David) New pg_class.relkind for large objects(Bruce) New way to send libpq NOTICE messages to a different location(Tom) New \w write command to psql(Bruce) New /contrib/findoidjoins scans oid columns to find join relationships(Bruce) -Allow binary-compatible indexes to be considered when checking for valid -Indexes for restriction clauses containing a constant(Thomas) +Allow binary-compatible indices to be considered when checking for valid +indices for restriction clauses containing a constant(Thomas) New ISBN/ISSN code in /contrib/isbn_issn Allow NOT LIKE, IN, NOT IN, BETWEEN, and NOT BETWEEN constraint(Thomas) New rewrite system fixes many problems with rules and views(Jan) @@ -2502,7 +2551,7 @@ Real deadlock detection, no more timeouts(Bruce) Add SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER(Thomas) Modify constraint syntax to be SQL92-compliant(Thomas) -Implement SQL92 PRIMARY KEY and UNIQUE clauses using indexes(Thomas) +Implement SQL92 PRIMARY KEY and UNIQUE clauses using indices(Thomas) Recognize SQL92 syntax for FOREIGN KEY. Throw elog notice(Thomas) Allow NOT NULL UNIQUE constraint clause (each allowed separately before)(Thomas) Allow Postgres-style casting ("::") of non-constants(Thomas) @@ -2514,14 +2563,14 @@ Implement SQL92 binary and hexadecimal string decoding (b'10' and x'1F')(Thomas) Support SQL92 syntax for type coercion of literal strings (e.g. "DATETIME 'now'")(Thomas) Add conversions for int2, int4, and OID types to and from text(Thomas) -Use shared lock when building indexes(Vadim) +Use shared lock when building indices(Vadim) Free memory allocated for an user query inside transaction block after this query is done, was turned off in <= 6.2.1(Vadim) New SQL statement CREATE PROCEDURAL LANGUAGE(Jan) New Postgres Procedural Language (PL) backend interface(Jan) Rename pg_dump -H option to -h(Bruce) Add Java support for passwords, European dates(Peter) -Use indexes for LIKE and ~, !~ operations(Bruce) +Use indices for LIKE and ~, !~ operations(Bruce) Add hash functions for datetime and timespan(Thomas) Time Travel removed(Vadim, Bruce) Add paging for \d and \z, and fix \i(Bruce) @@ -2539,7 +2588,7 @@ Regression tests time zone automatically set with "setenv PGTZ PST8PDT"(Thomas) Add pg_description table for info on tables, columns, operators, types, and aggregates(Bruce) Increase 16 char limit on system table/index names to 32 characters(Bruce) -Rename system indexes(Bruce) +Rename system indices(Bruce) Add 'GERMAN' option to SET DATESTYLE(Thomas) Define an "ISO-style" timespan output format with "hh:mm:ss" fields(Thomas) Allow fractional values for delta times (e.g. '2.5 days')(Thomas) @@ -3041,7 +3090,7 @@ fix join clauses for multiple tables(Vadim) fix hash, hashjoin for arrays(Vadim) fix btree for abstime type(Vadim) large object fixes(Raymond) -fix buffer leak in hash indexes (Vadim) +fix buffer leak in hash indices (Vadim) fix rtree for use in inner scan (Vadim) fix gist for use in inner scan, cleanups (Vadim, Andrea) avoid unnecessary local buffers allocation (Vadim, Massimo) @@ -3288,19 +3337,15 @@ Unused/uninialized variables corrected -1996-11-04 +Unknown --> - - Release date - 1996-11-04 - - -Sorry, we didn't keep track of changes from 1.02 to 1.09. Some of +Unknown +Sorry, we stopped keeping track of changes from 1.02 to 1.09. Some of the changes listed in 6.0 were actually included in the 1.02.1 to 1.09 releases. @@ -3820,8 +3865,8 @@ Bug fixes: * allow the use of \; inside the monitor * the LISTEN/NOTIFY asynchronous notification mechanism now work * NOTIFY in rule action bodies now work - * hash indexes work, and access methods in general should perform better. - creation of large btree indexes should be much faster. (thanks to Paul + * hash indices work, and access methods in general should perform better. + creation of large btree indices should be much faster. (thanks to Paul Aoki) Other changes and enhancements: @@ -3874,7 +3919,7 @@ New documentation: Release date - 1995-05-25 + 1995-03-25