From e9eb4f401333209139af1acee2cd4251b05e0397 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Thu, 28 Oct 2010 17:42:58 +0300 Subject: [PATCH] Release notes for 9.1alpha2 --- doc/src/sgml/release-9.1.sgml | 267 ++++++++++++++++++++++++---------- 1 file changed, 194 insertions(+), 73 deletions(-) diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml index 5a51fc54d3..9b7a8c849f 100644 --- a/doc/src/sgml/release-9.1.sgml +++ b/doc/src/sgml/release-9.1.sgml @@ -1,6 +1,6 @@ - + Release 9.1alpha1 @@ -72,8 +72,49 @@ - Recognize functional dependency on primary - keys + Add ALTER TYPE ... ADD/DROP/ALTER/RENAME ATTRIBUTE + + + + + + Support triggers on views + + + + This adds the SQL-standard concept of an INSTEAD OF trigger, + which is fired instead of performing a physical + insert/update/delete. The trigger function is passed the + entire old and/or new rows of the view, and must figure out + what to do to the underlying tables to implement the update. + So this feature can be used to implement updatable views + using trigger programming style rather than rule hacking. + + + + + + Allow WITH clauses to be attached to INSERT, UPDATE, DELETE + statements + + + + This is not the hoped-for facility of using + INSERT/UPDATE/DELETE inside a WITH, but rather the other way + around. + + + + + + Allow new values to be added to an existing enum type + + + + + + Recognize functional dependency on primary + keys This allows a table's other columns to be referenced without listing @@ -84,7 +125,7 @@ - Add CREATE TABLE IF NOT EXISTS + Add CREATE TABLE IF NOT EXISTS @@ -96,22 +137,61 @@ - Reduce lock levels of CREATE TRIGGER and some ALTER - TABLE, CREATE RULE actions + Support MergeAppend plans, to allow sorted output + from append relations + + + + This eliminates the former need to sort the output of an + Append scan when an ordered scan of an inheritance tree is + wanted. This should be particularly useful for fast-start + cases such as queries with LIMIT. + + + + + + Reduce the memory requirement for large ispell dictionaries + + + + + + Teach CLUSTER to use seqscan-and-sort when it's faster than + indexscan - Add some knowledge about prefix matches to - tsmatchsel() + Improve GIN indexscan cost estimation - Replace the naive HYPOT() macro with a - standards-conformant hypotenuse function + Performance improvements in pg_upgrade for uses with many tables + + + + + + Reduce lock levels of CREATE TRIGGER and some ALTER + TABLE, CREATE RULE actions + + + + + + Add some knowledge about prefix matches to + tsmatchsel() + + + + + + Replace the naive HYPOT() macro with a + standards-conformant hypotenuse function @@ -123,9 +203,9 @@ - Change the default value of + Change the default value of standard_conforming_strings to - on + on @@ -137,7 +217,7 @@ - Add log_file_mode parameter + Add log_file_mode parameter This allows control of the file permissions set on log files created @@ -147,7 +227,7 @@ - Add restart_after_crash parameter + Add restart_after_crash parameter Normally, we automatically restart after a backend crash, but in @@ -165,29 +245,44 @@ - Make EXPLAIN show the function call expression of a - FunctionScan plan node, but only in VERBOSE mode + Allow pg_ctl to register the service in either AUTO or DEMAND start + type + + + + + + Support host names and host key + word all + in pg_hba.conf + + + + + + Make EXPLAIN show the function call expression of a + FunctionScan plan node, but only in VERBOSE mode - Make EXPLAIN print PARAM_EXEC Params as - the referenced expressions, rather than just $N + Make EXPLAIN print PARAM_EXEC Params as + the referenced expressions, rather than just $N - Add vacuum and analyze counters to pg_stat_*_tables - views + Add vacuum and analyze counters to pg_stat_*_tables + views - Add stats functions and views to provide access to a - transaction's own statistics counts + Add stats functions and views to provide access to a + transaction's own statistics counts @@ -199,8 +294,19 @@ - Add server authentication over Unix-domain - sockets + Add SECURITY LABEL command + + + This is intended as infrastructure to support integration + with label-based mandatory access control systems such as + SE-Linux. + + + + + + Add server authentication over Unix-domain + sockets This adds a libpq connection parameter requirepeer that @@ -217,27 +323,36 @@ - Add string functions: concat(), concat_ws(), left(), - right(), and reverse() + Accept public as a pseudo-role + name in has_table_privilege() and friends + to see if a particular privilege has been granted to + PUBLIC - Add three-parameter forms of array_to_string and - string_to_array + Add string functions: concat(), concat_ws(), left(), + right(), and reverse() - Add XMLEXISTS function + Add three-parameter forms of array_to_string and + string_to_array - Add xpath_exists() function + Add XMLEXISTS function + + + + + + Add xpath_exists() function This is equivalent to XMLEXISTS except that it offers support for @@ -247,9 +362,9 @@ - Add xml_is_well_formed, xml_is_well_formed_document, + Add xml_is_well_formed, xml_is_well_formed_document, xml_is_well_formed_content functions to the core XML - code + code These supersede a version previously offered by contrib/xml2. @@ -264,15 +379,15 @@ - Allow numeric to use a more compact, 2-byte header in - many cases + Allow numeric to use a more compact, 2-byte header in + many cases - Add support for dividing money by money (yielding a - float8 result) and for casting between money and numeric + Add support for dividing money by money (yielding a + float8 result) and for casting between money and numeric @@ -284,8 +399,8 @@ - Add options to force quoting of all - identifiers + Add options to force quoting of all + identifiers This includes a quote_all_identifiers parameter which affects the @@ -303,16 +418,16 @@ - Add \conninfo command to psql, to show current connection - info + Add \conninfo command to psql, to show current connection + info - Extend psql's \e and \ef commands so that a line number + Extend psql's \e and \ef commands so that a line number can be specified, and the editor's cursor will be initially placed - on that line + on that line To avoid assumptions about what switch the user's editor takes for @@ -323,16 +438,16 @@ - Add a \sf (show function) command to psql, for those + Add a \sf (show function) command to psql, for those times when you need to look at a function but don't wish to fire up - an editor + an editor - Make psql distinguish between unique indices and unique - constraints in \d printout + Make psql distinguish between unique indices and unique + constraints in \d printout @@ -346,9 +461,9 @@ - Modify the handling of RAISE without parameters so that + Modify the handling of RAISE without parameters so that the error it throws can be caught in the same places that could - catch an ordinary RAISE ERROR in the same location + catch an ordinary RAISE ERROR in the same location The previous coding insisted on throwing the error from the block @@ -359,7 +474,7 @@ - Remove ancient PL/pgSQL line numbering hack + Remove ancient PL/pgSQL line numbering hack PL/pgSQL used to count the second line of the function body as @@ -381,37 +496,43 @@ - Add the ability to compute per-statement latencies (ie, - average execution times) to pgbench + Updates to contrib/isn ISBN tables + + + + + + Add the ability to compute per-statement latencies (ie, + average execution times) to pgbench - Teach levenshtein() about multi-byte - characters + Teach levenshtein() about multi-byte + characters - Add btree_gist support for searching on not - equals + Add btree_gist support for searching on not + equals - Add ssl_cipher() and ssl_version() functions to - contrib/sslinfo + Add ssl_cipher() and ssl_version() functions to + contrib/sslinfo - Remove the arbitrary (and undocumented) limit on the + Remove the arbitrary (and undocumented) limit on the number of parameter=value pairs that can be handled by - xslt_process() + xslt_process() @@ -423,8 +544,8 @@ - Include the backend ID in the relpath of temporary - relations + Include the backend ID in the relpath of temporary + relations This allows us to reliably remove all leftover temporary relation @@ -436,45 +557,45 @@ - Rewrite COMMENT ON object code for better - modularity, and add necessary locking + Rewrite COMMENT ON object code for better + modularity, and add necessary locking - Add a hook in ExecCheckRTPerms() for eventual use by - external security-checking modules + Add a hook in ExecCheckRTPerms() for eventual use by + external security-checking modules - Standardize names and calling conventions of - get_whatever_oid functions + Standardize names and calling conventions of + get_whatever_oid functions - Make NestLoop plan nodes pass outer-relation variables + Make NestLoop plan nodes pass outer-relation variables into their inner relation using the general PARAM_EXEC executor parameter mechanism, rather than the ad-hoc kluge of passing the - outer tuple down through ExecReScan + outer tuple down through ExecReScan - Make details of the Numeric representation private to - numeric.c + Make details of the Numeric representation private to + numeric.c - Suppress some compiler warnings from - clang + Suppress some compiler warnings from + clang -- 2.39.5