postgres
diff --git a/‎doc/src/sgml/ref/alter_group.sgml
Lines changed: 2 additions & 2 deletions b/‎doc/src/sgml/ref/alter_group.sgml
Lines changed: 2 additions & 2 deletions
diff --git a/‎doc/src/sgml/ref/alter_language.sgml
Lines changed: 2 additions & 2 deletions b/‎doc/src/sgml/ref/alter_language.sgml
Lines changed: 2 additions & 2 deletions
diff --git a/‎doc/src/sgml/ref/alter_schema.sgml
Lines changed: 2 additions & 2 deletions b/‎doc/src/sgml/ref/alter_schema.sgml
Lines changed: 2 additions & 2 deletions
diff --git a/‎doc/src/sgml/ref/cluster.sgml
Lines changed: 2 additions & 2 deletions b/‎doc/src/sgml/ref/cluster.sgml
Lines changed: 2 additions & 2 deletions
diff --git a/‎doc/src/sgml/ref/clusterdb.sgml
Lines changed: 6 additions & 5 deletions b/‎doc/src/sgml/ref/clusterdb.sgml
Lines changed: 6 additions & 5 deletions
diff --git a/‎doc/src/sgml/ref/commit.sgml
Lines changed: 4 additions & 4 deletions b/‎doc/src/sgml/ref/commit.sgml
Lines changed: 4 additions & 4 deletions
diff --git a/‎doc/src/sgml/ref/create_database.sgml
Lines changed: 24 additions & 73 deletions b/‎doc/src/sgml/ref/create_database.sgml
Lines changed: 24 additions & 73 deletions
diff --git a/‎doc/src/sgml/ref/create_sequence.sgml
Lines changed: 1 addition & 44 deletions b/‎doc/src/sgml/ref/create_sequence.sgml
Lines changed: 1 addition & 44 deletions
diff --git a/‎doc/src/sgml/ref/create_view.sgml
Lines changed: 15 additions & 34 deletions b/‎doc/src/sgml/ref/create_view.sgml
Lines changed: 15 additions & 34 deletions
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.12 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.13 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -45,7 +45,7 @@ ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> RENAME TO <re
  </refsect1>
 
  <refsect1>
-  <title>Parameter</title>
+  <title>Parameters</title>
 
   <variablelist>
    <varlistentry>
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.4 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -35,7 +35,7 @@ ALTER LANGUAGE <replaceable>name</replaceable> RENAME TO <replaceable>newname</r
  </refsect1>
 
  <refsect1>
-  <title>Parameter</title>
+  <title>Parameters</title>
 
   <variablelist>
    <varlistentry>
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.4 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -36,7 +36,7 @@ ALTER SCHEMA <replaceable>name</replaceable> RENAME TO <replaceable>newname</rep
  </refsect1>
 
  <refsect1>
-  <title>Parameter</title>
+  <title>Parameters</title>
 
   <variablelist>
    <varlistentry>
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.28 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.29 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -74,7 +74,7 @@ CLUSTER
  </refsect1>
 
  <refsect1>
-  <title>Parameter</title>
+  <title>Parameters</title>
 
   <variablelist>
    <varlistentry>
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.13 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.14 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -48,16 +48,17 @@ PostgreSQL documentation
    <application>clusterdb</application> is a wrapper around the SQL
    command <xref linkend="SQL-CLUSTER" endterm="sql-cluster-title">.
    There is no effective difference between clustering databases via
-   this or other methods.  The database server must be running at the
-   targeted host.  Also, any default settings and environment
-   variables used by the <application>libpq</application> front-end
-   library will apply.
+   this utility and via other methods for accessing the server.
   </para>
 
   <para>
    In case of difficulty, see <xref linkend="SQL-CLUSTER"
    endterm="sql-cluster-title"> and <xref linkend="APP-PSQL"> for
    discussions of potential problems and error messages.
+   The database server must be running at the
+   targeted host.  Also, any default connection settings and environment
+   variables used by the <application>libpq</application> front-end
+   library will apply.
   </para>
 
  </refsect1>
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.17 2003/09/09 18:28:52 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.18 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -12,8 +12,8 @@ PostgreSQL documentation
  <refnamediv>
   <refname>COMMIT</refname>
   <refpurpose>commit the current transaction</refpurpose>
