From 5a6ba62be5364dbf973fd9b8631fd60acda03440 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Tue, 1 Feb 2011 17:17:34 -0500
Subject: [PATCH] Document that CREATE VIEW that uses "*" for the column list
 will not auto-add columns later added to the base table.

---
 doc/src/sgml/ref/create_view.sgml | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index dd15507811..417f8c38e7 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -173,6 +173,10 @@ CREATE VIEW comedies AS
     FROM films
     WHERE kind = 'Comedy';
 </programlisting>
+   This will create a view containing the columns that are in the
+   <literal>film</> table at the time of view creation.  Though
+   <literal>*</> was used to create the view, columns added later to
+   the table will not be part of the view.
   </para>
  </refsect1>
 
-- 
2.40.0