@@ -65,7 +65,7 @@ PL/pgSQL memory leak fix (Jan, Tom)
6565Fix nested EXCEPT/INTERSECT (Tom)
6666Python fix fetchone() (Gerhard Haring)
6767ECPG fixes (Michael, Christof Petig)
68-
68+ PL/PgSQL trailing semicolon optional (Tom)
6969
7070Enhancements
7171------------
@@ -124,6 +124,16 @@ Allow ALTER TABLE ADD UNIQUE (Christopher Kings-Lynne)
124124Super-user id now defaults to 1 (Peter E)
125125Reject invalid multibyte character sequences (Tatsuo)
126126New libpq PQescapeString() function to escape query strings (Florian Weimer)
127+ New EXPLAIN ANALYZE command that shows runtimes and tuple counts (Martijn
128+ van Oosterhout)
129+ New postgresql.conf option to enable/disable "col = NULL" comparisons
130+ (Peter E)
131+ New postgresql.conf parameter to control memory usage by VACUUM (Tom)
132+ New postgresql.conf time out parameter for client authentication (Tom)
133+ New pg_ctl 'reload' option (Tom)
134+ Add /contrib/intarray boolean queries, fixes (Oleg Bartunov)
135+ Measure transaction times in milliseconds (Thomas)
136+ 'NOW' returns time in milliseconds
127137
128138Types
129139-----
@@ -133,7 +143,10 @@ BIT, BIT VARYING now returns error on too long input (Peter E)
133143New function bit_length() (Peter E)
134144inet, cidr text conversion functions (Alex Pilosov)
135145inet, cidr operators << and <<= indexable (Alex Pilosov)
136- Bytea comparison improvements (Joe Conway)
146+ Bytea comparison improvements, \### now requires three octal digits (Joe Conway)
147+ Make trim/ltrim/rtrim/btrim/lpad/rpad/translate() multibyte aware (Tatsuo)
148+ Add pg_database_encoding_max_length() (Tatsuo)
149+ Make mic2ascii() non-ASCII aware (Tatsuo)
137150
138151Performance
139152-----------
@@ -147,39 +160,42 @@ Load pg_hba.conf only on startup and SIGHUP (Bruce)
147160Interfaces
148161----------
149162JDBC
150- return oid of INSERT (Ken K)
151- hande more data types (Ken K)
152- handle single quotes and newlines in strings (Ken K)
153- handle NULL variables (Ken K)
154- fix for timezone handling (Barry Lind)
163+ Return oid of INSERT (Ken K)
164+ Hande more data types (Ken K)
165+ Handle single quotes and newlines in strings (Ken K)
166+ Handle NULL variables (Ken K)
167+ Fix for timezone handling (Barry Lind)
155168Improved Druid support
156169Allow eight-bit characters with non-multibyte server (Barry Lind)
157- support BIT, BINARY types (Ned Wolpert)
158- reduce memory usage (Michael Stephens, Dave Cramer)
159- update DatabaseMetaData (Peter E)
160- add DatabaseMetaData.getCatalogs() (Peter E)
161- encoding fixes (Anders Bengtsson)
162- get /setCatalog methods (Jason Davies)
163- DatabaseMetaData .getColumns() now returns column defaults (Jason Davies)
164- jdbc1 and jdbc2 merging (Anders Bengtsson)
165- transaction performance improvements (Barry Lind)
166- array fixes (Greg Zoller)
170+ Support BIT, BINARY types (Ned Wolpert)
171+ Reduce memory usage (Michael Stephens, Dave Cramer)
172+ Update DatabaseMetaData (Peter E)
173+ Add DatabaseMetaData.getCatalogs() (Peter E)
174+ Encoding fixes (Anders Bengtsson)
175+ Get /setCatalog methods (Jason Davies)
176+ Databasemetadata .getColumns() now returns column defaults (Jason Davies)
177+ Jdbc1 and jdbc2 merging (Anders Bengtsson)
178+ Transaction performance improvements (Barry Lind)
179+ Array fixes (Greg Zoller)
167180Serialize addition
168- fix batch processing (Ren? Pijlman)
181+ Fix batch processing (Ren? Pijlman)
169182ExecSQL method reorganization (Anders Bengtsson)
170- getColumn () fixes (Jeroen van Vianen)
171- fix isWriteable() function (Ren? Pijlman)
183+ GetColumn () fixes (Jeroen van Vianen)
184+ Fix isWriteable() function (Ren? Pijlman)
172185Improved passage of jdbc2 conformance tests (Ren? Pijlman)
173186Add bytea type capability (Barry Lind)
187+ Add isNullable() (Rene Pijlman)
188+ JDBC date/time test suite fixes (Liam Stewart)
174189ODBC
175- remove query limit (Hiroshi)
176- remove text field size limit (Hiroshi)
177- fix for SQLPrimaryKeys() (Hiroshi)
178- procedure calls (Hiroshi)
190+ Remove query limit (Hiroshi)
191+ Remove text field size limit (Hiroshi)
192+ Fix for SQLPrimaryKeys() (Hiroshi)
193+ Procedure calls (Hiroshi)
179194FETCH first fix (Aidan Mountford)
180- updatable cursors (Hiroshi)
195+ Updatable cursors (Hiroshi)
181196Most configure options on setable via DSN (Hiroshi)
182- multibyte, performance fixes (Hiroshi)
197+ Multibyte, performance fixes (Hiroshi)
198+ Allow driver to be used with iODBC or unixODBC (Peter E)
183199ECPG
184200EXECUTE ... INTO ... implemented
185201multiple row descriptor support (e.g. CARDINALITY)
@@ -207,12 +223,12 @@ Remove EXTEND INDEX (Martijn van Oosterhout, Tom)
207223Correct description of translate() function (Bruce)
208224/contrib/fulltextindex fixes (Christopher Kings-Lynne)
209225Fix for Win32 socket communication failures (Magnus, Mikhail Terekhov)
210- /contrib/intarray fixes (Oleg Bartunov)
211226Hurd compile fix (Oliver Elphick)
212227New /contrib/fuzzystrmatch with lievnshtein and metaphone, soundex merged (Joe Conway)
213228Beos fixes (Cyril VELTER)
214229Remove OID's from some system tables (Tom)
215- New functions in /contrib/pgcrypto: crypt(), hmac(), encrypt() (Marko Kreen)
230+ New functions in /contrib/pgcrypto: crypt(), hmac(), encrypt(), gen_salt()
231+ (Marko Kreen)
216232System table operator reorganization (Oleg Bartunov, Teodor Sigaev, Tom)
217233Rename config.h to pg_config.h (Peter E)
218234pg_log now pg_clog (Tom)
@@ -225,6 +241,7 @@ Better cleanup for semaphore resource failure (Tatsuo, Tom)
225241Remove compile-time limit on number of backends (Tom)
226242Enable SIGTERM, SIGQUIT to kill backends (Jan)
227243New pgjindent utility to indent java code (Bruce)
244+ Replace strcasecmp() with strcmp() where appropriate (Peter E)
228245
229246
230247