- </refnamediv>  
-  
+ </refnamediv>
+
  <indexterm zone="sql-commit">
   <primary>COMMIT</primary>
  </indexterm>
@@ -74,7 +74,7 @@ COMMIT;
 </programlisting>
   </para>
  </refsect1>
- 
+
  <refsect1>
   <title>Compatibility</title>
 
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.35 2003/08/31 17:32:22 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.36 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -36,6 +36,12 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable>
    <productname>PostgreSQL</productname> database.
   </para>
 
+  <para>
+   To create a database, you must be a superuser or have the special
+   <literal>CREATEDB</> privilege.
+   See <xref linkend="SQL-CREATEUSER" endterm="SQL-CREATEUSER-title">.
+  </para>
+
   <para>
    Normally, the creator becomes the owner of the new database.
    Superusers can create databases owned by other users using the
@@ -63,6 +69,8 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable>
    a leading slash
    (e.g., <filename>/usr/local/pgsql/data</filename>),
    are allowed as well.
+   In either case, the final path name must be absolute and must not
+   contain any single quotes.
   </para>
 
   <para>
@@ -86,7 +94,7 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable>
  </refsect1>
 
  <refsect1>
-  <title>Parameter</title>
+  <title>Parameters</title>
 
     <variablelist>
      <varlistentry>
@@ -147,78 +155,20 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable>
  </refsect1>
 
  <refsect1>
-  <title>Diagnostics</title>
-
-    <variablelist>
-     <varlistentry>
-      <term><computeroutput>CREATE DATABASE</computeroutput></term>
-      <listitem>
-       <para>
-	Message returned if the database was successfully created.
-       </para>
-      </listitem>
-     </varlistentry>
-
-     <varlistentry>
-      <term><computeroutput>ERROR:  user '<replaceable class="parameter">username</replaceable>' is not allowed to create/drop databases</computeroutput></term>
-      <listitem>
-       <para>
-        You must have the special <literal>CREATEDB</> privilege to create databases.
-        See <xref linkend="SQL-CREATEUSER" endterm="SQL-CREATEUSER-title">.
-       </para>
-      </listitem>
-     </varlistentry>
-
-
-     <varlistentry>
-      <term><computeroutput>ERROR:  createdb: database "<replaceable class="parameter">name</replaceable>" already exists</computeroutput></term>
-      <listitem>
-       <para>
-	This occurs if a database with the specified name already
-	exists.
-       </para>
-      </listitem>
-     </varlistentry>
-
-     <varlistentry>
-      <term><computeroutput>ERROR:  database path may not contain single quotes</computeroutput></term>
-      <listitem>
-       <para>
-	The database location
-        <replaceable class="parameter">dbpath</replaceable> cannot contain
-        single quotes. This is required so that the shell commands that
-        create the database directory can execute safely.
-       </para>
-      </listitem>
-     </varlistentry>
-
-     <varlistentry>
-      <term><computeroutput>ERROR:  CREATE DATABASE: may not be called in a transaction block</computeroutput></term>
-      <listitem>
-       <para>
-        If you have an explicit transaction block in progress you cannot call
-        <command>CREATE DATABASE</command>. You must finish the transaction first.
-       </para>
-      </listitem>
-     </varlistentry>
-
-     <varlistentry>
-      <term><computeroutput>ERROR:  Unable to create database directory '<replaceable>path</replaceable>'.</computeroutput></term>
-      <term><computeroutput>ERROR:  Could not initialize database directory.</computeroutput></term>
-      <listitem>
-       <para>
-        These are most likely related to insufficient permissions on the data
-        directory, a full disk, or other file system problems. The user under
-        which the database server is running must have access to the location.
-       </para>
-      </listitem>
-     </varlistentry>
+  <title>Notes</title>
 
-    </variablelist>
- </refsect1>
+   <para>
+    <command>CREATE DATABASE</> cannot be executed inside a transaction
+    block.
+   </para>
 
- <refsect1>
-  <title>Notes</title>
+   <para>
+    Errors along the line of <quote>could not initialize database directory</>
+    are most likely related to insufficient permissions on the data
+    directory, a full disk, or other file system problems.  When using an
+    alternate location, the user under
+    which the database server is running must have access to the location.
+   </para>
 
    <para>
     Use <xref linkend="SQL-DROPDATABASE" endterm="SQL-DROPDATABASE-title"> to remove a database.
