@@ -44,6 +44,7 @@ Improve GEQO optimizer performance (Tom)
4444Allow IN/NOT IN to be handled via hash tables (Tom)
4545Improve NOT IN (subquery) performance (Tom)
4646Allow most IN subqueries to be processed as joins (Tom)
47+ Allow the postmaster to preload libraries using preload_libraries (Joe)
4748Improve reverse index scan performance (Tom)
4849Improve optimizer cost computations, particularly for subqueries (Tom)
4950Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom)
@@ -65,7 +66,6 @@ Rename show_*_stats to log_*_stats (Bruce)
6566Rename show_source_port to log_source_port (Bruce)
6667Rename hostname_lookup to log_hostname (Bruce)
6768Add checkpoint_warning to warn of excessive checkpointing (Bruce)
68- Allow the postmaster to preload libraries using preload_libraries (Joe)
6969New read-only server parameters for localization (Tom)
7070Change debug server log messages to output as DEBUG rather than LOG (Bruce)
7171Prevent server log variables from being turned off by non-super users (Bruce)
@@ -78,7 +78,7 @@ New is_superuser read-only variable (Tom)
7878New server-side parameter log_error_verbosity to control error detail (Tom)
7979postgres --help-config now dumps server config variables (Tom)
8080Make default shared_buffers 1000 and max_connections 100, if possible (Tom)
81- Add pg_settings table to see server settings (Joe)
81+ Addnew columns in pg_settings: context, type, source , min_val, max_val (Joe)
8282Prevent assign_session_authorization() from being confused by
8383 all-numeric user names (Tom)
8484
@@ -186,11 +186,13 @@ Arrays may now be specified as ARRAY[1,2,3], ARRAY[['a','b'],['c','d']],
186186 or ARRAY[ARRAY[ARRAY[2]]] (Joe)
187187Allow proper comparisons for arrays (Joe)
188188Allow indexes on array columns, and used in ORDER BY and DISTINCT (Joe)
189- Allow WHEREqualifications of the form 'col IN/ ANY/SOME/ALL (array) (?) ( Joe)
190- Allow SQL functionsto return arrays and take them as params ( Joe)
189+ Allow WHEREqualification 'expr <oper> ANY/SOME/ALL (array-expr)' (Tom, Joe)
190+ Allowpolymorphic SQL functions(Tom, Joe)
191191Allow array concatenation with '||' and normal array comparisons (Joe)
192192New array functions array_append(), array_cat(), array_lower(),
193193 array_prepend(), array_to_string(), array_upper(), string_to_array() (Joe)
194+ Allow user defined aggregates to use polymorphic functions (Tom, Joe)
195+ Allow polymorphic user defined aggregates (Tom, Joe)
194196Allow assignments to empty arrays (Joe)
195197Allow 60 in seconds fields of timestamp, time, interval input values (Tom)
196198Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)
@@ -224,6 +226,11 @@ Allow PL/pgSQL to declare variables of composite types without %ROWTYPE (Tom)
224226Fix PL/python _quote() function to handle big integers (?)
225227Make PL/python an untrusted language, now called plpythonu (Kevin Jacobs, Tom)
226228Change PL/pgSQL EXECUTE INTO to CREATE TABLE AS EXECUTE? (Peter)
229+ Allow polymorphic PL/pgSQL functions (Tom, Joe)
230+ Improved compiled function caching mechanism in PL/pgSQL with full
231+ support for polymorphism (Tom, Joe)
232+ Add new $0 parameter in PL/pgSQL representing the function's actual
233+ return type (Tom, Joe)
227234
228235 _________________________________________________________________
229236
@@ -314,13 +321,14 @@ Upgrade mysql
314321Update cube (Bruno Wolff III)
315322Update earthdistance to use cube (Bruno Wolff III)
316323Update btree_gist (Oleg)
317- Add hashes to tablefuncs (Joe)
324+ Add hashed based crosstab function to tablefuncs (Joe)
325+ Add serial column to order connectby() siblings in tablefuncs (Nabil Sayegh,Joe)
326+ Add named persistent connections to dblink (Shridhar Daithanka)
318327New pg_autovacuum allows automatic VACUUM (Matthew T. O'Connor)
319328Allow pgbench to honor PGHOST, PGPORT, PGUSER env. variables (Tatsuo)
320329Improve intarray (Teodor Sigaev)
321330Improve pgstattuple (Rod)
322- Fix second argument to metaphone() in fullystrmatch
323- Add named persistent connections to dblink (Shridhar Daithanka)
331+ Fix bug in metaphone() in fuzzystrmatch
324332Improve adddepend (Rod)
325333Update spi/timetravel (B?jthe Zolt?n)
326334Fix dbase -s option (Thomas Behr)