summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/drop_database.sgml
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>1998-09-22 15:48:03 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>1998-09-22 15:48:03 +0000
commit52ca2ab26852caf5715f92fa8457eaad4be5e9cc (patch)
treebfbbcd2cc180957a92ba7ddbf8bc435fd7d1f8eb /doc/src/sgml/ref/drop_database.sgml
parent748e3003176c94d5db2174e959b46f7745d806a7 (diff)
Editing and markup cleanup.
Diffstat (limited to 'doc/src/sgml/ref/drop_database.sgml')
-rw-r--r--doc/src/sgml/ref/drop_database.sgml44
1 files changed, 24 insertions, 20 deletions
diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml
index d99d7d43e87..5fe7b48ad5b 100644
--- a/doc/src/sgml/ref/drop_database.sgml
+++ b/doc/src/sgml/ref/drop_database.sgml
@@ -17,7 +17,7 @@
<DATE>1998-04-15</DATE>
</REFSYNOPSISDIVINFO>
<SYNOPSIS>
- DROP DATABASE <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE>
+DROP DATABASE <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE>
</SYNOPSIS>
<REFSECT2 ID="R2-SQL-DROPDATABASE-1">
@@ -29,12 +29,6 @@
</TITLE>
<PARA>
</PARA>
- <VARIABLELIST>
- <VARLISTENTRY>
- <TERM>
- </TERM>
- <LISTITEM>
- <PARA>
<VARIABLELIST>
<VARLISTENTRY>
<TERM>
@@ -47,9 +41,6 @@
</LISTITEM>
</VARLISTENTRY>
</variablelist>
- </LISTITEM>
- </VARLISTENTRY>
- </VARIABLELIST>
</REFSECT2>
<REFSECT2 ID="R2-SQL-DROPDATABASE-2">
@@ -64,6 +55,7 @@
<VARIABLELIST>
<VARLISTENTRY>
<TERM>
+<replaceable>status</replaceable>
</TERM>
<LISTITEM>
<PARA>
@@ -88,6 +80,16 @@
</PARA>
</LISTITEM>
</VARLISTENTRY>
+ <VARLISTENTRY>
+ <TERM>
+ <ReturnValue>ERROR: destroydb cannot be executed on an open database</ReturnValue>
+ </TERM>
+ <LISTITEM>
+ <PARA>
+ This message occurs if the specified database does not exist.
+ </PARA>
+ </LISTITEM>
+ </VARLISTENTRY>
</variablelist>
</LISTITEM>
</VARLISTENTRY>
@@ -116,17 +118,19 @@
<TITLE>
Notes
</TITLE>
- <PARA>
- <warning>
+
+ <para>
+ DROP DATABASE statement is a <productname>Postgres</productname>
+ language extension.
+
+ <tip>
<para>
- This query should NOT be executed interactively.
- The <command>destroydb</command> script should be used instead.
+ This query cannot be executed while connected to the target
+database. It is usually preferable to use the
+ <command>destroydb</command> script instead.
</para>
- </warning>
- <comment>Some explanation would be desirable here!</comment>
- </PARA>
- <para>
- DROP DATABASE statement is a PostgreSQL language extension.
+ </tip>
+
</para>
<para>
Refer to the <command>CREATE DATABASE</command> statement for
@@ -150,7 +154,7 @@
SQL92
</TITLE>
<PARA>
- There is no DROP DATABASE statement in SQL92.
+ There is no <command>DROP DATABASE</command> in <acronym>SQL92</acronym>.
</PARA>
</refsect2>
</refsect1>