@@ -231,7 +181,8 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable>
 
   <para>
    There are security issues involved with using alternate database
-   locations specified with absolute path names.  See <xref
+   locations specified with absolute path names; this is why the feature
+   is not enabled by default.  See <xref
    linkend="manage-ag-alternate-locs"> for more information.
   </para>
 
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.34 2003/08/31 17:32:22 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.35 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -196,49 +196,6 @@ SELECT * FROM <replaceable>seqname</replaceable>;
   </variablelist>
  </refsect1>
 
- <refsect1>
-  <title>Diagnostics</title>
-
-  <variablelist>
-   <varlistentry>
-    <term><computeroutput>CREATE SEQUENCE</computeroutput></term>
-    <listitem>
-     <para>
-      Message returned if the sequence was successfully created.
-     </para>
-    </listitem>
-   </varlistentry>
-
-   <varlistentry>
-    <term><computeroutput>ERROR:  Relation '<replaceable class="parameter">seqname</replaceable>' already exists</computeroutput></term>
-    <listitem>
-     <para>
-      A sequence, table, view, or index of the specified name already exists.
-     </para>
-    </listitem>
-   </varlistentry>
-
-   <varlistentry>
-    <term><computeroutput>ERROR:  DefineSequence: MINVALUE (<replaceable class="parameter">start</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>)</computeroutput></term>
-    <term><computeroutput>ERROR:  DefineSequence: START value (<replaceable class="parameter">start</replaceable>) can't be < MINVALUE (<replaceable class="parameter">min</replaceable>)</computeroutput></term>
-    <listitem>
-     <para>
-      The specified starting value is out of range.
-     </para>
-    </listitem>
-   </varlistentry>
-
-   <varlistentry>
-    <term><computeroutput>ERROR:  DefineSequence: MINVALUE (<replaceable class="parameter">min</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>)</computeroutput></term>
-    <listitem>
-     <para>
-      The minimum and maximum values are inconsistent.
-     </para>
-    </listitem>
-   </varlistentry>
-  </variablelist>
- </refsect1>
-
  <refsect1>
   <title>Notes</title>
 
 
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_view.sgml,v 1.23 2003/08/31 17:32:22 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_view.sgml,v 1.24 2003/09/12 00:12:47 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -90,39 +90,6 @@ class="PARAMETER">column_name</replaceable> [, ...] ) ] AS <replaceable class="P
   </variablelist>
  </refsect1>
 
- <refsect1>
-  <title>Diagnostics</title>
-
-  <variablelist>
-   <varlistentry>
-    <term><computeroutput>CREATE VIEW</computeroutput></term>
-    <listitem>
-     <para>
-      Message returned if the view was successfully created.
-     </para>
-    </listitem>
-   </varlistentry>
-
-   <varlistentry>
-    <term><computeroutput>WARNING:  Attribute '<replaceable class="parameter">column</replaceable>' has an unknown type</computeroutput></term>
-    <listitem>
-     <para>
-      The view will be created having a column with an unknown type if
-      you do not specify it. For example, the following command gives
-      this warning:
-<programlisting>
-CREATE VIEW vista AS SELECT 'Hello World'
-</programlisting>
-      whereas this command does not:
-<programlisting>
-CREATE VIEW vista AS SELECT text 'Hello World'
-</programlisting>
-     </para>
-    </listitem>
-   </varlistentry>
-  </variablelist>
- </refsect1>
-
  <refsect1>
   <title>Notes</title>
 
@@ -137,6 +104,20 @@ CREATE VIEW vista AS SELECT text 'Hello World'
    <para>
     Use the <command>DROP VIEW</command> statement to drop views.
    </para>
+
+   <para>
+    Be careful that the names and types of the view's columns will be
+    assigned the way you want.  For example,
+<programlisting>
+CREATE VIEW vista AS SELECT 'Hello World';
+</programlisting>
+    is bad form in two ways: the column name defaults to <literal>?column?</>,
+    and the column datatype defaults to <type>unknown</>.  If you want a
+    string literal in a view's result, use something like
+<programlisting>
+CREATE VIEW vista AS SELECT text 'Hello World' AS hello;
+</programlisting>
+   </para>
  </refsect1>
 
  <refsect1>