summaryrefslogtreecommitdiff
path: root/HISTORY
diff options
context:
space:
mode:
Diffstat (limited to 'HISTORY')
-rw-r--r--HISTORY22
1 files changed, 15 insertions, 7 deletions
diff --git a/HISTORY b/HISTORY
index c5bdf75da9..06128f9822 100644
--- a/HISTORY
+++ b/HISTORY
@@ -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)