@@ -82,7 +82,8 @@ Have psql \d display indexes in unique, primary groupings (Christopher Kings-Lyn
8282Improve PL/pgSQL error reporting (Tom)
8383Add DROP CONSTRAINT for CHECK constraints (Christopher Kings-Lynne)
8484PL/pgSQL Allow IS and FOR in cursors (Bruce)
85- Native language error messages, psql, pg_dump, libpq, configure --enable-nls (Peter E)
85+ Native language error messages, psql, pg_dump, libpq, configure --enable-nls
86+ (Peter E, Serguei A. Mokhov, Weiping He, Forth)
8687Allow NULL to appear at beginning/end based on ORDER BY (Tom)
8788Add %TYPE capability to CREATE TYPE (Ian Lance Taylor)
8889Truncate extra-long sequence names to a reasonable value (Tom)
@@ -131,27 +132,40 @@ New postgresql.conf option to enable/disable "col = NULL" comparisons
131132New postgresql.conf parameter to control memory usage by VACUUM (Tom)
132133New postgresql.conf time out parameter for client authentication (Tom)
133134New pg_ctl 'reload' option (Tom)
134- Add /contrib/intarray boolean queries, fixes (Oleg Bartunov)
135+ Add /contrib/intarray boolean queries,binary search, fixes (Oleg Bartunov)
135136New postgresql.conf to set maximum open files (Tom)
137+ New CREATE OR REPLACE FUNCTION that preserves function oid (Gavin Sherry)
138+ DROP AGGREGATE and COMMENT ON AGGREGATE now accept an aggtype (Tom)
139+ Prevent output of default index op class in pg_dump (Tom)
140+ Allow trailing semicolons in psql backslash commands (Greg Sabino Mullane)
136141
137142Types
138143-----
139144CHAR(n)/VARCHAR(n) represents letters, not bytes (Tatsuo)
140145CHAR(), VARCHAR() now returns error on storage of too long string (Peter E)
141146BIT, BIT VARYING now returns error on too long input (Peter E)
142147New function bit_length() (Peter E)
143- inet, cidr text conversion functions (Alex Pilosov)
144- inet, cidr operators << and <<= indexable (Alex Pilosov)
148+ INET, CIDR text conversion functions (Alex Pilosov)
149+ INET, CIDR operators << and <<= indexable (Alex Pilosov)
145150Bytea comparison improvements, \### now requires three octal digits (Joe Conway)
146151Make trim/ltrim/rtrim/btrim/lpad/rpad/translate() multibyte aware (Tatsuo)
147152Add pg_database_encoding_max_length() (Tatsuo)
153+ Add pg_client_encoding() function (Tatsuo)
148154Make mic2ascii() non-ASCII aware (Tatsuo)
149155Measure transaction times in milliseconds (Thomas)
150156now() returns time in milliseconds (Thomas)
151157New TIMEZONE WITHOUT TIMEZONE data types (Thomas)
152158Add ISO date/time specification with 'T', yyyy-mm-ddThh:mm:ss (Thomas)
153159New xid/int comparison functions (Hiroshi)
154- Fix TID sequential scans (H
160+ Fix TID sequential scans (Hiroshi)
161+ Add precision to TIME and TIMESTAMP data types (Thomas)
162+ Cachability fixes (Thomas, Tom)
163+ PL/TCL now reports errorInfo (Vsevolod Lobko)
164+ Modify type coersion logic to attempt binary-compatible functions first (Tom)
165+ Allow optional () after current_user, session_user, user, etc. (Peter E)
166+ Add compatibility functions to odbc.sql (Peter E)
167+ Force new password prompt when changing user and database in psql (Tatsuo, Tom)
168+
155169Performance
156170-----------
157171Optimizer improvements (Tom)
@@ -163,6 +177,9 @@ Load pg_hba.conf only on startup and SIGHUP (Bruce)
163177Rtree performance improvements (Kenneth Been)
164178Improve lock manager to reduce lock contention (Tom)
165179Btree splits more efficient (Tom)
180+ Dynahash portability improvements (Tom)
181+ Keep relcache entries for index access support functions (Tom)
182+ Make ALTER TABLE RENAME COLUMN update column names of indexes (Brent Verner)
166183
167184Interfaces
168185----------
194211Add bytea type capability (Barry Lind)
195212Add isNullable() (Rene Pijlman)
196213JDBC date/time test suite fixes (Liam Stewart)
214+ Fix for SELECT 'id' AS xxx FROM table (Dave Cramer)
197215ODBC
198216Remove query limit (Hiroshi)
199217Remove text field size limit (Hiroshi)
@@ -250,6 +268,8 @@ Remove compile-time limit on number of backends (Tom)
250268Enable SIGTERM, SIGQUIT to kill backends (Jan)
251269New pgjindent utility to indent java code (Bruce)
252270Replace strcasecmp() with strcmp() where appropriate (Peter E)
271+ Remove configure --enable-pltcl-utf option
272+ Make PL/PgSQL use the backends type coersion code (Tom)
253273
254274
255275