diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-10-18 16:16:18 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-10-18 16:16:18 +0000 |
| commit | 73677dd92f35b4c24b6c00b049aa9b0a66fdb702 (patch) | |
| tree | 83001516af1867e74807bfb40392d8adbf869f46 /doc/src | |
| parent | 60dcf13ea10a5ab6fa61e8509df36b5823a15857 (diff) | |
| download | postgresql-73677dd92f35b4c24b6c00b049aa9b0a66fdb702.tar.gz postgresql-73677dd92f35b4c24b6c00b049aa9b0a66fdb702.zip | |
The following patch was sent to the patches list:
This patch forces the use of 'DROP VIEW' to destroy views.
It also changes the syntax of DROP VIEW to
DROP VIEW v1, v2, ...
to match the syntax of DROP TABLE.
Some error messages were changed so this patch also includes changes to the
appropriate expected/*.out files.
Doc changes for 'DROP TABLE" and 'DROP VIEW' are included.
--
Mark Hollomon
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/drop_table.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/drop_view.sgml | 6 |
2 files changed, 9 insertions, 9 deletions
diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index 7e0b85d6af5..5f5a7aa821b 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_table.sgml,v 1.7 2000/07/21 04:37:10 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_table.sgml,v 1.8 2000/10/18 16:16:03 momjian Exp $ Postgres documentation --> @@ -39,7 +39,7 @@ DROP TABLE <replaceable class="PARAMETER">name</replaceable> [, ...] <term><replaceable class="PARAMETER">name</replaceable></term> <listitem> <para> - The name of an existing table or view to drop. + The name of an existing table to drop. </para> </listitem> </varlistentry> @@ -68,11 +68,11 @@ DROP </varlistentry> <varlistentry> <term><computeroutput> -ERROR Relation "<replaceable class="parameter">name</replaceable>" Does Not Exist! +ERROR: table "<replaceable class="parameter">name</replaceable>" is nonexistent </computeroutput></term> <listitem> <para> - If the specified table or view does not exist in the database. + If the specified table does not exist in the database. </para> </listitem> </varlistentry> @@ -89,8 +89,8 @@ ERROR Relation "<replaceable class="parameter">name</replaceable>" Does Not Exis Description </title> <para> - <command>DROP TABLE</command> removes tables and views from the database. - Only its owner may destroy a table or view. A table + <command>DROP TABLE</command> removes tables from the database. + Only its owner may destroy a table. A table may be emptied of rows, but not destroyed, by using <command>DELETE</command>. </para> <para> diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index 7d08cbf485e..636d18151d5 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.6 1999/07/22 15:09:11 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.7 2000/10/18 16:16:03 momjian Exp $ Postgres documentation --> @@ -23,7 +23,7 @@ Postgres documentation <date>1999-07-20</date> </refsynopsisdivinfo> <synopsis> -DROP VIEW <replaceable class="PARAMETER">name</replaceable> +DROP VIEW <replaceable class="PARAMETER">name</replaceable> [, ...] </synopsis> <refsect2 id="R2-SQL-DROPVIEW-1"> @@ -70,7 +70,7 @@ DROP </varlistentry> <varlistentry> <term><computeroutput> -ERROR: RewriteGetRuleEventRel: rule "_RET<replaceable class="PARAMETER">name</replaceable>" not found +ERROR: view <replaceable class="parameter">name</replaceable> is nonexistent </computeroutput></term> <listitem> <para> |