postgres.git / summary / log / commit / refs

commit    e513087f6401a64b0d9f0b20cd2a51a7938ac645
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Wed May 14 14:07:24 2014 +0000
First released in: 9.4.0

    doc:  auto-updatable view adjustments for 9.4 release notes
    
    Report by Dean Rasheed


doc/src/sgml/release-9.4.sgml | 23 +++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) diff --git a/doc/src/sgml/release-9.4.sgml b/doc/src/sgml/release-9.4.sgml index cabfbdd1e96..cddd66c6b30 100644 --- a/doc/src/sgml/release-9.4.sgml +++ b/doc/src/sgml/release-9.4.sgml @@ -175,7 +175,7 @@ </para> <para> - Previously, stripped lexemes got a default location and could be + Previously stripped lexemes got a default location and could be considered if mixed with non-stripped lexemes. </para> </listitem> @@ -268,7 +268,7 @@ </para> <para> - Previously, <option>-u</> was used to specify the user name. + Previously <option>-u</> was used to specify the user name. Also spell the long option as <option>--username</>, again for consistency with other tools. </para> @@ -1097,22 +1097,25 @@ <listitem> <para> - Allow the updating of <link - linkend="SQL-CREATEVIEW-updatable-views">views</link> - where only some columns are auto-updateable (Dean Rasheed) + Allow views to be <link + linkend="SQL-CREATEVIEW-updatable-views">automatically + updated</link> even if they contain some non-updatable columns + (Dean Rasheed) </para> <para> - Previously the presence of a non-auto-updateable column prevented - all columns from being auto-updated. Deletes are now supported - on suitable views even if no auto-updateable columns are present. + Previously the presence of non-updatable columns such as + expressions, literals, and function cals prevented automatic + updates. Now <command>INSERT</>s, <command>UPDATE</>s and + <command>DELETE</>s are supported, provided that they do not + attempt to assign new values to any of the non-updatable columns. </para> </listitem> <listitem> <para> Allow control over whether <command>INSERT</>s and - <command>UPDATE</>s can add rows to an auto-updateable view that + <command>UPDATE</>s can add rows to an auto-updatable view that would no longer appear in the view (Dean Rasheed) </para> @@ -1125,7 +1128,7 @@ <listitem> <para> Allow <link linkend="rules-privileges">security barrier views</> - to be automatically updateable (Dean Rasheed) + to be automatically updatable (Dean Rasheed) </para> </listitem> [parent: 062f53518927]