From 5fe3da927b2857761f9206d9fc597cf5321d9638 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter_e@gmx.net>
Date: Tue, 27 Jan 2009 12:40:15 +0000
Subject: Revert updatable views

---
 doc/src/sgml/catalogs.sgml        |   9 +---
 doc/src/sgml/intro.sgml           |   4 +-
 doc/src/sgml/ref/create_view.sgml | 100 +++-----------------------------------
 3 files changed, 9 insertions(+), 104 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 4fae50cd326..53d8142b78e 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.191 2009/01/22 20:15:59 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.192 2009/01/27 12:40:14 petere Exp $ -->
 <!--
  Documentation of the system catalogs, directed toward PostgreSQL developers
  -->
@@ -4154,13 +4154,6 @@
       <entry>True if the rule is an <literal>INSTEAD</literal> rule</entry>
      </row>
 
-     <row>
-      <entry><structfield>is_auto</structfield></entry>
-      <entry><type>bool</type></entry>
-      <entry></entry>
-      <entry>True if the rule was automatically generated</entry>
-     </row>
-
      <row>
       <entry><structfield>ev_qual</structfield></entry>
       <entry><type>text</type></entry>
diff --git a/doc/src/sgml/intro.sgml b/doc/src/sgml/intro.sgml
index 298ba910a95..ccc3c8d7720 100644
--- a/doc/src/sgml/intro.sgml
+++ b/doc/src/sgml/intro.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/intro.sgml,v 1.33 2009/01/22 17:27:54 petere Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/intro.sgml,v 1.34 2009/01/27 12:40:14 petere Exp $ -->
 
 <preface id="preface">
  <title>Preface</title>
@@ -110,7 +110,7 @@
      <simpara>triggers</simpara>
     </listitem>
     <listitem>
-     <simpara>updatable views</simpara>
+     <simpara>views</simpara>
     </listitem>
     <listitem>
      <simpara>transactional integrity</simpara>
diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index daea5a97cb0..1a3281dda62 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.40 2009/01/22 17:27:54 petere Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.41 2009/01/27 12:40:15 petere Exp $
 PostgreSQL documentation
 -->
 
@@ -115,99 +115,11 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW <replaceable class="PARAMETER">n
   <title>Notes</title>
 
    <para>
-    Some views are updatable, which means that the
-    commands <command>INSERT</command>, <command>UPDATE</command>,
-    and <command>DELETE</command> can be used on the view as if it
-    were a regular table.  A view is updatable if it
-    does <emphasis>not</emphasis> contain:
-
-    <itemizedlist>
-     <listitem>
-      <para>
-       more than one underlying table (joins) or no underlying table at all
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       underlying tables/views that are themselves not updatable,
-       including table value constructors and table functions
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       subqueries in the <literal>FROM</literal> list
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       items in the select list that are not direct references to a
-       column of the underlying table, such as literals or any
-       nontrivial value expression
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       references to system columns in the select list
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       more than one reference to the same column in the select list
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>aggregate function calls</para>
-     </listitem>
-
-     <listitem>
-      <para>window function calls</para>
-     </listitem>
-
-     <listitem>
-      <para>
-       <literal>WITH</literal> or <literal>WITH RECURSIVE</literal> clauses
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       <literal>DISTINCT</literal>, <literal>GROUP BY</literal>, or
-       <literal>HAVING</literal> clauses
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       <literal>UNION</literal>, <literal>INTERSECT</literal>, or
-       <literal>EXCEPT</literal> clauses
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       <literal>LIMIT</literal> or <literal>OFFSET</literal> clauses
-       (or other equivalent spellings thereof)
-      </para>
-     </listitem>
-    </itemizedlist>
-   </para>
-
-   <para>
-    The updatable views implementation is based on the rule system.
-    Because of this, you can also make more complex views updatable or
-    insertable by creating your own rules that rewrite
-    the <command>INSERT</command>,
-    <command>UPDATE</command>, and <command>DELETE</command> actions
-    on the view into appropriate actions on other tables.  You can
-    also replace the automatically generated rules by your own rules.
-    For more information on the rule system, refer
-    to <xref linkend="sql-createrule" endterm="sql-createrule-title">.
+    Currently, views are read only: the system will not allow an insert,
+    update, or delete on a view.  You can get the effect of an updatable
+    view by creating rules that rewrite inserts, etc. on the view into
+    appropriate actions on other tables.  For more information see
+    <xref linkend="sql-createrule" endterm="sql-createrule-title">.
    </para>
 
    <para>
-- 
cgit v1.2.3