From 30099c28f01c47bfa385d7b964d411350dcda35a Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 11 Sep 2007 17:19:25 +0000 Subject: [PATCH] Stamp --- doc/src/sgml/release.sgml | 1147 ++++++++++++++++++++++--------------- 1 file changed, 670 insertions(+), 477 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index d50a61677e0..2fe8401b362 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,10 +1,117 @@ + Release Notes + + Release 8.0.14 + + + Release date + 2007-09-17 + + + + This release contains a variety of fixes from 8.0.13. + + + + Migration to version 8.0.14 + + + A dump/restore is not required for those running 8.0.X. However, + if you are upgrading from a version earlier than 8.0.6, see the release + notes for 8.0.6. + + + + + + Changes + + + + + + Fix excessively SSL log error messages (Tom) + + + + + + Win32 socket improvements (Magnus) + + + + + + Fix syslog so log messages are never partially written (Tom, Andrew) + + + + + + Allow CREATE DOMAIN ... DEFAULT NULL (Tom) + + + + + + Require non-superusers who use /contrib/dblink to use only password + authentication, as a security measure (Joe) + + + + + + Suppress timezone name (%Z) in log timestamps on Win32 because of + possible improperly encoded names (Tom) + + + + + + Update the time zone database rules, particularly New Zealand's upcoming changes (Tom) + + + + + + + + Release 8.0.13 @@ -188,7 +295,7 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.321.4.36 2007/04/20 03:27:54 tg - + Release 8.0.10 @@ -271,11 +378,13 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.321.4.36 2007/04/20 03:27:54 tg to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for - new initdb installs (Tom) + new initdb + installs (Tom) - This is because lc_numeric can potentially + This is because lc_numeric can potentially change the output of these functions. @@ -305,7 +414,7 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.321.4.36 2007/04/20 03:27:54 tg - + Release 8.0.9 @@ -359,7 +468,7 @@ Wieland) - + Release 8.0.8 @@ -384,7 +493,7 @@ Wieland) Full security against the SQL-injection attacks described in - CVE-2006-2313 and CVE-2006-2314 may require changes in application + CVE-2006-2313 and CVE-2006-2314 might require changes in application code. If you have applications that embed untrustworthy strings into SQL commands, you should examine them as soon as possible to ensure that they are using recommended escaping techniques. In @@ -416,7 +525,7 @@ literals. By default, \' is rejected only when GB18030, or UHC), which is the scenario in which SQL injection is possible. A new configuration parameter backslash_quote is available to adjust this behavior when needed. Note that full security against -CVE-2006-2314 may require client-side changes; the purpose of +CVE-2006-2314 might require client-side changes; the purpose of backslash_quote is in part to make it obvious that insecure clients are insecure. @@ -471,7 +580,7 @@ Fuhr) - + Release 8.0.7 @@ -496,7 +605,7 @@ Fuhr) Changes - + Fix potential crash in SET @@ -533,7 +642,7 @@ constraints in the proper order (Nakano Yoshihisa) references to custom operators or operator classes (Tom) Allow pg_restore to continue properly after a -COPY failure; formerly it tried to treat the remaining +COPY failure; formerly it tried to treat the remaining COPY data as SQL commands (Stephen Frost) Fix pg_ctl unregister crash @@ -568,7 +677,7 @@ and isinf during configure (Tom) - + Release 8.0.6 @@ -596,7 +705,7 @@ and isinf during configure (Tom) Changes - + Fix Windows code so that postmaster will continue rather @@ -622,7 +731,7 @@ to ensure that plperl won't change the locale later This fixes a problem that occurred if the postmaster was started with environment variables specifying a different locale than what initdb had been told. Under these conditions, any use of -plperl was likely to lead to corrupt indexes. You may need +plperl was likely to lead to corrupt indexes. You might need REINDEX to fix existing indexes on textual columns if this has happened to you. @@ -651,7 +760,7 @@ what's actually returned by the query (Joe) - + Release 8.0.5 @@ -676,7 +785,7 @@ what's actually returned by the query (Joe) Changes - + Fix race condition in transaction log management @@ -731,7 +840,7 @@ to subquery results - + Release 8.0.4 @@ -826,7 +935,7 @@ code - + Release 8.0.3 @@ -873,7 +982,7 @@ code It is strongly recommended that all installations repair these errors, either by initdb or by following the manual repair procedure given below. The errors at least allow unprivileged database users to crash - their server process, and may allow unprivileged users to gain the + their server process, and might allow unprivileged users to gain the privileges of a database superuser. @@ -973,12 +1082,12 @@ data types Changes -Increment the major version number of all interface +Increment the major version number of all interface libraries (Bruce) - This should have been done in 8.0.0. It is required so 7.4.X versions + This should have been done in 8.0.0. It is required so 7.4.X versions of PostgreSQL client applications, like psql, - can be used on the same machine as 8.0.X applications. This might require + can be used on the same machine as 8.0.X applications. This might require re-linking user applications that use these libraries. Add Windows-only wal_sync_method setting of @@ -992,21 +1101,21 @@ data types Enable the wal_sync_method setting of - Because the default is no longer -New cache management algorithm 2Q replaces +New cache management algorithm 2Q replaces ARC (Tom) - This was done to avoid a pending US patent on ARC. The - 2Q code might be a few percentage points slower than + This was done to avoid a pending US patent on ARC. The + 2Q code might be a few percentage points slower than ARC for some work loads. A better cache management algorithm will appear in 8.1. @@ -1030,9 +1139,9 @@ in plpython function bodies (Michael Fuhr) Allow SPI cursors to handle utility commands that return rows, such as EXPLAIN (Tom) -Fix CLUSTER failure after ALTER TABLE +Fix CLUSTER failure after ALTER TABLE SET WITHOUT OIDS (Tom) -Reduce memory usage of ALTER TABLE ADD COLUMN +Reduce memory usage of ALTER TABLE ADD COLUMN (Neil) Fix ALTER LANGUAGE RENAME (Tom) Document the Windows-only register and @@ -1052,7 +1161,7 @@ statistics collector Windows event logger rather than standard error. Make Kerberos authentication work on Windows (Magnus) -Allow ALTER DATABASE RENAME by superusers +Allow ALTER DATABASE RENAME by superusers who aren't flagged as having CREATEDB privilege (Tom) Modify WAL log entries for CREATE and DROP DATABASE to not specify absolute paths (Tom) @@ -1060,22 +1169,22 @@ statistics collector different database location. Note that CREATE TABLESPACE still poses a hazard in such situations. -Fix crash from a backend exiting with an open transaction +Fix crash from a backend exiting with an open transaction that created a table and opened a cursor on it (Tom) -Fix array_map() so it can call PL functions +Fix array_map() so it can call PL functions (Tom) Several contrib/tsearch2 and contrib/btree_gist fixes (Teodor) -Fix crash of some contrib/pgcrypto +Fix crash of some contrib/pgcrypto functions on some platforms (Marko Kreen) -Fix contrib/intagg for 64-bit platforms +Fix contrib/intagg for 64-bit platforms (Tom) -Fix ecpg bugs in parsing of CREATE statement +Fix ecpg bugs in parsing of CREATE statement (Michael) -Work around gcc bug on powerpc and amd64 causing problems in +Work around gcc bug on powerpc and amd64 causing problems in ecpg (Christof Petig) -Do not use locale-aware versions of upper(), +Do not use locale-aware versions of upper(), lower(), and initcap() when the locale is C (Bruce) @@ -1083,9 +1192,9 @@ statistics collector for non-7-bit data when the locale is C. Fix quote_ident() to quote names that match keywords (Tom) -Fix to_date() to behave reasonably when +Fix to_date() to behave reasonably when CC and YY fields are both used (Karel) -Prevent to_char(interval) from failing +Prevent to_char(interval) from failing when given a zero-month interval (Tom) Fix wrong week returned by date_trunc('week') (Bruce) @@ -1174,10 +1283,10 @@ typedefs (Michael) Release date 2005-01-19 - + Overview - + Major changes in this release: @@ -1324,27 +1433,27 @@ typedefs (Michael) COPY can now read and write comma-separated-value files. It has the flexibility to - interpret non-standard quoting and separation characters too. + interpret nonstandard quoting and separation characters too. - + Migration to version 8.0 - + A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. - + Observe the following incompatibilities: - + @@ -1369,7 +1478,7 @@ typedefs (Michael) - Non-deferred Updating an element or slice of a NULL array value now produces - a non-NULL array result, namely an array containing + a nonnull array result, namely an array containing just the assigned-to positions. @@ -1494,7 +1603,7 @@ typedefs (Michael) - CIDR values now must have their non-masked bits be zero. + CIDR values now must have their nonmasked bits be zero. For example, we no longer allow 204.248.199.1/31 as a CIDR value. Such values should never have been accepted by @@ -1542,8 +1651,7 @@ typedefs (Michael) behavior across all platforms. In most cases, there should be little noticeable difference in time zone behavior, except that the time zone names used by SET/SHOW - TimeZone may - be different from what your platform provides. + TimeZone might be different from what your platform provides. @@ -1584,7 +1692,7 @@ typedefs (Michael) considered deprecated and will be removed in the next major release. - + @@ -1592,7 +1700,7 @@ typedefs (Michael) for intervals. - + The server now warns of empty strings passed to @@ -1602,7 +1710,7 @@ typedefs (Michael) invalid input for these data types. - + By default, tables in PostgreSQL 8.0 @@ -1619,19 +1727,19 @@ typedefs (Michael) - + Changes - + Below you will find a detailed account of the changes between release 8.0 and the previous major release. - + Performance Improvements - + Support cross-data-type index usage (Tom) @@ -1642,7 +1750,7 @@ typedefs (Michael) intuitive and consistent. - + New buffer replacement strategy that improves caching (Jan) @@ -1653,14 +1761,14 @@ typedefs (Michael) did not consider the number of times a specific cache entry was accessed, so large table scans could force out useful cache pages. The new cache algorithm uses four separate lists to track most - recently used and most frequently used cache pages and dynamically + recently used and most frequently used cache pages and dynamically optimize their replacement based on the work load. This should lead to much more efficient use of the shared buffer cache. Administrators who have tested shared buffer sizes in the past should retest with this new cache replacement policy. - + Add subprocess to write dirty buffers periodically to reduce @@ -1679,7 +1787,7 @@ typedefs (Michael) performance and minimize degradation during checkpoints. - + Add ability to prolong vacuum to reduce performance impact (Jan) @@ -1692,7 +1800,7 @@ typedefs (Michael) total duration of VACUUM. - + Improve B-tree index performance for duplicate keys (Dmitry Tkach, Tom) @@ -1702,7 +1810,7 @@ typedefs (Michael) values exist in the index. - + Use dynamically-generated table size estimates while planning (Tom) @@ -1719,7 +1827,7 @@ typedefs (Michael) changed significantly since the last housekeeping command. - + Improved index usage with OR clauses (Tom) @@ -1731,7 +1839,7 @@ typedefs (Michael) column is part of an OR clause. - + Improve matching of partial index clauses (Tom) @@ -1741,7 +1849,7 @@ typedefs (Michael) involving complex - - + + Server Changes - + Add WAL file archiving and point-in-time recovery (Simon Riggs) - + Add tablespaces so admins can control disk layout (Gavin) - + Add a built-in log rotation program (Andreas Pflug) @@ -1851,7 +1959,7 @@ typedefs (Michael) rotation program. - + Add new read-only server configuration parameters to show server @@ -1860,7 +1968,7 @@ typedefs (Michael) max_identifier_length, max_index_keys (Joe) - + Make quoting of sameuser, samegroup, and @@ -1868,20 +1976,20 @@ typedefs (Michael) pg_hba.conf (Andrew) - + Use clearer IPv6 name ::1/128 for localhost in default pg_hba.conf (Andrew) - + Use CIDR format in pg_hba.conf examples (Andrew) - + Rename server configuration parameters SortMem and @@ -1894,14 +2002,14 @@ typedefs (Michael) work_mem is for workspaces used during query execution. - + Allow logging of session disconnections using server configuration log_disconnections (Andrew) - + Add new server configuration parameter log_line_prefix to @@ -1912,7 +2020,7 @@ typedefs (Michael) address, and session start time. - + Remove server configuration parameters log_pid, @@ -1920,7 +2028,7 @@ typedefs (Michael) superseded by log_line_prefix (Andrew) - + Replace the virtual_host and tcpip_socket @@ -1933,7 +2041,7 @@ typedefs (Michael) to be specified. - + Listen on localhost by default, which eliminates the need for the @@ -1946,7 +2054,7 @@ typedefs (Michael) adjustments. - + Remove syslog server configuration parameter, and add more @@ -1954,7 +2062,7 @@ typedefs (Michael) location (Magnus) - + Change server configuration parameter log_statement to take @@ -1966,19 +2074,19 @@ typedefs (Michael) only data modification statements. - + Some logging-related configuration parameters could formerly be adjusted by ordinary users, but only in the more verbose direction. They are now treated more strictly: only superusers can set them. - However, a superuser may use ALTER USER to provide per-user + However, a superuser can use ALTER USER to provide per-user settings of these values for non-superusers. Also, it is now possible for superusers to set values of superuser-only configuration parameters via PGOPTIONS. - + Allow configuration files to be placed outside the data directory (mlw) @@ -1989,7 +2097,7 @@ typedefs (Michael) data directory, easing administration. - + Plan prepared queries only when first executed so constants can be @@ -2006,7 +2114,7 @@ typedefs (Michael) without incurring a performance penalty. - + Allow DECLARE CURSOR to take parameters @@ -2019,7 +2127,7 @@ typedefs (Michael) execution of the cursor's query. - + Fix hash joins and aggregates of inet and @@ -2032,28 +2140,28 @@ typedefs (Michael) data type.) - + Make log_duration print only when log_statement prints the query (Ed L.) - + - - + + Query Changes - + Add savepoints (nested transactions) (Alvaro) - + Unsupported isolation levels are now accepted and promoted to the @@ -2065,7 +2173,7 @@ typedefs (Michael) This change complies with that recommendation. - + Allow BEGIN WORK to specify transaction @@ -2073,17 +2181,17 @@ typedefs (Michael) (Bruce) - + Fix table permission checking for cases in which rules generate a query type different from the originally submitted query (Tom) - + - Implement dollar quoting to simplify single-quote usage (Andrew, Tom, + Implement dollar quoting to simplify single-quote usage (Andrew, Tom, David Fetter) @@ -2097,7 +2205,7 @@ typedefs (Michael) Dollar quoting can be used anywhere quoted text is needed. - + Make CASE val WHEN compval1 THEN ... evaluate val only once (Tom) @@ -2108,7 +2216,7 @@ typedefs (Michael) volatile. - + Test could fail with divide-by-zero. - + Replace max_expr_depth parameter with @@ -2128,12 +2236,12 @@ typedefs (Michael) size (Tom) - This gives us a fairly bulletproof defense against crashing due to + This gives us a fairly bulletproof defense against crashing due to runaway recursive functions. Instead of measuring the depth of expression nesting, we now directly measure the size of the execution stack. - + Allow arbitrary row expressions (Tom) @@ -2144,14 +2252,14 @@ typedefs (Michael) take rows as arguments and return row values. - + Allow - + Avoid locale-specific case conversion of basic ASCII letters in @@ -2163,7 +2271,7 @@ typedefs (Michael) outside the 7-bit-ASCII set is still locale-aware. - + Improve syntax error reporting (Fabien, Tom) @@ -2172,7 +2280,7 @@ typedefs (Michael) Syntax error reports are more useful than before. - + Change EXECUTE to return a completion tag @@ -2184,7 +2292,7 @@ typedefs (Michael) returned will reflect the command executed. - + Avoid emitting decompiler formerly produced this syntax. - + - - + + Object Manipulation Changes - + Add COMMENT ON for casts, conversions, languages, operator classes, and large objects (Christopher) - + Add new server configuration parameter default_with_oids to @@ -2223,14 +2331,14 @@ typedefs (Michael) will become FALSE in future releases.) - + Add - + Allow ALTER TABLE DROP COLUMN to drop an OID @@ -2238,13 +2346,13 @@ typedefs (Michael) (Tom) - + Allow composite types as table columns (Tom) - + Allow ALTER ... ADD COLUMN with defaults and @@ -2256,7 +2364,7 @@ typedefs (Michael) default value. - + Add ALTER COLUMN TYPE to change column's type (Rod) @@ -2266,7 +2374,7 @@ typedefs (Michael) and re-adding the column. - + Allow multiple ALTER actions in a single ALTER @@ -2280,7 +2388,7 @@ typedefs (Michael) only once. - + Allow ALTER TABLE to add SERIAL @@ -2291,7 +2399,7 @@ typedefs (Michael) columns. - + Allow changing the owners of aggregates, conversions, databases, @@ -2302,14 +2410,14 @@ typedefs (Michael) Previously this required modifying the system tables directly. - + Allow temporary object creation to be limited to - + Add specification except to modify the system tables. - + Constraint/Index/SERIAL names are now @@ -2332,7 +2440,7 @@ typedefs (Michael) within a schema. - + Add pg_get_serial_sequence() to return a @@ -2343,43 +2451,43 @@ typedefs (Michael) sequence name. - + Warn when primary/foreign key data type mismatch requires costly lookup - + New ALTER INDEX command to allow moving of indexes between tablespaces (Gavin) - + Make ALTER TABLE OWNER change dependent sequence ownership too (Alvaro) - - + + - - + + Utility Command Changes - + Allow CREATE SCHEMA to create triggers, indexes, and sequences (Neil) - + Add - - + + Data Type and Function Changes - + More complete support for composite types (row types) (Tom) @@ -2530,23 +2638,23 @@ typedefs (Michael) worked before. - + - Reject non-rectangular array values as erroneous (Joe) + Reject nonrectangular array values as erroneous (Joe) Formerly, array_in would silently build a surprising result. - + Overflow in integer arithmetic operations is now detected (Tom) - + The arithmetic operators associated with the single-byte @@ -2560,7 +2668,7 @@ typedefs (Michael) integer explicitly. - + Syntax checking of array input values considerably tightened up (Joe) @@ -2571,7 +2679,7 @@ typedefs (Michael) after the closing right brace. - + Empty-string array element values must now be written as @@ -2584,7 +2692,7 @@ typedefs (Michael) element value in some future release. - + Array element trailing whitespace is now ignored (Joe) @@ -2595,27 +2703,27 @@ typedefs (Michael) significant. Now trailing whitespace is also ignored. - + Emit array values with explicit array bounds when lower bound is not one (Joe) - + Accept YYYY-monthname-DD as a date string (Tom) - + Make netmask and hostmask functions return maximum-length mask length (Tom) - + Change factorial function to return numeric (Gavin) @@ -2625,14 +2733,14 @@ typedefs (Michael) work for a wider range of input values. - + to_char/to_date() date conversion improvements (Kurt Roeckx, Fabien Coelho) - + Make length() disregard trailing spaces in @@ -2644,7 +2752,7 @@ typedefs (Michael) should not be counted by length(). - + Warn about empty string being passed to @@ -2654,7 +2762,7 @@ typedefs (Michael) 8.1 will throw an error instead. - + Allow leading or trailing whitespace in @@ -2663,7 +2771,7 @@ typedefs (Michael) (Neil) - + Better support for IEEE Infinity and NaN @@ -2674,27 +2782,27 @@ typedefs (Michael) floating point arithmetic. - + Add - + Fix to_char for 1 BC (previously it returned 1 AD) (Bruce) - + Fix date_part(year) for BC dates (previously it returned one less than the correct year) (Bruce) - + Fix date_part() to return the proper millennium and @@ -2706,7 +2814,7 @@ typedefs (Michael) reckoning of such things. - + Add ceiling() as an alias for ceil(), @@ -2714,7 +2822,7 @@ typedefs (Michael) standards compliance (Neil) - + Change ln(), log(), @@ -2723,53 +2831,53 @@ typedefs (Michael) specified by SQL:2003 (Neil) - + Add width_bucket() function as defined by SQL:2003 (Neil) - + Add generate_series() functions to simplify working with numeric sets (Joe) - + Fix upper/lower/initcap() functions to work with multibyte encodings (Tom) - + Add boolean and bitwise integer - + New session information functions to return network addresses for client and server (Sean Chittenden) - + Add function to determine the area of a closed path (Sean Chittenden) - + Add function to send cancel request to other backends (Magnus) - + Add interval plus datetime operators (Tom) @@ -2779,7 +2887,7 @@ typedefs (Michael) was already supported, but both are required by the SQL standard. - + Casting an integer to BIT(N) selects the rightmost N bits @@ -2792,22 +2900,22 @@ typedefs (Michael) to int. - + - Require CIDR values to have all non-masked bits be zero + Require CIDR values to have all nonmasked bits be zero (Kevin Brintnall) - + - - + + Server-Side Language Changes - + In READ COMMITTED serialization mode, volatile functions @@ -2816,7 +2924,7 @@ typedefs (Michael) beginning of the interactive command that called the function. - + Functions declared STABLE or IMMUTABLE always @@ -2829,23 +2937,23 @@ typedefs (Michael) rather than VOLATILE. - + - Non-deferred - + - Allow function parameters to be declared with names (Dennis Bjorklund) + Allow function parameters to be declared with names (Dennis Björklund) This allows better documentation of functions. Whether the names @@ -2853,16 +2961,16 @@ typedefs (Michael) being used. - + - Allow PL/pgSQL parameter names to be referenced in the function (Dennis Bjorklund) + Allow PL/pgSQL parameter names to be referenced in the function (Dennis Björklund) This basically creates an automatic alias for each named parameter. - + Do minimal syntax checking of PL/pgSQL functions at creation time (Tom) @@ -2871,7 +2979,7 @@ typedefs (Michael) This allows us to catch simple syntax errors sooner. - + More support for composite types (row and record variables) in PL/pgSQL @@ -2881,14 +2989,14 @@ typedefs (Michael) as a single variable. - + Default values for PL/pgSQL variables can now reference previously declared variables - + Improve parsing of PL/pgSQL FOR loops (Tom) @@ -2900,13 +3008,13 @@ typedefs (Michael) messages when a mistake is made. - + Major overhaul of PL/Perl server-side language (Command Prompt, Andrew Dunstan) - + In PL/Tcl, SPI commands are now run in subtransactions. If an error @@ -2915,7 +3023,7 @@ typedefs (Michael) Formerly, it was not possible to catch such errors. - + Accept ELSEIF in PL/pgSQL (Neil) @@ -2925,63 +3033,63 @@ typedefs (Michael) are accustomed to spelling this keyword ELSEIF. - + - - + + <application>psql</> Changes - + Improve psql information display about database objects (Christopher) - + Allow psql to display group membership in \du and \dg (Markus Bertheau) - + Prevent psql \dn from showing temporary schemas (Bruce) - + Allow psql to handle tilde user expansion for file names (Zach Irmen) - + Allow psql to display fancy prompts, including color, via readline (Reece Hart, Chet Ramey) - + Make psql \copy match COPY command syntax fully (Tom) - + Show the location of syntax errors (Fabien Coelho, Tom) - + Add CLUSTER information to psql @@ -2989,14 +3097,14 @@ typedefs (Michael) (Bruce) - + Change psql \copy stdin/stdout to read from command input/output (Bruce) - + Add Feit) - + Add global psql configuration file, psqlrc.sample @@ -3015,48 +3123,48 @@ typedefs (Michael) be stored. - + Have psql \d+ indicate if the table has an OID column (Neil) - + On Windows, use binary mode in psql when reading files so control-Z is not seen as end-of-file - + Have \dn+ show permissions and description for schemas (Dennis - Bjorklund) + Björklund) - + Improve tab completion support (Stefan Kaltenbrunn, Greg Sabino Mullane) - + Allow boolean settings to be set using upper or lower case (Michael Paesold) - + - - + + <application>pg_dump</> Changes - + Use dependency information to improve the reliability of @@ -3067,7 +3175,7 @@ typedefs (Michael) sometimes being dumped in the wrong order. - + Have pg_dump output objects in alphabetical order if possible (Tom) @@ -3077,7 +3185,7 @@ typedefs (Michael) dump files. - + Allow pg_restore to ignore some SQL errors (Fabien Coelho) @@ -3090,20 +3198,20 @@ typedefs (Michael) option to give the old behavior of exiting on an error. - + pg_restore - + New begin/end markers in pg_dump text output (Bruce) - + Add start/stop times for @@ -3111,14 +3219,14 @@ typedefs (Michael) (Bruce) - + Allow most pg_dump options in pg_dumpall (Christopher) - + Have pg_dump use ALTER OWNER rather @@ -3126,35 +3234,35 @@ typedefs (Michael) (Christopher) - + - - + + libpq Changes - + Make libpq's - + Add PQmbdsplen() which returns the display length of a character (Tatsuo) - + Add thread locking to SSL and Kerberos connections (Manfred Spraul) - + Allow PQoidValue(), PQcmdTuples(), and @@ -3162,14 +3270,14 @@ typedefs (Michael) commands (Neil) - + Add PQserverVersion() to provide more convenient access to the server version number (Greg Sabino Mullane) - + Add PQprepare/PQsendPrepared() functions to support @@ -3177,33 +3285,33 @@ typedefs (Michael) of their parameters (Abhijit Menon-Sen) - + Many ECPG improvements, including SET DESCRIPTOR (Michael) - + - - + + Source Code Changes - + Allow the database server to run natively on Windows (Claudio, Magnus, Andrew) - + Shell script commands converted to C versions for Windows support (Andrew) - + Create an extension makefile framework (Fabien Coelho, Peter) @@ -3213,7 +3321,7 @@ typedefs (Michael) source tree. - + Support relocatable installations (Bruce) @@ -3226,26 +3334,26 @@ typedefs (Michael) rebuilding. - + Use - + Add - + Upgrade to DocBook V4.2 SGML (Peter) - + New PostgreSQL CVS tag (Marc) @@ -3258,131 +3366,131 @@ typedefs (Michael) repository. - + Clarify locking code (Manfred Koizar) - + Buffer manager cleanup (Neil) - + Decouple platform tests from CPU spinlock code (Bruce, Tom) - + Add inlined test-and-set code on PA-RISC for gcc (ViSolve, Tom) - + Improve i386 spinlock code (Manfred Spraul) - + Clean up spinlock assembly code to avoid warnings from newer gcc releases (Tom) - + Remove JDBC from source tree; now a separate project - + Remove the libpgtcl client interface; now a separate project - + More accurately estimate memory and file descriptor usage (Tom) - + Improvements to the Mac OS X startup scripts (Ray A.) - + New fsync() test program (Bruce) - + Major documentation improvements (Neil, Peter) - + Remove pg_encoding; not needed anymore - + Remove pg_id; not needed anymore - + Remove initlocation; not needed anymore - + Auto-detect thread flags (no more manual testing) (Bruce) - + Use Olson's public domain timezone library (Magnus) - + - With threading enabled, use thread flags on Unixware for + With threading enabled, use thread flags on Unixware for backend executables too (Bruce) - Unixware cannot mix threaded and non-threaded object files in the + Unixware cannot mix threaded and nonthreaded object files in the same executable, so everything must be compiled as threaded. - + psql now uses a flex-generated lexical analyzer to process command strings - + Reimplement the linked list data structure used throughout the @@ -3393,126 +3501,178 @@ typedefs (Michael) operations to be more efficient. - + Allow dynamically loaded modules to create their own server configuration parameters (Thomas Hallgren) - + New Brazilian version of FAQ (Euler Taveira de Oliveira) - + Add French FAQ (Guillaume Lelarge) - + New pgevent for Windows logging - + Make libpq and ECPG build as proper shared libraries on OS X (Tom) - + - - + + Contrib Changes - + Overhaul of contrib/dblink (Joe) - + contrib/dbmirror improvements (Steven Singer) - + New contrib/xml2 (John Gray, Torchbox) - + Updated contrib/mysql - + New version of contrib/btree_gist (Teodor) - + New contrib/trgm, trigram matching for PostgreSQL (Teodor) - + Many contrib/tsearch2 improvements (Teodor) - + Add double metaphone to contrib/fuzzystrmatch (Andrew) - + Allow contrib/pg_autovacuum to run as a Windows service (Dave Page) - + Add functions to contrib/dbsize (Andreas Pflug) - + Removed contrib/pg_logger: obsoleted by integrated logging subprocess - + Removed contrib/rserv: obsoleted by various separate projects - + - + + + Release 7.4.18 + + + Release date + 2007-09-17 + + + + This release contains fixes from 7.4.17. + + + + Migration to version 7.4.18 + + + A dump/restore is not required for those running 7.4.X. However, + if you are upgrading from a version earlier than 7.4.11, see the release + notes for 7.4.11. + + + + + + Changes + + + + + + Fix excessively SSL log error messages (Tom) + + + + + + Allow CREATE DOMAIN ... DEFAULT NULL (Tom) + + + + + + Require non-superusers who use /contrib/dblink to use only password + authentication, as a security measure (Joe) + + + + + + + + Release 7.4.17 @@ -3714,11 +3874,13 @@ typedefs (Michael) to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for - new initdb installs (Tom) + new initdb + installs (Tom) - This is because lc_numeric can potentially + This is because lc_numeric can potentially change the output of these functions. @@ -3737,7 +3899,7 @@ typedefs (Michael) - + Release 7.4.14 @@ -3782,7 +3944,7 @@ ANYARRAY - + Release 7.4.13 @@ -3807,7 +3969,7 @@ ANYARRAY Full security against the SQL-injection attacks described in - CVE-2006-2313 and CVE-2006-2314 may require changes in application + CVE-2006-2313 and CVE-2006-2314 might require changes in application code. If you have applications that embed untrustworthy strings into SQL commands, you should examine them as soon as possible to ensure that they are using recommended escaping techniques. In @@ -3839,7 +4001,7 @@ literals. By default, \' is rejected only when GB18030, or UHC), which is the scenario in which SQL injection is possible. A new configuration parameter backslash_quote is available to adjust this behavior when needed. Note that full security against -CVE-2006-2314 may require client-side changes; the purpose of +CVE-2006-2314 might require client-side changes; the purpose of backslash_quote is in part to make it obvious that insecure clients are insecure. @@ -3887,7 +4049,7 @@ Fuhr) - + Release 7.4.12 @@ -3912,7 +4074,7 @@ Fuhr) Changes - + Fix potential crash in SET @@ -3948,7 +4110,7 @@ and isinf during configure (Tom) - + Release 7.4.11 @@ -3976,7 +4138,7 @@ and isinf during configure (Tom) Changes - + Fix for protocol-level Describe messages issued @@ -3992,7 +4154,7 @@ to ensure that plperl won't change the locale later This fixes a problem that occurred if the postmaster was started with environment variables specifying a different locale than what initdb had been told. Under these conditions, any use of -plperl was likely to lead to corrupt indexes. You may need +plperl was likely to lead to corrupt indexes. You might need REINDEX to fix existing indexes on textual columns if this has happened to you. @@ -4013,7 +4175,7 @@ what's actually returned by the query (Joe) - + Release 7.4.10 @@ -4038,7 +4200,7 @@ what's actually returned by the query (Joe) Changes - + Fix race condition in transaction log management @@ -4064,7 +4226,7 @@ table has been dropped - + Release 7.4.9 @@ -4131,7 +4293,7 @@ code - + Release 7.4.8 @@ -4178,7 +4340,7 @@ code It is strongly recommended that all installations repair these errors, either by initdb or by following the manual repair procedures given below. The errors at least allow unprivileged database users to crash - their server process, and may allow unprivileged users to gain the + their server process, and might allow unprivileged users to gain the privileges of a database superuser. @@ -4196,7 +4358,7 @@ WHERE pronamespace = 11 AND pronargs = 5 COMMIT; - Next, if you have installed contrib/tsearch2, do + Next, if you have installed contrib/tsearch2, do: BEGIN; @@ -4225,12 +4387,12 @@ COMMIT; template databases then any subsequently created databases will contain the same errors. template1 can be fixed in the same way as any other database, but fixing template0 requires - additional steps. First, from any database issue + additional steps. First, from any database issue: UPDATE pg_database SET datallowconn = true WHERE datname = 'template0'; Next connect to template0 and perform the above repair - procedures. Finally, do + procedures. Finally, do: -- re-freeze template0: VACUUM FREEZE; @@ -4399,7 +4561,7 @@ GMT Repair possible failure to update hint bits on disk -Under rare circumstances this oversight could lead to +Under rare circumstances this oversight could lead to could not access transaction status failures, which qualifies it as a potential-data-loss bug. @@ -4559,7 +4721,7 @@ aggregate plan Fix error in COPY IN termination when using the old network protocol (ljb) Several important fixes in pg_autovacuum, including fixes for large tables, unsigned oids, stability, temp tables, and debug mode -(Matthew T. O'Connor) +(Matthew T. O'Connor) Fix problem with reading tar-format dumps on NetBSD and BSD/OS (Bruce) Several JDBC fixes Fix ALTER SEQUENCE RESTART where last_value equals the restart value (Tom) @@ -4602,7 +4764,7 @@ names from outer query levels. A dump/restore is not required for those running 7.4.X. However, - it may be advisable as the easiest method of incorporating fixes for + it might be advisable as the easiest method of incorporating fixes for two errors that have been found in the initial contents of 7.4.X system catalogs. A dump/initdb/reload sequence using 7.4.2's initdb will automatically correct these problems. @@ -4642,7 +4804,7 @@ VACUUM pg_statistic; UPDATE pg_type SET typalign = 'd' WHERE oid = 2277; -- this should update 6 rows: UPDATE pg_attribute SET attalign = 'd' WHERE atttypid = 2277; --- +-- -- At this point you MUST start a fresh backend to avoid a crash! -- -- repopulate pg_statistic: @@ -4668,12 +4830,12 @@ GRANT SELECT, UPDATE ON pg_settings TO PUBLIC; template databases then any subsequently created databases will contain the same errors. template1 can be fixed in the same way as any other database, but fixing template0 requires - additional steps. First, from any database issue + additional steps. First, from any database issue: UPDATE pg_database SET datallowconn = true WHERE datname = 'template0'; Next connect to template0 and perform the above repair - procedures. Finally, do + procedures. Finally, do: -- re-freeze template0: VACUUM FREEZE; @@ -4713,7 +4875,7 @@ inconveniences associated with the i/I problem. Other minor pg_dump fixes Allow ecpg to again use C keywords as column names (Michael) Added ecpg WHENEVER NOT_FOUND to -SELECT/INSERT/UPDATE/DELETE (Michael) +SELECT/INSERT/UPDATE/DELETE (Michael) Fix ecpg crash for queries calling set-returning functions (Michael) Various other ecpg fixes (Michael) Fixes for Borland compiler @@ -5120,13 +5282,13 @@ DROP SCHEMA information_schema CASCADE; Migration to version 7.4 - + A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. - + Observe the following incompatibilities: @@ -5156,7 +5318,7 @@ DROP SCHEMA information_schema CASCADE; Inner joins using the explicit JOIN syntax - may behave differently because they are now better + might behave differently because they are now better optimized. @@ -6123,7 +6285,7 @@ DROP SCHEMA information_schema CASCADE; - Arrays may now be specified as ARRAY[1,2,3], + Arrays can now be specified as ARRAY[1,2,3], ARRAY[['a','b'],['c','d']], or ARRAY[ARRAY[ARRAY[2]]] (Joe) @@ -6449,7 +6611,7 @@ DROP SCHEMA information_schema CASCADE; - Have pg_dumpall use GRANT/REVOKE to dump database-level privleges (Tom) + Have pg_dumpall use GRANT/REVOKE to dump database-level privileges (Tom) @@ -6697,6 +6859,52 @@ DROP SCHEMA information_schema CASCADE; + + Release 7.3.20 + + + Release date + 2007-09-17 + + + + This release contains fixes from 7.3.19. + + + + Migration to version 7.3.20 + + + A dump/restore is not required for those running 7.3.X. However, + if you are upgrading from a version earlier than 7.3.13, see the release + notes for 7.3.13. + + + + + + Changes + + + + + + Allow CREATE DOMAIN ... DEFAULT NULL (Tom) + + + + + + Require non-superusers who use /contrib/dblink to use only password + authentication, as a security measure (Joe) + + + + + + + + Release 7.3.19 @@ -6847,11 +7055,13 @@ DROP SCHEMA information_schema CASCADE; to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for - new initdb installs (Tom) + new initdb + installs (Tom) - This is because lc_numeric can potentially + This is because lc_numeric can potentially change the output of these functions. @@ -6870,7 +7080,7 @@ DROP SCHEMA information_schema CASCADE; - + Release 7.3.16 @@ -6897,7 +7107,7 @@ DROP SCHEMA information_schema CASCADE; Changes - + Fix corner cases in pattern matching for psql's \d commands Fix index-corrupting bugs in /contrib/ltree @@ -6912,7 +7122,7 @@ DROP SCHEMA information_schema CASCADE; - + Release 7.3.15 @@ -6937,7 +7147,7 @@ DROP SCHEMA information_schema CASCADE; Full security against the SQL-injection attacks described in - CVE-2006-2313 and CVE-2006-2314 may require changes in application + CVE-2006-2313 and CVE-2006-2314 might require changes in application code. If you have applications that embed untrustworthy strings into SQL commands, you should examine them as soon as possible to ensure that they are using recommended escaping techniques. In @@ -6969,7 +7179,7 @@ literals. By default, \' is rejected only when GB18030, or UHC), which is the scenario in which SQL injection is possible. A new configuration parameter backslash_quote is available to adjust this behavior when needed. Note that full security against -CVE-2006-2314 may require client-side changes; the purpose of +CVE-2006-2314 might require client-side changes; the purpose of backslash_quote is in part to make it obvious that insecure clients are insecure. @@ -7004,7 +7214,7 @@ Fuhr) - + Release 7.3.14 @@ -7029,7 +7239,7 @@ Fuhr) Changes - + Fix potential crash in SET @@ -7061,7 +7271,7 @@ and isinf during configure (Tom) - + Release 7.3.13 @@ -7089,7 +7299,7 @@ and isinf during configure (Tom) Changes - + Fix character string comparison for locales that consider @@ -7102,7 +7312,7 @@ to ensure that plperl won't change the locale later This fixes a problem that occurred if the postmaster was started with environment variables specifying a different locale than what initdb had been told. Under these conditions, any use of -plperl was likely to lead to corrupt indexes. You may need +plperl was likely to lead to corrupt indexes. You might need REINDEX to fix existing indexes on textual columns if this has happened to you. @@ -7123,7 +7333,7 @@ what's actually returned by the query (Joe) - + Release 7.3.12 @@ -7148,7 +7358,7 @@ what's actually returned by the query (Joe) Changes - + Fix race condition in transaction log management @@ -7170,7 +7380,7 @@ table has been dropped - + Release 7.3.11 @@ -7257,7 +7467,7 @@ the variable is of pass-by-reference type It is strongly recommended that all installations repair this error, either by initdb or by following the manual repair procedure given below. The error at least allows unprivileged database users to crash - their server process, and may allow unprivileged users to gain the + their server process, and might allow unprivileged users to gain the privileges of a database superuser. @@ -7283,12 +7493,12 @@ COMMIT; template databases then any subsequently created databases will contain the same error. template1 can be fixed in the same way as any other database, but fixing template0 requires - additional steps. First, from any database issue + additional steps. First, from any database issue: UPDATE pg_database SET datallowconn = true WHERE datname = 'template0'; Next connect to template0 and perform the above repair - procedure. Finally, do + procedure. Finally, do: -- re-freeze template0: VACUUM FREEZE; @@ -7431,7 +7641,7 @@ datestyles Repair possible failure to update hint bits on disk -Under rare circumstances this oversight could lead to +Under rare circumstances this oversight could lead to could not access transaction status failures, which qualifies it as a potential-data-loss bug. @@ -7541,7 +7751,7 @@ On some platforms, building with -fstrict-aliasing causes bugs. Make pg_restore handle 64-bit off_t correctly -This bug prevented proper restoration from archive files exceeding 4Gb. +This bug prevented proper restoration from archive files exceeding 4 GB. Make contrib/dblink not assume that local and remote type OIDs match (Joe) @@ -7841,7 +8051,7 @@ operations on bytea columns (Joe) A dump/restore is not required for those running version 7.3. However, it should be noted that the main PostgreSQL interface library, libpq, - has a new major version number for this release, which may require + has a new major version number for this release, which might require recompilation of client code in certain cases. @@ -7869,8 +8079,8 @@ operations on bytea columns (Joe) - - + + Release 7.3 @@ -8077,7 +8287,7 @@ operations on bytea columns (Joe) COPY no longer considers missing trailing columns to be null. All columns need to be specified. - (However, one may achieve a similar effect by specifying a + (However, one can achieve a similar effect by specifying a column list in the COPY command.) @@ -8633,7 +8843,7 @@ datestyles Repair possible failure to update hint bits on disk -Under rare circumstances this oversight could lead to +Under rare circumstances this oversight could lead to could not access transaction status failures, which qualifies it as a potential-data-loss bug. @@ -8774,8 +8984,8 @@ since PostgreSQL 7.1. - - + + Release 7.2.2 @@ -8817,8 +9027,8 @@ since PostgreSQL 7.1. - - + + Release 7.2.1 @@ -8978,7 +9188,7 @@ since PostgreSQL 7.1. The semantics of the VACUUM command have - changed in this release. You may wish to update your + changed in this release. You might wish to update your maintenance procedures accordingly. @@ -9018,7 +9228,7 @@ since PostgreSQL 7.1. The timestamp(), time(), and interval() functions are no longer - available. Instead of timestamp(), use + available. Instead of timestamp(), use timestamp 'string' or CAST. @@ -9443,7 +9653,7 @@ since PostgreSQL 7.1. -Remove unused WAL segements of large transactions (Tom) +Remove unused WAL segments of large transactions (Tom) Multiaction rule fix (Tom) PL/pgSQL memory allocation fix (Jan) VACUUM buffer fix (Tom) @@ -9490,7 +9700,7 @@ Fix PL/pgSQL SELECTs when returning no rows Fix for psql backslash core dump Referential integrity privilege fix Optimizer fixes -pg_dump cleanups +pg_dump cleanups @@ -9573,7 +9783,7 @@ previous releases of PostgreSQL have forced all data modifications to disk before each transaction commit. With WAL, only one log file must be flushed to disk, greatly improving performance. If you have been using -F in previous releases to -disable disk flushes, you may want to consider discontinuing its use. +disable disk flushes, you might want to consider discontinuing its use. @@ -9614,7 +9824,7 @@ outer join syntax. The previous C function manager did not handle null values properly, nor did it support 64-bit CPU's (Alpha). The new function manager does. You can continue using your old custom -functions, but you may want to rewrite them in the future to use the new +functions, but you might want to rewrite them in the future to use the new function manager call interface. @@ -9629,7 +9839,7 @@ function manager call interface. A large number of complex queries that were unsupported in previous releases now work. Many combinations of views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited tables -now work properly. Inherited tables are now accessed by default. +now work properly. Inherited tables are now accessed by default. Subqueries in FROM are now supported. @@ -9659,7 +9869,7 @@ Kerberos V fixes (David Wragg) Fix for INSERT INTO...SELECT where targetlist has subqueries (Tom) Prompt username/password on standard error (Bruce) Large objects inv_read/inv_write fixes (Tom) -Fixes for to_char(), to_date(), to_ascii(), and to_timestamp() (Karel, +Fixes for to_char(), to_date(), to_ascii(), and to_timestamp() (Karel, Daniel Baldoni) Prevent query expressions from leaking memory (Tom) Allow UPDATE of arrays elements (Tom) @@ -9675,7 +9885,7 @@ Disallow DROP RULE, CREATE INDEX, TRUNCATE on views (Mark Hollomon) Allow PL/pgSQL accept non-ASCII identifiers (Tatsuo) Allow views to proper handle GROUP BY, aggregates, DISTINCT (Tom) Fix rare failure with TRUNCATE command (Tom) -Allow UNION/INTERSECT/EXCEPT to be used with ALL, subqueries, views, +Allow UNION/INTERSECT/EXCEPT to be used with ALL, subqueries, views, DISTINCT, ORDER BY, SELECT...INTO (Tom) Fix parser failures during aborted transactions (Tom) Allow temporary relations to properly clean up indexes (Bruce) @@ -9711,14 +9921,14 @@ Improve ps status display for more platforms (Peter E, Marc) Improve CREATE FUNCTION failure message (Ross) JDBC improvements (Peter, Travis Bauer, Christopher Cain, William Webber, Gunnar) -Grand Unified Configuration scheme/GUC. Many options can now be set in +Grand Unified Configuration scheme/GUC. Many options can now be set in data/postgresql.conf, postmaster/postgres flags, or SET commands (Peter E) Improved handling of file descriptor cache (Tom) New warning code about auto-created table alias entries (Bruce) Overhaul initdb process (Tom, Peter E) Overhaul of inherited tables; inherited tables now accessed by default; new ONLY key word prevents it (Chris Bitmead, Tom) -ODBC cleanups/improvements (Nick Gorham, Stephan Szabo, Zoltan Kovacs, +ODBC cleanups/improvements (Nick Gorham, Stephan Szabo, Zoltan Kovacs, Michael Fork) Allow renaming of temp tables (Tom) Overhaul memory manager contexts (Tom) @@ -9789,7 +9999,7 @@ New CIDR abbrev() function (Tom) Performance ----------- -Write-Ahead Log (WAL) to provide crash recovery with less performance +Write-Ahead Log (WAL) to provide crash recovery with less performance overhead (Vadim) ANALYZE stage of VACUUM no longer exclusively locks table (Bruce) Reduced file seeks (Denis Perchine) @@ -9880,7 +10090,7 @@ Fix for psql \l+ when multibyte enabled (Tatsuo) Allow PL/pgSQL to accept non ascii identifiers (Tatsuo) Make vacuum always flush buffers (Tom) Fix to allow cancel while waiting for a lock (Hiroshi) -Fix for memory aloocation problem in user authentication code (Tom) +Fix for memory allocation problem in user authentication code (Tom) Remove bogus use of int4out() (Tom) Fixes for multiple subqueries in COALESCE or BETWEEN (Tom) Fix for failure of triggers on heap open in certain cases (Jeroen van @@ -10011,7 +10221,7 @@ ecpg changes (Michael) 2000-05-08 - + This release contains improvements in many areas, demonstrating the continued growth of PostgreSQL. There are more improvements and fixes in 7.0 than in any previous @@ -10087,7 +10297,7 @@ ecpg changes (Michael) A dump/restore using pg_dump is required for those wishing to migrate data from any previous release of PostgreSQL. - For those upgrading from 6.5.*, you may instead use + For those upgrading from 6.5.*, you can instead use pg_upgrade to upgrade to this release; however, a full dump/reload installation is always the most robust method for upgrades. @@ -10108,7 +10318,7 @@ ecpg changes (Michael) ease the transition by allowing PostgreSQL to recognize the deprecated type names and translate them to the new type - names, this mechanism may not be completely transparent to + names, this mechanism cannot be completely transparent to your existing application. @@ -10120,8 +10330,8 @@ ecpg changes (Michael) decreased query times as the optimizer makes a better choice for the preferred plan. However, in a small number of cases, usually involving pathological distributions of data, your - query times may go up. If you are dealing with large amounts - of data, you may want to check your queries to verify + query times might go up. If you are dealing with large amounts + of data, you might want to check your queries to verify performance. @@ -10264,8 +10474,8 @@ Force permissions on PGDATA directory to be secure, even if it exists (Tom) Added psql LASTOID variable to return last inserted oid (Peter E) Allow concurrent vacuum and remove pg_vlock vacuum lock file (Tom) Add privilege check for vacuum (Peter E) -New libpq functions to allow asynchronous connections: PQconnectStart(), - PQconnectPoll(), PQresetStart(), PQresetPoll(), PQsetenvStart(), +New libpq functions to allow asynchronous connections: PQconnectStart(), + PQconnectPoll(), PQresetStart(), PQresetPoll(), PQsetenvStart(), PQsetenvPoll(), PQsetenvAbort (Ewan Mellor) New libpq PQsetenv() function (Ewan Mellor) create/alter user extension (Peter E) @@ -10283,7 +10493,7 @@ Add CREATE/ALTER/DROP GROUP (Peter E) All administration scripts now support --long options (Peter E, Karel) Vacuumdb script now supports --all option (Peter E) ecpg new portable FETCH syntax -Add ecpg EXEC SQL IFDEF, EXEC SQL IFNDEF, EXEC SQL ELSE, EXEC SQL ELIF +Add ecpg EXEC SQL IFDEF, EXEC SQL IFNDEF, EXEC SQL ELSE, EXEC SQL ELIF and EXEC SQL ENDIF directives Add pg_ctl script to control backend start-up (Tatsuo) Add postmaster.opts.default file to store start-up flags (Tatsuo) @@ -10358,8 +10568,8 @@ Cleanups for int8 inputs, range checking, and type conversion (Tom) Fix for SELECT timespan('21:11:26'::time) (Tom) netmask('x.x.x.x/0') is 255.255.255.255 instead of 0.0.0.0 (Oleg Sharoiko) Add btree index on NUMERIC (Jan) -Perl fix for large objects containing NUL characters (Douglas Thomson) -ODBC fix for for large objects (free) +Perl fix for large objects containing NUL characters (Douglas Thomson) +ODBC fix for large objects (free) Fix indexing of cidr data type Fix for Ethernet MAC addresses (macaddr type) comparisons Fix for date/time types when overflows happened in computations (Tom) @@ -10599,13 +10809,13 @@ Fix for EXPLAIN on inheritance(Tom) Patch to allow vacuum on multisegment tables(Hiroshi) R-Tree optimizer selectivity fix(Tom) ACL file descriptor leak fix(Atsushi Ogawa) -New expresssion subtree code(Tom) +New expression subtree code(Tom) Avoid disk writes for read-only transactions(Vadim) Fix for removal of temp tables if last transaction was aborted(Bruce) Fix to prevent too large row from being created(Bruce) plpgsql fixes Allow port numbers 32k - 64k(Bruce) -Add ^ precidence(Bruce) +Add ^ precedence(Bruce) Rename sort files called pg_temp to pg_sorttemp(Bruce) Fix for microseconds in time values(Tom) Tutorial source cleanup @@ -10767,10 +10977,10 @@ Add Win1250 (Czech) support (Pavel Behal) The Administrator's Guide has a new chapter on troubleshooting from Tom Lane. And the Programmer's Guide has a - description of query processing, also from Stefan, and details + description of query processing, also from Stefan, and details on obtaining the PostgreSQL source tree via anonymous CVS and - CVSup. + CVSup. @@ -10792,7 +11002,7 @@ Add Win1250 (Czech) support (Pavel Behal) The new Multiversion Concurrency Control (MVCC) features can give somewhat different behaviors in multiuser - environments. Read and understand the following section + environments. Read and understand the following section to ensure that your existing applications will give you the behavior you need. @@ -10972,7 +11182,7 @@ JDBC fixes/features, see src/interfaces/jdbc/CHANGELOG(Peter) Make % operator have precedence like /(Bruce) Add new postgres -O option to allow system table structure changes(Bruce) Update contrib/pginterface/findoidjoins script(Tom) -Major speedup in vacuum of deleted rows with indexes(Vadim) +Major speedup in vacuum of deleted rows with indexes(Vadim) Allow non-SQL functions to run different versions based on arguments(Tom) Add -E option that shows actual queries sent by \dt and friends(Masaaki Sakaida) Add version number in start-up banners for psql(Masaaki Sakaida) @@ -10987,7 +11197,7 @@ New pg_options: pretty_plan, pretty_parse, pretty_rewritten(Jan) Better optimization statistics for system table access(Tom) Better handling of non-default block sizes(Massimo) Improve GEQO optimizer memory consumption(Tom) -UNION now suppports ORDER BY of columns not in target list(Jan) +UNION now supports ORDER BY of columns not in target list(Jan) Major libpq++ improvements(Vince Vielhaber) pg_dump now uses -z(ACL's) as default(Bruce) backend cache, memory speedups(Tom) @@ -11136,7 +11346,7 @@ Here is a brief, incomplete summary: -Views and rules are now functional thanks to extensive new code in the +Views and rules are now functional thanks to extensive new code in the rewrite rules system from Jan Wieck. He also wrote a chapter on it for the Programmer's Guide. @@ -11175,7 +11385,7 @@ which covers this topic. -Three new data types have been added. +Three new data types have been added. Two types, inet and cidr, support various forms of IP network, subnet, and machine addressing. There is now an 8-byte integer type available on some platforms. See the chapter on data types @@ -11207,7 +11417,7 @@ been. Migration to version 6.4 -A dump/restore using pg_dump +A dump/restore using pg_dump or pg_dumpall is required for those wishing to migrate data from any previous release of PostgreSQL. @@ -11277,7 +11487,7 @@ Readline cleanups(Tom) Allow psql \f \ to make spaces as delimiter(Bruce) Pass pg_attribute.atttypmod to the frontend for column field lengths(Tom,Bruce) Msql compatibility library in /contrib(Aldrin) -Remove the requirement that ORDER/GROUP BY clause identifiers be +Remove the requirement that ORDER/GROUP BY clause identifiers be included in the target list(David) Convert columns to match columns in UNION clauses(Thomas) Remove fork()/exec() and only do fork()(Bruce) @@ -11285,7 +11495,7 @@ Jdbc cleanups(Peter) Show backend status on ps command line(only works on some platforms)(Bruce) Pg_hba.conf now has a sameuser option in the database field Make lo_unlink take oid param, not int4 -New DISABLE_COMPLEX_MACRO for compilers that can't handle our macros(Bruce) +New DISABLE_COMPLEX_MACRO for compilers that cannot handle our macros(Bruce) Libpgtcl now handles NOTIFY as a Tcl event, need not send dummy queries(Tom) libpgtcl cleanups(Tom) Add -error option to libpgtcl's pg_result command(Tom) @@ -11361,7 +11571,7 @@ New UNLISTEN command(Massimo) psql and libpq now compile under Windows using win32.mak(Magnus) Lo_read no longer stores trailing NULL(Bruce) Identifiers are now truncated to 31 characters internally(Bruce) -Createuser options now availble on the command line +Createuser options now available on the command line Code for 64-bit integer supported added, configure tested, int8 type(Thomas) Prevent file descriptor leaf from failed COPY(Bruce) New pg_upgrade command(Bruce) @@ -11372,7 +11582,7 @@ New DECLARE and FETCH feature(Thomas) libpq's internal structures now not exported(Tom) Allow up to 8 key indexes(Bruce) Remove ARCHIVE key word, that is no longer used(Thomas) -pg_dump -n flag to supress quotes around indentifiers +pg_dump -n flag to suppress quotes around indentifiers disable system columns for views(Jan) new INET and CIDR types for network addresses(TomH, Paul) no more double quotes in psql output @@ -11401,7 +11611,7 @@ NS32K platform fixes(Phil Nelson, John Buller) SCO 7/UnixWare 2.x fixes(Billy,others) Sparc/Solaris 2.5 fixes(Ryan) Pgbuiltin.3 is obsolete, move to doc files(Thomas) -Even more documention(Thomas) +Even more documentation(Thomas) Nextstep support(Jacek) Aix support(David) pginterface manual page(Bruce) @@ -11448,7 +11658,7 @@ Correctly handles function calls on the left side of BETWEEN and LIKE clauses. -A dump/restore is NOT required for those running 6.3 or 6.3.1. A +A dump/restore is NOT required for those running 6.3 or 6.3.1. A make distclean, make, and make install is all that is required. This last step should be performed while the postmaster is not running. You should re-link any custom applications that use PostgreSQL libraries. @@ -11525,7 +11735,7 @@ Improvements to the configuration autodetection for installation. -A dump/restore is NOT required for those running 6.3. A +A dump/restore is NOT required for those running 6.3. A make distclean, make, and make install is all that is required. This last step should be performed while the postmaster is not running. You should re-link any custom applications that use PostgreSQL libraries. @@ -11602,7 +11812,7 @@ Better identify tcl and tk libs and includes(Bruce) Socket interface for client/server connection. This is the default now - so you may need to start postmaster with the + so you might need to start postmaster with the flag. @@ -11638,9 +11848,9 @@ Better identify tcl and tk libs and includes(Bruce) mention that without subselects, SQL is a very limited language. Subselects are a major feature, and you should review your code for places where subselects provide a better solution for your queries. I - think you will find that there are more uses for subselects than you may + think you will find that there are more uses for subselects than you might think. Vadim has put us on the big SQL map with subselects, and fully - functional ones too. The only thing you can't do with subselects is to + functional ones too. The only thing you cannot do with subselects is to use them in the target list. @@ -11653,7 +11863,7 @@ Better identify tcl and tk libs and includes(Bruce) Third, char() fields will now allow faster access than varchar() or text. Specifically, the text and varchar() have a penalty for access to any columns after the first column of this type. char() used to also - have this access penalty, but it no longer does. This may suggest that + have this access penalty, but it no longer does. This might suggest that you redesign some of your tables, especially if you have short character columns that you have defined as varchar() or text. This and other changes make 6.3 even faster than earlier releases. @@ -11671,7 +11881,7 @@ Better identify tcl and tk libs and includes(Bruce) User-created tables now no longer have SELECT privilege to PUBLIC by default. This was done because the ANSI standard requires it. You can - of course GRANT any privileges you want after the table is created. + of course GRANT any privileges you want after the table is created. System tables continue to be SELECT-able by PUBLIC. @@ -11703,7 +11913,7 @@ Better identify tcl and tk libs and includes(Bruce) Migration to version 6.3 - A dump/restore using pg_dump + A dump/restore using pg_dump or pg_dumpall is required for those wishing to migrate data from any previous release of PostgreSQL. @@ -11749,7 +11959,7 @@ Check boolean input literals for 'true','false','yes','no','1','0' and throw elog(ERROR) if unrecognized(Thomas) Major large objects fix Fix for GROUP BY showing duplicates(Vadim) -Fix for index scans in MergeJion(Vadim) +Fix for index scans in MergeJoin(Vadim) Enhancements ------------ @@ -11757,7 +11967,7 @@ Subselects with EXISTS, IN, ALL, ANY key words (Vadim, Bruce, Thomas) New User Manual(Thomas, others) Speedup by inlining some frequently-called functions Real deadlock detection, no more timeouts(Bruce) -Add SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, +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) @@ -11837,7 +12047,7 @@ Reduce system column overhead(Vadmin) Remove pg_time table(Vadim) Add pg_type attribute to identify types that need length (bpchar, varchar) Add report of offending line when COPY command fails -Allow VIEW privileges to be set separately from the underlying tables. +Allow VIEW privileges to be set separately from the underlying tables. For security, use GRANT/REVOKE on views as appropriate(Jan) Tables now have no default GRANT SELECT TO PUBLIC. You must explicitly grant such privileges. @@ -11914,8 +12124,8 @@ Include example trigger function for inserting user names on table updates. -This is a minor bug-fix release on 6.2. -For upgrades from pre-6.2 systems, a full dump/reload is required. +This is a minor bug-fix release on 6.2. +For upgrades from pre-6.2 systems, a full dump/reload is required. Refer to the 6.2 release notes for instructions. @@ -12017,14 +12227,14 @@ Catch non-functional delete attempts(Vadim) Change time function names to be more consistent(Michael Reifenberg) Check for zero divides(Michael Reifenberg) Fix very old bug which made rows changed/inserted by a command - visible to the command itself (so we had multiple update of + visible to the command itself (so we had multiple update of updated rows, etc.)(Vadim) Fix for SELECT null, 'fail' FROM pg_am (Patrick) SELECT NULL as EMPTY_FIELD now allowed(Patrick) Remove un-needed signal stuff from contrib/pginterface Fix OR (where x != 1 or x isnull didn't return rows with x NULL) (Vadim) Fix time_cmp function (Vadim) -Fix handling of functions with non-attribute first argument in +Fix handling of functions with non-attribute first argument in WHERE clauses (Vadim) Fix GROUP BY when order of entries is different from order in target list (Vadim) @@ -12038,7 +12248,7 @@ Added JDBC driver as an interface(Adrian & Peter) pg_password utility Return number of rows inserted/affected by INSERT/UPDATE/DELETE etc.(Vadim) Triggers implemented with CREATE TRIGGER (SQL3)(Vadim) -SPI (Server Programming Interface) allows execution of queries inside +SPI (Server Programming Interface) allows execution of queries inside C-functions (Vadim) NOT NULL implemented (SQL92)(Robson Paniago de Miranda) Include reserved words for string handling, outer joins, and unions(Thomas) @@ -12202,7 +12412,7 @@ optimizer which uses genetic The interpretation of array specifiers (the curly braces around atomic values) appears to have changed sometime after the original regression tests were generated. The current ./expected/*.out files reflect this - new interpretation, which may not be correct! + new interpretation, which might not be correct! @@ -12271,7 +12481,7 @@ Enhancements ------------ attribute optimization statistics(Bruce) much faster new btree bulk load code(Paul) -BTREE UNIQUE added to bulk load code(Vadim) +BTREE UNIQUE added to bulk load code(Vadim) new lock debug code(Massimo) massive changes to libpg++(Leo) new GEQO optimizer speeds table multitable optimization(Martin) @@ -12374,7 +12584,7 @@ because the COPY output format was improved from the 1.02 release. Bug Fixes --------- -ALTER TABLE bug - running postgress process needs to re-read table definition +ALTER TABLE bug - running postgres process needs to re-read table definition Allow vacuum to be run on one table or entire database(Bruce) Array fixes Fix array over-runs of memory writes(Kurt) @@ -12382,7 +12592,7 @@ Fix elusive btree range/non-range bug(Dan) Fix for hash indexes on some types like time and date Fix for pg_log size explosion Fix permissions on lo_export()(Bruce) -Fix unitialized reads of memory(Kurt) +Fix uninitialized reads of memory(Kurt) Fixed ALTER TABLE ... char(3) bug(Bruce) Fixed a few small memory leaks Fixed EXPLAIN handling of options and changed full_path option name @@ -12426,7 +12636,7 @@ Change default decimal constant representation from float4 to float8(Bruce) European date format now set when postmaster is started Execute lowercase function names if not found with exact case Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z' -Gist now included in the distrubution(Marc) +Gist now included in the distribution(Marc) Idend authentication of local users(Bryan) Implement BETWEEN qualifier(Bruce) Implement IN qualifier(Bruce) @@ -12455,7 +12665,7 @@ Vacuum now had VERBOSE option(Bruce) Source tree changes ------------------- All functions now have prototypes that are compared against the calls -Allow asserts to be disabled easly from Makefile.global(Bruce) +Allow asserts to be disabled easily from Makefile.global(Bruce) Change oid constants used in code to #define names Decoupled sparc and solaris defines(Kurt) Gcc -Wall compiles cleanly with warnings only from unfixable constructs @@ -12468,13 +12678,13 @@ Name change from Postgres95 to PostgreSQL New config.h file(Marc, Bryan) PG_VERSION now set to 6.0 and used by postmaster Portability additions, including Ultrix, DG/UX, AIX, and Solaris -Reduced the number of #define's, centeralized #define's +Reduced the number of #define's, centralized #define's Remove duplicate OIDS in system tables(Dan) Remove duplicate system catalog info or report mismatches(Dan) Removed many os-specific #define's Restructured object file generation/location(Bryan, Marc) Restructured port-specific file locations(Bryan, Marc) -Unused/uninialized variables corrected +Unused/uninitialized variables corrected @@ -12614,8 +12824,8 @@ New Ports -- 2.39.5