On Wed, May 14, 2014 at 08:33:15AM +0100, Dean Rasheed wrote:
> On 4 May 2014 13:46, Bruce Momjian <br...@momjian.us> wrote:
> > I have completed the initial version of the 9.4 release notes. You can
> > view them here:
> >
> > http://www.postgresql.org/docs/devel/static/release-9-4.html
> >
> > I will be adding additional markup in the next few days.
> >
> > Feedback expected and welcomed. I expect to be modifying this until we
> > release 9.4 final. I have marked items where I need help with question
> > marks.
> >
>
> In a few places, I think "updateable" should be spelled "updatable"
> for consistency with the rest of the documentation (although I think
> both spellings are actually correct).
>
>
> ===
> Allow the updating of views where only some columns are
> auto-updateable (Dean Rasheed)
>
> 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.
> ===
>
> I think that puts too much emphasis on deletes, and could be
> misinterpreted. How about something like this:
>
> Allow views to be automatically updatable even if they contain some
> non-updatable columns (Dean Rasheed)
>
> Previously the presence of non-updatable columns such as expressions,
> literals and functions prevented automatic updates. Now INSERTs,
> UPDATEs and DELETEs are supported, provided that they do not attempt
> to assign new values to any of the non-updatable columns.
Agreed. Adjusted attached patch applied. I was never happy with the
previous awkward auto-update wording.
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
diff --git a/doc/src/sgml/release-9.4.sgml b/doc/src/sgml/release-9.4.sgml
new file mode 100644
index cabfbdd..eb0b4f8
*** a/doc/src/sgml/release-9.4.sgml
--- b/doc/src/sgml/release-9.4.sgml
***************
*** 1097,1118 ****
<listitem>
<para>
! Allow the updating of <link
! linkend="SQL-CREATEVIEW-updatable-views">views</link>
! where only some columns are auto-updateable (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.
</para>
</listitem>
<listitem>
<para>
Allow control over whether <command>INSERT</>s and
! <command>UPDATE</>s can add rows to an auto-updateable view that
would no longer appear in the view (Dean Rasheed)
</para>
--- 1097,1121 ----
<listitem>
<para>
! 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 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-updatable view that
would no longer appear in the view (Dean Rasheed)
</para>
***************
*** 1125,1131 ****
<listitem>
<para>
Allow <link linkend="rules-privileges">security barrier views</>
! to be automatically updateable (Dean Rasheed)
</para>
</listitem>
--- 1128,1134 ----
<listitem>
<para>
Allow <link linkend="rules-privileges">security barrier views</>
! to be automatically updatable (Dean Rasheed)
</para>
</listitem>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
