44 7.4 Development Branch
55
66
7- Valid as of 2003-08-01. Update release.sgml later.
8-
9-
7+ Valid as of 2003-09-29. Update release.sgml later.
8+
109Server Operation
1110
1211Allow IPv6 server connections (Nigel Kukard, Johan Jordaan, Bruce, Tom, Kurt
@@ -57,6 +56,10 @@ Use faster regex code from TCL (Henry Spencer, Tom)
5756Use bit-mapped relation sets in the optimizer (Tom)
5857Improve backend startup time (Tom)
5958Improve trigger/constraint performance (Stephan)
59+ Improve speed of col IN (const, const, const, ...) (Tom)
60+ Fix hash indexes which were broken in rare cases (Tom)
61+ Improve hash index concurrency and speed (Tom)
62+ Align shared buffers on 32-byte boundary for copy speed improvement
6063
6164 _________________________________________________________________
6265
@@ -81,6 +84,7 @@ postgres --help-config now dumps server config variables (Aizaz Ahmed)
8184Make default shared_buffers 1000 and max_connections 100, if possible (Tom)
8285Add new columns in pg_settings: context, type, source , min_val, max_val (Joe)
8386New pg_hba.conf 'hostnossl' to prevent SSL connections (Jon Jensen)
87+ Remove geqo_random_seed server parameter (Tom)
8488
8589 _________________________________________________________________
8690
@@ -161,6 +165,10 @@ Functional indexes now support indexes on column expressions (Tom)
161165Syntax errors now reported as 'syntax error' rather than 'parse error' (Tom)
162166Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)
163167Have COMMENT ON DATABASE on non-local database generate a warning (Rod)
168+ Improve reliability of LISTEN/NOTIFY (Tom)
169+ Allow REINDEX to reliabily reindex all indexes, except global ones (Tom)
170+ pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
171+ all dumps use SET SESSION AUTHORIZATION
164172
165173 _________________________________________________________________
166174
@@ -214,6 +222,7 @@ Add new DateStyle values MDY, DMY, and YMD, honor US and European for
214222Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)
215223Prevent interval from supressing ':00' seconds display
216224New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions
225+ Allow time to be specified as '040506' or '0405' (Tom)
217226
218227 _________________________________________________________________
219228
@@ -229,6 +238,7 @@ Improved compiled function caching mechanism in PL/pgSQL with full
229238 support for polymorphism (Joe)
230239Add new $0 parameter in PL/pgSQL representing the function's actual
231240 return type (Joe)
241+ Allow pltcl and plpython use the same trigger on multiple tables (Tom)
232242
233243 _________________________________________________________________
234244
@@ -238,7 +248,7 @@ Add "\pset pager always" to always use pager (Greg)
238248Improve tab completion (Rod, Ross Reedstrom, Ian Barwick)
239249Reorder \? help into groupings (Harald Armin Massa, Bruce)
240250Add schema, cast, and conversion backslash commands (Christopher)
241- \encoding nowtracks client_encoding server variable (Tom)
251+ \encoding nowchanges based on client_encoding server variable (Tom)
242252Save edit history into readline history (Ross)
243253Improve \d display (Christopher)
244254Enhance HTML mode to be more standards-compliant (Greg)
@@ -265,6 +275,8 @@ Allow new error codes and levels of text (Tom)
265275Allow access to the underlying table and column of a query result (Tom)
266276Allow access to the current transaction status (Tom)
267277Add ability to pass binary data directly to the backend (Tom)
278+ Add PQexecPrepared() and PQsendQueryPrepared() functions which
279+ perform Bind/Execute of previously prepared statements (Tom)
268280
269281 _________________________________________________________________
270282
@@ -309,6 +321,8 @@ New ereport() function for error reporting (Tom)
309321Support Intel Linux compiler (Peter)
310322Improve Linux startup scripts (Slawomir Sudnik, Darko Prenosil)
311323Add support for AMD Opteron and Itanium (Jeffrey W. Baker, Bruce)
324+ Remove configure --enable-recode
325+ Generate a compile error if spinlock code isn't found (Bruce)
312326
313327 _________________________________________________________________
314328
@@ -334,7 +348,8 @@ Improve pgstattuple (Rod)
334348Fix bug in metaphone() in fuzzystrmatch
335349Improve adddepend (Rod)
336350Update spi/timetravel (B?jthe Zolt?n)
337- Fix dbase -s option (Thomas Behr)
351+ Fix dbase -s option and improve non-ASCII handling (Thomas Behr,M?rcio Smiderle)
352+ Remove array module because features now included by default (Joe)
338353
339354 _________________________________________________________________
340355