diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-09 18:28:53 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-09 18:28:53 +0000 |
| commit | d4019b7cd33e7d820013c8a58917e31cdcca57ed (patch) | |
| tree | 41759e9502ac811454da2cbe0d448fbcc30b9a52 /doc/src | |
| parent | 1815f6179d48d565d179032d79b2fcf844727094 (diff) | |
| download | postgresql-d4019b7cd33e7d820013c8a58917e31cdcca57ed.tar.gz postgresql-d4019b7cd33e7d820013c8a58917e31cdcca57ed.zip | |
Remove a bunch of content-free Diagnostics sections, as per previous
discussion. (Still have some work to do editing the remainder.)
Diffstat (limited to 'doc/src')
70 files changed, 290 insertions, 1566 deletions
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index e83b21e4d57..f0e436fccd4 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.14 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/abort.sgml,v 1.15 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -31,7 +31,8 @@ ABORT [ WORK | TRANSACTION ] <command>ABORT</command> rolls back the current transaction and causes all the updates made by the transaction to be discarded. This command is identical - in behavior to the standard <acronym>SQL</acronym> command <command>ROLLBACK</command>, + in behavior to the standard <acronym>SQL</acronym> command + <xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE">, and is present only for historical reasons. </para> </refsect1> @@ -53,35 +54,16 @@ ABORT [ WORK | TRANSACTION ] </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ROLLBACK</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: ROLLBACK: no transaction in progress</computeroutput></term> - <listitem> - <para> - If there is not any transaction currently in progress. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> - Use <command>COMMIT</command> to successfully - terminate a transaction. + Use <xref linkend="SQL-COMMIT" endterm="SQL-COMMIT-TITLE"> to + successfully terminate a transaction. + </para> + + <para> + Issuing <command>ABORT</> when not inside a transaction does + no harm, but it will provoke a warning message. </para> </refsect1> @@ -106,6 +88,15 @@ ABORT; </para> </refsect1> + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-begin" endterm="sql-begin-title"></member> + <member><xref linkend="sql-commit" endterm="sql-commit-title"></member> + <member><xref linkend="sql-rollback" endterm="sql-rollback-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index e4a6850e95d..7b8c76af70b 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_aggregate.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -29,8 +29,8 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable <para> <command>ALTER AGGREGATE</command> changes the definition of an - aggregate function. The only functionality is to rename the - aggregate function. + aggregate function. The only currently available functionality is to + rename the aggregate function. </para> </refsect1> @@ -67,21 +67,6 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER AGGREGATE</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index d1ab87c3b5f..5b07ef2b1db 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_conversion.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_conversion.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -29,7 +29,8 @@ ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname< <para> <command>ALTER CONVERSION</command> changes the definition of a - conversion. The only functionality is to rename the conversion. + conversion. The only currently available functionality is to rename the + conversion. </para> </refsect1> @@ -56,21 +57,6 @@ ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname< </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER CONVERSION</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 6e8da1f0308..cdc5e7f13e3 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.8 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.9 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -104,31 +104,6 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <repl </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER DATABASE</computeroutput></term> - <listitem> - <para> - Message returned if the alteration was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: database "dbname" does not exist</computeroutput></term> - <listitem> - <para> - Error message returned if the specified database is not known - to the system. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index f31311b6331..09e3db3ad8b 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.8 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.9 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -23,9 +23,6 @@ PostgreSQL documentation </indexterm> <refsynopsisdiv> - <refsynopsisdivinfo> - <date>2002-11-27</date> - </refsynopsisdivinfo> <synopsis> ALTER DOMAIN <replaceable class="PARAMETER">domain</replaceable> { SET DEFAULT <replaceable class="PARAMETER">value</replaceable> | DROP DEFAULT } @@ -38,116 +35,11 @@ ALTER DOMAIN <replaceable class="PARAMETER">domain</replaceable> ALTER DOMAIN <replaceable class="PARAMETER">domain</replaceable> OWNER TO <replaceable class="PARAMETER">new_owner</replaceable> </synopsis> - - <refsect2 id="R2-SQL-ALTERDOMAIN-1"> - <refsect2info> - <date>2002-11-27</date> - </refsect2info> - <title> - Inputs - </title> - <para> - <variablelist> - - <varlistentry> - <term><replaceable class="PARAMETER"> domain </replaceable></term> - <listitem> - <para> - The name (possibly schema-qualified) of an existing domain to - alter. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><replaceable class="PARAMETER"> domain_constraint </replaceable></term> - <listitem> - <para> - New domain constraint for the domain. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><replaceable class="PARAMETER"> constraint_name </replaceable></term> - <listitem> - <para> - Name of an existing constraint to drop. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term>CASCADE</term> - <listitem> - <para> - Automatically drop objects that depend on the constraint. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term>RESTRICT</term> - <listitem> - <para> - Refuse to drop the constraint if there are any dependent - objects. This is the default behavior. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><replaceable class="PARAMETER">new_owner</replaceable></term> - <listitem> - <para> - The user name of the new owner of the domain. - </para> - </listitem> - </varlistentry> - - </variablelist> - </para> - </refsect2> - - <refsect2 id="R2-SQL-ALTERDOMAIN-2"> - <refsect2info> - <date>1998-04-15</date> - </refsect2info> - <title> - Outputs - </title> - <para> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER DOMAIN</computeroutput></term> - <listitem> - <para> - Message returned from domain alteration. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR</computeroutput></term> - <listitem> - <para> - Message returned if domain is not available. - </para> - </listitem> - </varlistentry> - </variablelist> - </para> - </refsect2> </refsynopsisdiv> - <refsect1 id="R1-SQL-ALTERDOMAIN-1"> - <refsect1info> - <date>2002-11-27</date> - </refsect1info> - <title> - Description - </title> + <refsect1> + <title>Description</title> + <para> <command>ALTER DOMAIN</command> changes the definition of an existing domain. There are several sub-forms: @@ -213,10 +105,74 @@ ALTER DOMAIN <replaceable class="PARAMETER">domain</replaceable> </para> </refsect1> - <refsect1 id="R1-SQL-ALTERDOMAIN-2"> - <title> - Usage - </title> + <refsect1> + <title>Parameters</title> + + <para> + <variablelist> + <varlistentry> + <term><replaceable class="PARAMETER"> domain </replaceable></term> + <listitem> + <para> + The name (possibly schema-qualified) of an existing domain to + alter. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER"> domain_constraint </replaceable></term> + <listitem> + <para> + New domain constraint for the domain. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER"> constraint_name </replaceable></term> + <listitem> + <para> + Name of an existing constraint to drop. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term>CASCADE</term> + <listitem> + <para> + Automatically drop objects that depend on the constraint. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term>RESTRICT</term> + <listitem> + <para> + Refuse to drop the constraint if there are any dependent + objects. This is the default behavior. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER">new_owner</replaceable></term> + <listitem> + <para> + The user name of the new owner of the domain. + </para> + </listitem> + </varlistentry> + + </variablelist> + </para> + </refsect1> + + <refsect1> + <title>Examples</title> + <para> To add a NOT NULL constraint to a domain: <programlisting> @@ -243,6 +199,15 @@ ALTER DOMAIN zipcode DROP CONSTRAINT zipchk; </para> </refsect1> + <refsect1> + <title>Compatibility</title> + + <para> + The <command>ALTER DOMAIN</command> statement is compatible with SQL99, + except for the <literal>OWNER</> variant, which is a + <productname>PostgreSQL</productname> extension. + </para> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index 50c857b0e1a..cb11927d82c 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_function.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_function.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -65,21 +65,6 @@ ALTER FUNCTION <replaceable>name</replaceable> ( [ <replaceable class="parameter </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER FUNCTION</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index d306b952558..b9819f4a526 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.11 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.12 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -79,21 +79,6 @@ ALTER GROUP <replaceable class="PARAMETER">groupname</replaceable> RENAME TO <re </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER GROUP</computeroutput></term> - <listitem> - <para> - Message returned if the alteration was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> Add users to a group: diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml index c20ceded643..61595252ebf 100644 --- a/doc/src/sgml/ref/alter_language.sgml +++ b/doc/src/sgml/ref/alter_language.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -59,21 +59,6 @@ ALTER LANGUAGE <replaceable>name</replaceable> RENAME TO <replaceable>newname</r </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER LANGUAGE</computeroutput></term> - <listitem> - <para> - Message returned if the alteration was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml index be31dd98eb3..3a4ec0c7df7 100644 --- a/doc/src/sgml/ref/alter_opclass.sgml +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_opclass.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_opclass.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -67,21 +67,6 @@ ALTER OPERATOR CLASS <replaceable>name</replaceable> USING <replaceable class="p </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER OPERATOR CLASS</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml index 940e3d56235..473b57314d4 100644 --- a/doc/src/sgml/ref/alter_schema.sgml +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.2 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -60,21 +60,6 @@ ALTER SCHEMA <replaceable>name</replaceable> RENAME TO <replaceable>newname</rep </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER SCHEMA</computeroutput></term> - <listitem> - <para> - Message returned if the alteration was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index f12e9ad85a0..f4b114da4bd 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.3 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.4 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -23,24 +23,27 @@ PostgreSQL documentation </indexterm> <refsynopsisdiv> - <refsynopsisdivinfo> - <date>1999-07-20</date> - </refsynopsisdivinfo> <synopsis> ALTER SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT [ BY ] <replaceable class="parameter">increment</replaceable> ] [ MINVALUE <replaceable class="parameter">minvalue</replaceable> | NO MINVALUE ] [ MAXVALUE <replaceable class="parameter">maxvalue</replaceable> | NO MAXVALUE ] [ RESTART [ WITH ] <replaceable class="parameter">start</replaceable> ] [ CACHE <replaceable class="parameter">cache</replaceable> ] [ [ NO ] CYCLE ] </synopsis> - - <refsect2 id="R2-SQL-ALTERSEQUENCE-1"> - <refsect2info> - <date>1998-09-11</date> - </refsect2info> - <title> - Inputs - </title> - <para> + </refsynopsisdiv> + <refsect1> + <title>Description</title> + + <para> + <command>ALTER SEQUENCE</command> changes the parameters of an existing + sequence generator. Any parameter not specifically set in the + <command>ALTER SEQUENCE</command> command retains its prior setting. + </para> + </refsect1> + + <refsect1> + <title>Parameters</title> + + <para> <variablelist> <varlistentry> <term><replaceable class="parameter">seqname</replaceable></term> @@ -100,8 +103,8 @@ ALTER SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT <listitem> <para> The optional <option>RESTART WITH - <replaceable class="parameter">start</replaceable> - clause</option> enables the sequence to re-begin anywhere. + <replaceable class="parameter">start</replaceable></option> + clause changes the current value of the sequence. </para> </listitem> </varlistentry> @@ -151,78 +154,11 @@ ALTER SEQUENCE <replaceable class="parameter">seqname</replaceable> [ INCREMENT </varlistentry> </variablelist> </para> - </refsect2> - - <refsect2 id="R2-SQL-ALTERSEQUENCE-2"> - <refsect2info> - <date>1998-09-11</date> - </refsect2info> - <title> - Outputs - </title> - <para> - - <variablelist> - <varlistentry> - <term><computeroutput> -ALTER SEQUENCE - </computeroutput></term> - <listitem> - <para> - Message returned if the command is successful. - </para> - </listitem> - </varlistentry> - <varlistentry> - <term><computeroutput> -ERROR: AlterSequence: MINVALUE (<replaceable class="parameter">start</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>) - </computeroutput></term> - <listitem> - <para> - If the specified starting value is out of range. - </para> - </listitem> - </varlistentry> - <varlistentry> - <term><computeroutput> -ERROR: AlterSequence: START value (<replaceable class="parameter">start</replaceable>) can't be < MINVALUE (<replaceable class="parameter">min</replaceable>) - </computeroutput></term> - <listitem> - <para> - If the specified starting value is out of range. - </para> - </listitem> - </varlistentry> - <varlistentry> - <term><computeroutput> -ERROR: AlterSequence: MINVALUE (<replaceable class="parameter">min</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>) - </computeroutput></term> - <listitem> - <para> - If the minimum and maximum values are inconsistent. - </para> - </listitem> - </varlistentry> - </variablelist> - </para> - </refsect2> - </refsynopsisdiv> + </refsect1> - <refsect1 id="R1-SQL-ALTERSEQUENCE-1"> - <title> - Description - </title> - - <para> - See <xref linkend="SQL-CREATESEQUENCE"> for limitations, and uses - of sequences. - </para> - </refsect1> + <refsect1> + <title>Examples</title> - <refsect1 id="R1-SQL-ALTERSEQUENCE-2"> - <title> - Usage - </title> <para> Restart a sequence called <literal>serial</literal>, at 105: </para> @@ -231,35 +167,31 @@ ALTER SEQUENCE serial RESTART WITH 105; </programlisting> </refsect1> - <refsect1 id="R1-SQL-ALTERSEQUENCE-5"> - <title> - Notes - </title> + <refsect1> + <title>Notes</title> + <para> - To avoid blocking of concurrent transactions that obtain numbers from the same - sequence, a nextval operation is never rolled back; that is, once a value has - been fetched it is considered used, even if the transaction that did the nextval - later aborts. This means that aborted transactions may leave unused "holes" in - the sequence of assigned values. setval operations are never rolled back, either. + To avoid blocking of concurrent transactions that obtain numbers from the + same sequence, <command>ALTER SEQUENCE</command> is never rolled back; + the changes take effect immediately and are not reversible. </para> + <para> - <command>ALTER SEQUENCE</command> will not immediately affect backends, other than the - current one, which have cached sequence values. They must use up all cached values - prior to noticing the changed sequence parameters. The current backend will be - immediatly affected. + <command>ALTER SEQUENCE</command> will not immediately affect + <literal>nextval</> results in backends, + other than the current one, that have preallocated (cached) sequence + values. They will use up all cached values prior to noticing the changed + sequence parameters. The current backend will be affected immediately. </para> </refsect1> - <refsect1 id="R1-SQL-ALTERSEQUENCE-3"> + <refsect1> <title> Compatibility </title> - <refsect2 id="R2-SQL-ALTERSEQUENCE-4"> - <refsect2info> - <date>2003-03-02</date> - </refsect2info> + <refsect2> <title> SQL99 </title> diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 2dd377c0586..87d1a645775 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.60 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.61 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -332,30 +332,6 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER TABLE</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR</computeroutput></term> - <listitem> - <para> - Message returned if table or column does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index f8409136522..ee7afa87d89 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_trigger.sgml,v 1.5 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_trigger.sgml,v 1.6 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -41,7 +41,7 @@ ALTER TRIGGER <replaceable class="PARAMETER">trigger</replaceable> ON <replaceab </refsect1> <refsect1> - <title>Parameter</title> + <title>Parameters</title> <variablelist> <varlistentry> @@ -74,31 +74,6 @@ ALTER TRIGGER <replaceable class="PARAMETER">trigger</replaceable> ON <replaceab </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER TRIGGER</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR</computeroutput></term> - <listitem> - <para> - If the trigger does not exist, or the new name is a duplicate of - another existing trigger on the table. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index f3c7292718c..3db6df00528 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.29 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.30 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -176,31 +176,6 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replacea </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ALTER USER</computeroutput></term> - <listitem> - <para> - Message returned if the alteration was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: ALTER USER: user "username" does not exist</computeroutput></term> - <listitem> - <para> - Error message returned if the specified user is not known to - the database system. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 93d86763633..f0be5af1dbd 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/analyze.sgml,v 1.13 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/analyze.sgml,v 1.14 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -78,21 +78,6 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table</replaceable> [ (<rep </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ANALYZE</computeroutput></term> - <listitem> - <para> - The command is complete. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index 67393c891b1..5acab231b3c 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/begin.sgml,v 1.25 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/begin.sgml,v 1.26 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -28,21 +28,25 @@ BEGIN [ WORK | TRANSACTION ] <title>Description</title> <para> - By default, <productname>PostgreSQL</productname> executes - transactions in <quote>autocommit</quote> mode, that is, each - statement is executed in its own transaction and a commit is - implicitly performed at the end of the statement (if execution was - successful, otherwise a rollback is done). <command>BEGIN</command> initiates a transaction block, that is, all statements after <command>BEGIN</command> command will be executed in a single transaction until an explicit <xref linkend="sql-commit" endterm="sql-commit-title"> or <xref - linkend="sql-rollback" endterm="sql-rollback-title">. Statements - are executed more quickly in a transaction block, because + linkend="sql-rollback" endterm="sql-rollback-title"> is given. + By default (without <command>BEGIN</command>), + <productname>PostgreSQL</productname> executes + transactions in <quote>autocommit</quote> mode, that is, each + statement is executed in its own transaction and a commit is + implicitly performed at the end of the statement (if execution was + successful, otherwise a rollback is done). + </para> + + <para> + Statements are executed more quickly in a transaction block, because transaction start/commit requires significant CPU and disk activity. Execution of multiple statements inside a transaction is - also useful to ensure consistency when changing several related - tables: other sessions will be unable to see the intermediate states + also useful to ensure consistency when making several related changes: + other sessions will be unable to see the intermediate states wherein not all the related updates have been done. </para> </refsect1> @@ -64,31 +68,6 @@ BEGIN [ WORK | TRANSACTION ] </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>BEGIN</computeroutput></term> - <listitem> - <para> - This signifies that a new transaction has been started. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: BEGIN: already a transaction in progress</computeroutput></term> - <listitem> - <para> - This indicates that a transaction was already in progress. The - current transaction is not affected. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> @@ -100,7 +79,12 @@ BEGIN [ WORK | TRANSACTION ] <para> Use <xref linkend="SQL-COMMIT" endterm="SQL-COMMIT-TITLE"> or <xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE"> - to terminate a transaction. + to terminate a transaction block. + </para> + + <para> + Issuing <command>BEGIN</> when already inside a transaction block will + provoke a warning message. The state of the transaction is not affected. </para> </refsect1> @@ -138,6 +122,15 @@ BEGIN; about the transaction semantics when porting database applications. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-commit" endterm="sql-commit-title"></member> + <member><xref linkend="sql-rollback" endterm="sql-rollback-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 634f11de8b9..c3ea5ab8cfe 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/close.sgml,v 1.17 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/close.sgml,v 1.18 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -37,9 +37,10 @@ CLOSE <replaceable class="PARAMETER">cursor</replaceable> <para> Every non-holdable open cursor is implicitly closed when a transaction is terminated by <command>COMMIT</command> or - <command>ROLLBACK</command>. Holdable cursors are implicitely - closed if the transaction that created them aborts via - <command>ROLLBACK</command>; if this does not happen, the holdable + <command>ROLLBACK</command>. A holdable cursor is implicitly + closed if the transaction that created it aborts via + <command>ROLLBACK</command>. If the creating transaction successfully + commits, the holdable cursor remains open until an explicit <command>CLOSE</command> is executed, or the client disconnects. </para> @@ -59,32 +60,6 @@ CLOSE <replaceable class="PARAMETER">cursor</replaceable> </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CLOSE CURSOR</computeroutput></term> - <listitem> - <para> - Message returned if the cursor is successfully closed. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: cursor "<replaceable class="PARAMETER">cursor</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - Message returned if <replaceable - class="PARAMETER">cursor</replaceable> is not declared or has - already been closed. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Notes</title> diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index eaa1763d2ae..1eaa97e2e1e 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.27 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.28 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -98,21 +98,6 @@ CLUSTER </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CLUSTER</computeroutput></term> - <listitem> - <para> - The clustering was done successfully. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index dce618f3c01..8d4e082ec07 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.12 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.13 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -54,6 +54,12 @@ PostgreSQL documentation library will apply. </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. + </para> + </refsect1> @@ -177,37 +183,6 @@ PostgreSQL documentation <refsect1> - <title>Diagnostics</title> - - <para> - <variablelist> - <varlistentry> - <term><computeroutput>CLUSTER</computeroutput></term> - <listitem> - <para> - The database was successfully clustered. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>clusterdb: Cluster failed.</computeroutput></term> - <listitem> - <para> - Something went wrong. <application>clusterdb</application> is only a wrapper - script. See <xref linkend="SQL-CLUSTER" endterm="sql-cluster-title"> - and <xref linkend="APP-PSQL"> for a detailed - discussion of error messages and potential problems. - </para> - </listitem> - </varlistentry> - - </variablelist> - </para> - </refsect1> - - - <refsect1> <title>Environment</title> <variablelist> diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index 6927fb10a4a..7e0f4318bfd 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/comment.sgml,v 1.22 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/comment.sgml,v 1.23 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -97,21 +97,6 @@ COMMENT ON </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>COMMENT</computeroutput></term> - <listitem> - <para> - Message returned if the comment was successfully changed. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index b4992f73eab..1c72ea0b459 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.16 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.17 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -49,30 +49,6 @@ COMMIT [ WORK | TRANSACTION ] </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>COMMIT</computeroutput></term> - <listitem> - <para> - Message returned if the transaction was successfully committed. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: COMMIT: no transaction in progress</computeroutput></term> - <listitem> - <para> - Message if there is no transaction in progress. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Notes</title> @@ -81,6 +57,11 @@ COMMIT [ WORK | TRANSACTION ] Use <xref linkend="SQL-ROLLBACK" endterm="SQL-ROLLBACK-TITLE"> to abort a transaction. </para> + + <para> + Issuing <command>COMMIT</> when not inside a transaction does + no harm, but it will provoke a warning message. + </para> </refsect1> <refsect1> @@ -103,6 +84,15 @@ COMMIT; WORK</literal>. Otherwise, this command is fully conforming. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-begin" endterm="sql-begin-title"></member> + <member><xref linkend="sql-rollback" endterm="sql-rollback-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 1b3cd2d8b00..24dc567acf7 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.48 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.49 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -172,21 +172,6 @@ COPY <replaceable class="parameter">table</replaceable> [ ( <replaceable class=" </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>COPY</computeroutput></term> - <listitem> - <para> - The copy operation completed successfully. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index f0f212db18d..e7d0400ff79 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.27 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.28 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -218,21 +218,6 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( written in any order, not just the order illustrated above. </para> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE AGGREGATE</computeroutput></term> - <listitem> - <para> - Message returned if the command completes successfully. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index b89aead0bf4..08f48fea1dc 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.12 2003/08/31 17:32:21 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.13 2003/09/09 18:28:52 tgl Exp $ --> <refentry id="SQL-CREATECAST"> <refmeta> @@ -189,21 +189,6 @@ SELECT 'The time is ' || CAST(now() AS text); </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE CAST</computeroutput></term> - <listitem> - <para> - Message returned if the cast was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="sql-createcast-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_constraint.sgml b/doc/src/sgml/ref/create_constraint.sgml index 1cfcc39a8ed..d48b3eea952 100644 --- a/doc/src/sgml/ref/create_constraint.sgml +++ b/doc/src/sgml/ref/create_constraint.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_constraint.sgml,v 1.10 2003/08/31 17:32:21 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_constraint.sgml,v 1.11 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -99,21 +99,6 @@ CREATE CONSTRAINT TRIGGER <replaceable class="parameter">name</replaceable> </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE TRIGGER</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 6623bd8c5f7..441b80ef76c 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_conversion.sgml,v 1.11 2003/08/31 17:32:21 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_conversion.sgml,v 1.12 2003/09/09 18:28:52 tgl Exp $ --> <refentry id="SQL-CREATECONVERSION"> <refmeta> @@ -119,21 +119,6 @@ conv_proc( </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE CONVERSION</computeroutput></term> - <listitem> - <para> - Message returned if the conversion was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="sql-createconversion-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_domain.sgml b/doc/src/sgml/ref/create_domain.sgml index 6adf9b7ec1b..7a71e4a5982 100644 --- a/doc/src/sgml/ref/create_domain.sgml +++ b/doc/src/sgml/ref/create_domain.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_domain.sgml,v 1.14 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_domain.sgml,v 1.15 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -157,21 +157,6 @@ where <replaceable class="PARAMETER">constraint</replaceable> is: </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE DOMAIN</computeroutput></term> - <listitem> - <para> - Message returned if the domain was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index ef8274494e0..39ba9ff5881 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.49 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.50 2003/09/09 18:28:52 tgl Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -314,21 +314,6 @@ CREATE [ OR REPLACE ] FUNCTION <replaceable class="parameter">name</replaceable> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE FUNCTION</computeroutput></term> - <listitem> - <para> - Message returned if the function was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="sql-createfunction-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_group.sgml b/doc/src/sgml/ref/create_group.sgml index 1fb983721bf..dea3c18ff99 100644 --- a/doc/src/sgml/ref/create_group.sgml +++ b/doc/src/sgml/ref/create_group.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_group.sgml,v 1.12 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_group.sgml,v 1.13 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -84,21 +84,6 @@ where <replaceable class="PARAMETER">option</replaceable> can be: </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE GROUP</computeroutput></term> - <listitem> - <para> - Message returned if the group was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 06c37f497ee..3081f68ac85 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.40 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.41 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -186,21 +186,6 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">index_name</replaceable> </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE INDEX</computeroutput></term> - <listitem> - <para> - Message returned if the index was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index c729ecc56f9..45834255bb8 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_language.sgml,v 1.34 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_language.sgml,v 1.35 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -147,21 +147,6 @@ CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE <replaceable class="parameter">langna </variablelist> </refsect1> - <refsect1 id="sql-createlanguage-diagnostics"> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE LANGUAGE</computeroutput></term> - <listitem> - <para> - Message returned if the language was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="sql-createlanguage-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index f205eab8855..2ecf1cd4f29 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.9 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_opclass.sgml,v 1.10 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -204,21 +204,6 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL clauses may appear in any order. </para> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE OPERATOR CLASS</computeroutput></term> - <listitem> - <para> - Message returned if the operator class was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index 67470102f76..d806bdd9d6d 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_operator.sgml,v 1.37 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_operator.sgml,v 1.38 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -253,21 +253,6 @@ COMMUTATOR = OPERATOR(myschema.===) , </programlisting> </para> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE OPERATOR</computeroutput></term> - <listitem> - <para> - Message returned if the operator was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index 2fccd22a10d..996f5497575 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.40 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.41 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -167,21 +167,6 @@ CREATE [ OR REPLACE ] RULE <replaceable class="parameter">name</replaceable> AS </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE RULE</computeroutput></term> - <listitem> - <para> - Message returned if the rule was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index 3641587b9ad..cf98557998c 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_schema.sgml,v 1.7 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_schema.sgml,v 1.8 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -96,30 +96,6 @@ CREATE SCHEMA AUTHORIZATION <replaceable class="parameter">username</replaceable </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE SCHEMA</computeroutput></term> - <listitem> - <para> - Message returned if the schema was successfully created. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: namespace "<replaceable class="parameter">schemaname</replaceable>" already exists</computeroutput></term> - <listitem> - <para> - Message returned if the schema specified already exists. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 23cf859cd50..b558731137a 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.71 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.72 2003/09/09 18:28:52 tgl Exp $ PostgreSQL documentation --> @@ -564,23 +564,6 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: </variablelist> </refsect1> - - <refsect1 id="SQL-CREATETABLE-diagnostics"> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE TABLE</computeroutput></term> - <listitem> - <para> - Message returned if the table was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1 id="SQL-CREATETABLE-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index ac05e2d42e5..0d86492b752 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.15 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.16 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -102,18 +102,6 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name </refsect1> <refsect1> - <title>Diagnostics</title> - - <para> - Refer to <xref linkend="sql-createtable" - endterm="sql-createtable-title">, <xref linkend="sql-select" - endterm="sql-select-title">, and <xref linkend="sql-execute" - endterm="sql-execute-title"> for a summary of possible output - messages. - </para> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index cf580b1ab93..af75dd9841e 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.35 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.36 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -171,21 +171,6 @@ CREATE TRIGGER <replaceable class="PARAMETER">name</replaceable> { BEFORE | AFTE </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE TRIGGER</computeroutput></term> - <listitem> - <para> - Message returned if the trigger was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="SQL-CREATETRIGGER-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index 6e98d5e00ff..f287c12b4b5 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_type.sgml,v 1.44 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_type.sgml,v 1.45 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -408,21 +408,6 @@ CREATE TYPE <replaceable class="parameter">typename</replaceable> ( </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE TYPE</computeroutput></term> - <listitem> - <para> - Message returned if the type was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="SQL-CREATETYPE-notes"> <title>Notes</title> diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index f22b8854f07..ff294c63eae 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.27 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_user.sgml,v 1.28 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -168,21 +168,6 @@ where <replaceable class="PARAMETER">option</replaceable> can be: </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>CREATE USER</computeroutput></term> - <listitem> - <para> - Message returned if the user account was successfully created. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/deallocate.sgml b/doc/src/sgml/ref/deallocate.sgml index 11da825a723..887831d325f 100644 --- a/doc/src/sgml/ref/deallocate.sgml +++ b/doc/src/sgml/ref/deallocate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/deallocate.sgml,v 1.3 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/deallocate.sgml,v 1.4 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -64,21 +64,6 @@ DEALLOCATE [ PREPARE ] <replaceable class="parameter">plan_name</replaceable> </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DEALLOCATE</computeroutput></term> - <listitem> - <para> - Message returned if the prepared statement was deallocated successfully. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index 0f19dd6a811..4ec2d9de1b5 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.24 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.25 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -79,31 +79,6 @@ DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <replaceable </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP AGGREGATE</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveAggregate: aggregate '<replaceable class="parameter">name</replaceable>' for type <replaceable class="parameter">type</replaceable> does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if the specified aggregate function - does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index b8627e5156b..e108bfcbbc7 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_domain.sgml,v 1.11 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_domain.sgml,v 1.12 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -68,30 +68,6 @@ DROP DOMAIN <replaceable class="PARAMETER">domainname</replaceable> [, ...] [ C </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP DOMAIN</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveDomain: type '<replaceable class="parameter">domainname</replaceable>' does not exist</computeroutput></term> - <listitem> - <para> - This message occurs if the specified domain does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="SQL-DROPDOMAIN-examples"> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index 1a51b2b58c5..ec68f162c29 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.26 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_function.sgml,v 1.27 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -80,30 +80,6 @@ DROP FUNCTION <replaceable class="parameter">name</replaceable> ( [ <replaceable </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP FUNCTION</computeroutput></term> - <listitem> - <para> - Message returned if the command completes successfully. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: RemoveFunction: Function <replaceable class="parameter">name</replaceable> (<replaceable class="parameter">types</replaceable>) does not exist</computeroutput></term> - <listitem> - <para> - This message is output if the function specified does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="SQL-DROPFUNCTION-examples"> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_group.sgml b/doc/src/sgml/ref/drop_group.sgml index ea350586810..2473ccf2c56 100644 --- a/doc/src/sgml/ref/drop_group.sgml +++ b/doc/src/sgml/ref/drop_group.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_group.sgml,v 1.6 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_group.sgml,v 1.7 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -47,21 +47,6 @@ DROP GROUP <replaceable class="PARAMETER">name</replaceable> </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP GROUP</computeroutput></term> - <listitem> - <para> - Message returned if the group was successfully removed. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index 720d601e76c..9f71d0cf07b 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_index.sgml,v 1.19 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_index.sgml,v 1.20 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -69,32 +69,6 @@ DROP INDEX <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP INDEX</computeroutput></term> - <listitem> - <para> - Message returned if the command completes successfully. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: index "<replaceable class="PARAMETER">name</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if <replaceable - class="PARAMETER">name</replaceable> is not an existing - index. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 1be0bef48b0..4a997ac715d 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.18 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_language.sgml,v 1.19 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -69,32 +69,6 @@ DROP [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">name</replaceable> [ </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP LANGUAGE</computeroutput></term> - <listitem> - <para> - This message is returned if the language was successfully dropped. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: Language "<replaceable class="parameter">name</replaceable>" doesn't exist</computeroutput></term> - <listitem> - <para> - This message is returned if a language called <replaceable - class="parameter">name</replaceable> is not found in the - database. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index dcd72a30383..85f02cd4738 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.5 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.6 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -77,21 +77,6 @@ DROP OPERATOR CLASS <replaceable class="PARAMETER">name</replaceable> USING <rep </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP OPERATOR CLASS</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index 427e332b753..2b3267b3367 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.20 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.21 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -89,50 +89,6 @@ DROP OPERATOR <replaceable class="PARAMETER">name</replaceable> ( <replaceable c </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP OPERATOR</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveOperator: binary operator '<replaceable class="PARAMETER">name</replaceable>' taking '<replaceable class="PARAMETER">lefttype</replaceable>' and '<replaceable class="PARAMETER">righttype</replaceable>' does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if the specified binary operator does not exist. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveOperator: left unary operator '<replaceable class="PARAMETER">name</replaceable>' taking '<replaceable class="PARAMETER">lefttype</replaceable>' does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if the specified left unary operator - does not exist. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveOperator: right unary operator '<replaceable class="PARAMETER">name</replaceable>' taking '<replaceable class="PARAMETER">righttype</replaceable>' does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if the specified right unary operator - does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index df34ddd54b6..abd0bfc7014 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_rule.sgml,v 1.18 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_rule.sgml,v 1.19 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -77,30 +77,6 @@ DROP RULE <replaceable class="PARAMETER">name</replaceable> ON <replaceable clas </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP RULE</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: Rule "<replaceable class="parameter">name</replaceable>" not found</computeroutput></term> - <listitem> - <para> - Message if the specified rule does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index 77ccbbb8f34..5a52d3da3c0 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_schema.sgml,v 1.4 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_schema.sgml,v 1.5 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -74,30 +74,6 @@ DROP SCHEMA <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP SCHEMA</computeroutput></term> - <listitem> - <para> - Message returned if the schema was successfully dropped. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: Schema "<replaceable class="parameter">name</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - This message is returned if the specified schema does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index a23dd4ad16a..cc2e1bed1f1 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_sequence.sgml,v 1.18 2003/08/31 17:32:22 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_sequence.sgml,v 1.19 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -67,30 +67,6 @@ DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP SEQUENCE</computeroutput></term> - <listitem> - <para> - Message returned if the sequence was successfully dropped. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: sequence "<replaceable class="parameter">name</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - Message returned if the specified sequence does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index 61e253dc50b..b37a428eb62 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.19 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_table.sgml,v 1.20 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -79,30 +79,6 @@ DROP TABLE <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP TABLE</computeroutput></term> - <listitem> - <para> - Message returned if the command completes successfully. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: table "<replaceable class="parameter">name</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - Message returned if the specified table does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index f4a24e90198..6505815fbee 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_trigger.sgml,v 1.16 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_trigger.sgml,v 1.17 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -78,30 +78,6 @@ DROP TRIGGER <replaceable class="PARAMETER">name</replaceable> ON <replaceable c </variablelist> </refsect1> - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP TRIGGER</computeroutput></term> - <listitem> - <para> - Message returned if the trigger was successfully dropped. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: DropTrigger: there is no trigger <replaceable class="PARAMETER">name</replaceable> on relation "<replaceable class="parameter">table</replaceable>"</computeroutput></term> - <listitem> - <para> - Message returned if the specified trigger does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - <refsect1 id="SQL-DROPTRIGGER-examples"> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index 18548fff14f..c8aa06c73a1 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_type.sgml,v 1.22 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_type.sgml,v 1.23 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -67,30 +67,6 @@ DROP TYPE <replaceable class="PARAMETER">typename</replaceable> [, ...] [ CASCAD </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP TYPE</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: RemoveType: type '<replaceable class="parameter">typename</replaceable>' does not exist</computeroutput></term> - <listitem> - <para> - Message returned if the specified type does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1 id="SQL-DROPTYPE-examples"> <title>Examples</title> diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index b17d2bccd80..4e03d10838b 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.18 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.19 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -69,30 +69,6 @@ DROP VIEW <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>DROP VIEW</computeroutput></term> - <listitem> - <para> - Message returned if the command was successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>ERROR: view <replaceable class="parameter">name</replaceable> does not exist</computeroutput></term> - <listitem> - <para> - Message returned if the specified view does not exist. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index e4d9dd6e488..bb9016d69a6 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/explain.sgml,v 1.28 2003/09/08 22:33:13 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/explain.sgml,v 1.29 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -120,16 +120,6 @@ ROLLBACK; </refsect1> <refsect1> - <title>Diagnostics</title> - - <para> - <command>EXPLAIN</command> prints the execution plan of the - specified statement from the <productname>PostgreSQL</productname> - planner. - </para> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index d6622a4ea78..9c1050b835e 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/fetch.sgml,v 1.31 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/fetch.sgml,v 1.32 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -281,21 +281,6 @@ where <replaceable class="PARAMETER">direction</replaceable> can be empty or one </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ERROR: cursor "<replaceable class="PARAMETER">cursor</replaceable>" does not exist</computeroutput></term> - <listitem> - <para> - There is no cursor with the specified name. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 08cb017454d..8c24cfb6177 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.36 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.37 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -133,21 +133,6 @@ where <replaceable class="PARAMETER">lockmode</replaceable> is one of: </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>LOCK TABLE</computeroutput></term> - <listitem> - <para> - Message returned if the lock was successfully acquired. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index 8d6edac63f6..dde512d3e3d 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/notify.sgml,v 1.21 2003/08/31 17:32:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/notify.sgml,v 1.22 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -134,21 +134,6 @@ NOTIFY <replaceable class="PARAMETER">name</replaceable> </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>NOTIFY</computeroutput></term> - <listitem> - <para> - Message returned when the commmand has executed. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index b2a0c040f6b..7777cdee8a1 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/prepare.sgml,v 1.6 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/prepare.sgml,v 1.7 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -113,21 +113,6 @@ PREPARE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>PREPARE</computeroutput></term> - <listitem> - <para> - Message returned if the statement has been prepared successfully. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 8258b460f17..b919f2c53cf 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.18 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.19 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -150,21 +150,6 @@ REINDEX { DATABASE | TABLE | INDEX } <replaceable class="PARAMETER">name</replac </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>REINDEX</computeroutput></term> - <listitem> - <para> - Message returned if the indexes were successfully recreated. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index 48d75ad9afa..58169d17de0 100644 --- a/doc/src/sgml/ref/reset.sgml +++ b/doc/src/sgml/ref/reset.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.21 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/reset.sgml,v 1.22 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -82,14 +82,6 @@ SET <replaceable class="parameter">parameter</replaceable> TO DEFAULT </refsect1> <refsect1> - <title>Diagnostics</title> - - <para> - See under the <xref linkend="sql-set" endterm="sql-set-title">. - </para> - </refsect1> - - <refsect1> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index 33c6c3f74ad..cac7a5cc5e8 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/rollback.sgml,v 1.15 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/rollback.sgml,v 1.16 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -50,36 +50,17 @@ ROLLBACK [ WORK | TRANSACTION ] </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ROLLBACK</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: ROLLBACK: no transaction in progress</computeroutput></term> - <listitem> - <para> - If there is not any transaction currently in progress. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> Use <xref linkend="SQL-COMMIT" endterm="SQL-COMMIT-TITLE"> to successfully terminate a transaction. </para> + + <para> + Issuing <command>ROLLBACK</> when not inside a transaction does + no harm, but it will provoke a warning message. + </para> </refsect1> <refsect1> @@ -102,6 +83,15 @@ ROLLBACK; WORK</literal>. Otherwise, this command is fully conforming. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-begin" endterm="sql-begin-title"></member> + <member><xref linkend="sql-commit" endterm="sql-commit-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index 03330d0b7b9..4189958e0b1 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/select_into.sgml,v 1.23 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/select_into.sgml,v 1.24 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -79,18 +79,6 @@ SELECT [ ALL | DISTINCT [ ON ( <replaceable class="PARAMETER">expression</replac </refsect1> <refsect1> - <title>Diagnostics</title> - - <para> - Refer to - <xref linkend="sql-createtable" endterm="sql-createtable-title"> - and - <xref linkend="sql-select" endterm="sql-select-title"> - for a summary of possible output messages. - </para> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index 9149d557dcf..12ebb2f61ce 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.15 2003/08/31 17:32:24 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.16 2003/09/09 18:28:53 tgl Exp $ --> <refentry id="SQL-SET-TRANSACTION"> <refmeta> <refentrytitle id="SQL-SET-TRANSACTION-TITLE">SET TRANSACTION</refentrytitle> @@ -120,10 +120,10 @@ SET default_transaction_isolation = '<replaceable>value</replaceable>' <title>Compatibility</title> <para> - Both commands are defined in the SQL standard. + Both commands are defined in the <acronym>SQL</acronym> standard. <literal>SERIALIZABLE</literal> is the default transaction - isolation level in <acronym>SQL</acronym>; in PostgreSQL it is - <literal>READ COMMITED</literal>, but you can change it as + isolation level in the standard; in PostgreSQL the default is + ordinarily <literal>READ COMMITTED</literal>, but you can change it as described above. <productname>PostgreSQL</productname> does not provide the isolation levels <literal>READ UNCOMMITTED</literal> and <literal>REPEATABLE READ</literal>. Because of multiversion diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml index bbdecc76e2d..3acaead1eb8 100644 --- a/doc/src/sgml/ref/show.sgml +++ b/doc/src/sgml/ref/show.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.31 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/show.sgml,v 1.32 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -128,22 +128,6 @@ SHOW ALL </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>ERROR: Option '<replaceable>name</replaceable>' is not recognized</computeroutput></term> - <listitem> - <para> - Message returned if <replaceable>name</replaceable> does not - stand for a known parameter. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index 26963e80489..60089d71ee9 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/start_transaction.sgml,v 1.6 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/start_transaction.sgml,v 1.7 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -48,31 +48,6 @@ START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ W </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>START TRANSACTION</computeroutput></term> - <listitem> - <para> - Message returned if successful. - </para> - </listitem> - </varlistentry> - - <varlistentry> - <term><computeroutput>WARNING: BEGIN: already a transaction in progress</computeroutput></term> - <listitem> - <para> - Message returned if there was already a transaction in progress - when the command was issued. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Compatibility</title> <para> @@ -81,6 +56,17 @@ START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ W endterm="sql-set-transaction-title">. </para> </refsect1> + + <refsect1> + <title>See Also</title> + + <simplelist type="inline"> + <member><xref linkend="sql-begin" endterm="sql-begin-title"></member> + <member><xref linkend="sql-commit" endterm="sql-commit-title"></member> + <member><xref linkend="sql-rollback" endterm="sql-rollback-title"></member> + <member><xref linkend="sql-set-transaction" endterm="sql-set-transaction-title"></member> + </simplelist> + </refsect1> </refentry> <!-- Keep this comment at the end of the file diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index d0e08e74822..3fca8691035 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.11 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v 1.12 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -49,21 +49,6 @@ TRUNCATE [ TABLE ] <replaceable class="PARAMETER">name</replaceable> </varlistentry> </variablelist> </refsect1> - - <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>TRUNCATE TABLE</computeroutput></term> - <listitem> - <para> - Message returned if the table was successfully truncated. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index 385f6db2e3a..175bcf045c1 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/unlisten.sgml,v 1.22 2003/08/31 17:32:24 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/unlisten.sgml,v 1.23 2003/09/09 18:28:53 tgl Exp $ PostgreSQL documentation --> @@ -71,29 +71,15 @@ UNLISTEN { <replaceable class="PARAMETER">name</replaceable> | * } </refsect1> <refsect1> - <title>Diagnostics</title> - - <variablelist> - <varlistentry> - <term><computeroutput>UNLISTEN</computeroutput></term> - <listitem> - <para> - Message returned when the command has executed. - </para> - </listitem> - </varlistentry> - </variablelist> - </refsect1> - - <refsect1> <title>Notes</title> <para> - You unlisten something you were not listening for; no warning or error will appear. + You may unlisten something you were not listening for; no warning or error + will appear. </para> <para> - At the end of each session, <command>UNLISTEN *</command> ist + At the end of each session, <command>UNLISTEN *</command> is automatically executed. </para> </refsect1> |