diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-05-14 10:07:24 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-05-14 10:07:24 -0400 |
| commit | e513087f6401a64b0d9f0b20cd2a51a7938ac645 (patch) | |
| tree | 638d7152d2aee8011b945f38898084b3ec65251d /doc/src | |
| parent | 062f53518927f9bfe1820578ce79d3180b1aa2ca (diff) | |
| download | postgresql-e513087f6401a64b0d9f0b20cd2a51a7938ac645.tar.gz postgresql-e513087f6401a64b0d9f0b20cd2a51a7938ac645.zip | |
doc: auto-updatable view adjustments for 9.4 release notes
Report by Dean Rasheed
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/release-9.4.sgml | 23 |
1 files 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> |