diff options
Diffstat (limited to 'HISTORY')
| -rw-r--r-- | HISTORY | 22 |
1 files changed, 15 insertions, 7 deletions
@@ -44,6 +44,7 @@ Improve GEQO optimizer performance (Tom) Allow IN/NOT IN to be handled via hash tables (Tom) Improve NOT IN (subquery) performance (Tom) Allow most IN subqueries to be processed as joins (Tom) +Allow the postmaster to preload libraries using preload_libraries (Joe) Improve reverse index scan performance (Tom) Improve optimizer cost computations, particularly for subqueries (Tom) Assume 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) Rename show_source_port to log_source_port (Bruce) Rename hostname_lookup to log_hostname (Bruce) Add checkpoint_warning to warn of excessive checkpointing (Bruce) -Allow the postmaster to preload libraries using preload_libraries (Joe) New read-only server parameters for localization (Tom) Change debug server log messages to output as DEBUG rather than LOG (Bruce) Prevent server log variables from being turned off by non-super users (Bruce) @@ -78,7 +78,7 @@ New is_superuser read-only variable (Tom) New server-side parameter log_error_verbosity to control error detail (Tom) postgres --help-config now dumps server config variables (Tom) Make default shared_buffers 1000 and max_connections 100, if possible (Tom) -Add pg_settings table to see server settings (Joe) +Add new columns in pg_settings: context, type, source , min_val, max_val (Joe) Prevent assign_session_authorization() from being confused by all-numeric user names (Tom) @@ -186,11 +186,13 @@ Arrays may now be specified as ARRAY[1,2,3], ARRAY[['a','b'],['c','d']], or ARRAY[ARRAY[ARRAY[2]]] (Joe) Allow proper comparisons for arrays (Joe) Allow indexes on array columns, and used in ORDER BY and DISTINCT (Joe) -Allow WHERE qualifications of the form 'col IN/ANY/SOME/ALL (array) (?) (Joe) -Allow SQL functions to return arrays and take them as params (Joe) +Allow WHERE qualification 'expr <oper> ANY/SOME/ALL (array-expr)' (Tom, Joe) +Allow polymorphic SQL functions (Tom, Joe) Allow array concatenation with '||' and normal array comparisons (Joe) New array functions array_append(), array_cat(), array_lower(), array_prepend(), array_to_string(), array_upper(), string_to_array() (Joe) +Allow user defined aggregates to use polymorphic functions (Tom, Joe) +Allow polymorphic user defined aggregates (Tom, Joe) Allow assignments to empty arrays (Joe) Allow 60 in seconds fields of timestamp, time, interval input values (Tom) Allow 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) Fix PL/python _quote() function to handle big integers (?) Make PL/python an untrusted language, now called plpythonu (Kevin Jacobs, Tom) Change PL/pgSQL EXECUTE INTO to CREATE TABLE AS EXECUTE? (Peter) +Allow polymorphic PL/pgSQL functions (Tom, Joe) +Improved compiled function caching mechanism in PL/pgSQL with full + support for polymorphism (Tom, Joe) +Add new $0 parameter in PL/pgSQL representing the function's actual + return type (Tom, Joe) _________________________________________________________________ @@ -314,13 +321,14 @@ Upgrade mysql Update cube (Bruno Wolff III) Update earthdistance to use cube (Bruno Wolff III) Update btree_gist (Oleg) -Add hashes to tablefuncs (Joe) +Add hashed based crosstab function to tablefuncs (Joe) +Add serial column to order connectby() siblings in tablefuncs (Nabil Sayegh,Joe) +Add named persistent connections to dblink (Shridhar Daithanka) New pg_autovacuum allows automatic VACUUM (Matthew T. O'Connor) Allow pgbench to honor PGHOST, PGPORT, PGUSER env. variables (Tatsuo) Improve intarray (Teodor Sigaev) Improve pgstattuple (Rod) -Fix second argument to metaphone() in fullystrmatch -Add named persistent connections to dblink (Shridhar Daithanka) +Fix bug in metaphone() in fuzzystrmatch Improve adddepend (Rod) Update spi/timetravel (B?jthe Zolt?n) Fix dbase -s option (Thomas Behr) |