@@ -15,38 +15,43 @@ Valid as of 2003-09-28. Update release.sgml later.
1515 Major changes in this release:
1616
1717 IPv6
18- Full support for IPv6 connections and IPv6 data types.
18+ Full support for IPv6 connections and IPv6address data types
1919
2020 SSL
21- MajorSSL improvements in performance and security.
21+ Major improvements inSSL performance and security
2222
2323 Index Growth Prevention
2424 Allow free space map to efficiently reused empty index pages,
25- and other free space improvements.
25+ and other free space management improvements.
26+
27+ Standards Compliance
28+ Implement information schema
29+ Support for read-only transactions
30+ Make cursors comply more closely with the SQL standard
2631
2732 New Client/Server Communication Protocol
28-
29-
30-
33+ New protocol improves connection speed/reliability, and adds
34+ error codes, status information, a binary protocol, error
35+ reporting verbosity, and cleaner startup packets.
3136
3237 Performance
33-
34- procesing by usinghack buckets
35- Hash indexes now have better concurrency/reliability/performance
36- New multi-key hash join capability
37- ANSI joins are now fully optimized
38- Faster regular expression code
38+ IN/NOT IN subqueries now perform as efficiently as joins
39+ Improved GROUP BYprocessing by usinghash buckets
40+ New multi-key hash join capability
41+ ANSI joins are now fully optimized
42+ Faster regular expression code
43+ Function-inlining for simple SQL functions
3944
40- Cursors
41-
45+ Holdable Cursors
46+ Allow cursors to exist outside transactions
4247
4348 Threads
44-
49+ libpq and ecpg are now fully thread-safe with --enable-thread-safety
4550
4651 Contrib
47-
48-
49-
52+ New version of full text indexing (tsearch2)
53+ New autovacuum tool
54+ Array handling has been improved and moved into the main server
5055
5156 _________________________________________________________________
5257
@@ -58,18 +63,21 @@ Valid as of 2003-09-28. Update release.sgml later.
5863 Observe the following incompatibilities:
5964 * The server-side autocommit setting was removed an reimplemented
6065 in client applications and languages.
61- * Error message wording has changeddramtically in this release,
66+ * Error message wording has changeddramatically in this release,
6267 and error codes have been added.
6368 * ANSI joins may behave differently because they are now fully optimized
6469 * A number of server variables have been renamed for clarity
6570 * MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
6671 varies based on the current offset in the cursor
67- * COPY now can process carriage-return/line-feed andcarraige -return
72+ * COPY now can process carriage-return/line-feed andcarriage -return
6873 terminated files. Literal carriage-returns and line-feeds are no
6974 longer accepted as data values; use \r and \n instead.
70- * Auto-trim spaces when converting from CHAR() to VARCHAR()/TEXT
75+ * Trailing spaces are now trimmed when converting from CHAR(n) to
76+ VARCHAR(n)/TEXT
7177 * FLOAT(p) now measures 'p' in bits, not digits
7278 * Date values now must match the ordering specified by DateStyle
79+ * The oidrand(), oidsrand(), and userfntest() functions have been
80+ removed.
7381
7482 _________________________________________________________________
7583
@@ -177,14 +185,14 @@ Change EXECUTE INTO to CREATE TABLE AS EXECUTE (Peter)
177185Object Manipulation
178186
179187Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil)
180- Add FOR EACH STATEMENT statement-level triggers (Neil Conway )
188+ Add FOR EACH STATEMENT statement-level triggers (Neil)
181189Add DOMAIN CHECK constraints (Rod)
182190Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
183191 CONSTRAINT (Rod)
184192Fix several zero-column table bugs (Tom)
185193Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)
186194Add ALTER DOMAIN OWNER (Rod)
187- Add ALTER TABLE ... WITHOUT OIDS? (Rod)
195+ Add ALTER TABLE ... WITHOUT OIDS (Rod)
188196Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values (Rod)
189197Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)
190198Improve DOMAIN automatic type casting (Rod, Tom)
@@ -225,7 +233,7 @@ Have pg_dumpall use GRANT/REVOKE to dump database-level permissions (Tom)
225233Allow pg_dumpall to support the -a, -s, -x options of pg_dump (Tom)
226234Prevent pg_dump from lowercasing identifiers specified on the command line (Tom)
227235Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)
228- Allow EXPLAIN EXECUTE (Neil)
236+ Add EXPLAIN EXECUTE (Neil)
229237Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
230238 CHECK constraints (Christopher)
231239Improve VACUUM performance on indexes by reducing WAL traffic (Tom)
@@ -235,7 +243,7 @@ Syntax errors now reported as 'syntax error' rather than 'parse error' (Tom)
235243Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)
236244Have COMMENT ON DATABASE on non-local database generate a warning (Rod)
237245Improve reliability of LISTEN/NOTIFY (Tom)
238- Allow REINDEX toreliabily reindexall indexes, except global ones (Tom)
246+ Allow REINDEX toreliably reindexnon-shared system catalog indexes (Tom)
239247pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
240248 all dumps use SET SESSION AUTHORIZATION
241249
@@ -289,7 +297,7 @@ Add new DateStyle values MDY, DMY, and YMD, honor US and European for
289297'now' will no longer work as a column default, use now() (change required for
290298 prepared statements) (Tom)
291299Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)
292- Prevent interval fromsupressing ':00' seconds display
300+ Prevent interval fromsuppressing ':00' seconds display
293301New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions
294302Allow time to be specified as '040506' or '0405' (Tom)
295303