diff options
Diffstat (limited to 'doc/src/sgml/ref')
91 files changed, 325 insertions, 325 deletions
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index 4f5d401ae8..2bfc724be5 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -30,7 +30,7 @@ ABORT [ WORK | TRANSACTION ] <para> <command>ABORT</command> rolls back the current transaction and causes - all the updates made by the transaction to be discarded. + all the updates made by the transaction to be discarded. This command is identical in behavior to the standard <acronym>SQL</acronym> command <xref linkend="SQL-ROLLBACK">, diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index ae99f89856..618c432a79 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER AGGREGATE</refname> <refpurpose>change the definition of an aggregate function</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alteraggregate"> <primary>ALTER AGGREGATE</primary> </indexterm> @@ -26,7 +26,7 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable> [ , ... ] ) SET SCHEMA <replaceable>new_schema</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -47,7 +47,7 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>type</replaceable aggregate function anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index 63ff3b2ad2..0ad8fff182 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER CONVERSION</refname> <refpurpose>change the definition of a conversion</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alterconversion"> <primary>ALTER CONVERSION</primary> </indexterm> @@ -25,7 +25,7 @@ ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>new_name ALTER CONVERSION <replaceable>name</replaceable> OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -44,7 +44,7 @@ ALTER CONVERSION <replaceable>name</replaceable> OWNER TO <replaceable>new_owner anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index cd36d52467..5a975adf5c 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -51,7 +51,7 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL <para> The first form changes certain per-database settings. (See below for details.) Only the database owner or a superuser can change these settings. - </para> + </para> <para> The second form changes the name of the database. Only the database @@ -114,7 +114,7 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL to this database. -1 means no limit. </para> </listitem> - </varlistentry> + </varlistentry> <varlistentry> <term><replaceable>new_name</replaceable></term> @@ -141,7 +141,7 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL The new default tablespace of the database. </para> </listitem> - </varlistentry> + </varlistentry> <varlistentry> <term><replaceable>configuration_parameter</replaceable></term> @@ -196,7 +196,7 @@ ALTER DATABASE test SET enable_indexscan TO off; <refsect1> <title>Compatibility</title> - + <para> The <command>ALTER DATABASE</command> statement is a <productname>PostgreSQL</productname> extension. diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index 3720791449..2a5a935edc 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -32,9 +32,9 @@ ALTER DOMAIN <replaceable class="PARAMETER">name</replaceable> ALTER DOMAIN <replaceable class="PARAMETER">name</replaceable> DROP CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> [ RESTRICT | CASCADE ] ALTER DOMAIN <replaceable class="PARAMETER">name</replaceable> - OWNER TO <replaceable class="PARAMETER">new_owner</replaceable> + OWNER TO <replaceable class="PARAMETER">new_owner</replaceable> ALTER DOMAIN <replaceable class="PARAMETER">name</replaceable> - SET SCHEMA <replaceable class="PARAMETER">new_schema</replaceable> + SET SCHEMA <replaceable class="PARAMETER">new_schema</replaceable> </synopsis> </refsynopsisdiv> @@ -247,7 +247,7 @@ ALTER DOMAIN zipcode SET SCHEMA customers; <refsect1 id="SQL-ALTERDOMAIN-compatibility"> <title>Compatibility</title> - + <para> <command>ALTER DOMAIN</command> conforms to the <acronym>SQL</acronym> standard, diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index fd716b9667..22233af4aa 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER FUNCTION</refname> <refpurpose>change the definition of a function</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alterfunction"> <primary>ALTER FUNCTION</primary> </indexterm> @@ -43,7 +43,7 @@ ALTER FUNCTION <replaceable>name</replaceable> ( [ [ <replaceable class="paramet RESET ALL </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -63,7 +63,7 @@ ALTER FUNCTION <replaceable>name</replaceable> ( [ [ <replaceable class="paramet However, a superuser can alter ownership of any function anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -112,7 +112,7 @@ ALTER FUNCTION <replaceable>name</replaceable> ( [ [ <replaceable class="paramet <listitem> <para> - The data type(s) of the function's arguments (optionally + The data type(s) of the function's arguments (optionally schema-qualified), if any. </para> </listitem> diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index 55f43df0c5..63d42e1e16 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -50,7 +50,7 @@ ALTER GROUP <replaceable class="PARAMETER">group_name</replaceable> RENAME TO <r <para> The third variant changes the name of the group. This is exactly - equivalent to renaming the role with + equivalent to renaming the role with <xref linkend="sql-alterrole">. </para> </refsect1> @@ -110,7 +110,7 @@ ALTER GROUP workers DROP USER beth; <refsect1> <title>Compatibility</title> - + <para> There is no <command>ALTER GROUP</command> statement in the SQL standard. diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index bccc76fe23..69b8e5d3f8 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -41,7 +41,7 @@ ALTER INDEX <replaceable class="PARAMETER">name</replaceable> RESET ( <replaceab <term><literal>RENAME</literal></term> <listitem> <para> - The <literal>RENAME</literal> form changes the name of the index. + The <literal>RENAME</literal> form changes the name of the index. There is no effect on the stored data. </para> </listitem> @@ -53,7 +53,7 @@ ALTER INDEX <replaceable class="PARAMETER">name</replaceable> RESET ( <replaceab <para> This form changes the index's tablespace to the specified tablespace and moves the data file(s) associated with the index to the new tablespace. - See also + See also <xref linkend="SQL-CREATETABLESPACE">. </para> </listitem> @@ -177,14 +177,14 @@ ALTER INDEX distributors RENAME TO suppliers; </programlisting> </para> - <para> + <para> To move an index to a different tablespace: <programlisting> ALTER INDEX distributors SET TABLESPACE fasttablespace; </programlisting> </para> - <para> + <para> To change an index's fill factor (assuming that the index method supports it): <programlisting> diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml index f7da530d2d..ab23d624ba 100644 --- a/doc/src/sgml/ref/alter_language.sgml +++ b/doc/src/sgml/ref/alter_language.sgml @@ -72,7 +72,7 @@ ALTER [ PROCEDURAL ] LANGUAGE <replaceable>name</replaceable> OWNER TO <replacea <refsect1> <title>Compatibility</title> - + <para> There is no <command>ALTER LANGUAGE</command> statement in the SQL standard. diff --git a/doc/src/sgml/ref/alter_large_object.sgml b/doc/src/sgml/ref/alter_large_object.sgml index 6590a8ce2c..bcf532c80b 100644 --- a/doc/src/sgml/ref/alter_large_object.sgml +++ b/doc/src/sgml/ref/alter_large_object.sgml @@ -62,7 +62,7 @@ ALTER LARGE OBJECT <replaceable class="PARAMETER">large_object_oid</replaceable> <refsect1> <title>Compatibility</title> - + <para> There is no <command>ALTER LARGE OBJECT</command> statement in the SQL standard. diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml index 0cdeed573a..90c53c6c05 100644 --- a/doc/src/sgml/ref/alter_opclass.sgml +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER OPERATOR CLASS</refname> <refpurpose>change the definition of an operator class</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alteropclass"> <primary>ALTER OPERATOR CLASS</primary> </indexterm> @@ -25,7 +25,7 @@ ALTER OPERATOR CLASS <replaceable>name</replaceable> USING <replaceable class="p ALTER OPERATOR CLASS <replaceable>name</replaceable> USING <replaceable class="parameter">index_method</replaceable> OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -44,7 +44,7 @@ ALTER OPERATOR CLASS <replaceable>name</replaceable> USING <replaceable class="p class anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/alter_operator.sgml b/doc/src/sgml/ref/alter_operator.sgml index 22866424c5..615a1a66d3 100644 --- a/doc/src/sgml/ref/alter_operator.sgml +++ b/doc/src/sgml/ref/alter_operator.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER OPERATOR</refname> <refpurpose>change the definition of an operator</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alteroperator"> <primary>ALTER OPERATOR</primary> </indexterm> @@ -24,7 +24,7 @@ PostgreSQL documentation ALTER OPERATOR <replaceable>name</replaceable> ( { <replaceable>left_type</replaceable> | NONE } , { <replaceable>right_type</replaceable> | NONE } ) OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -43,7 +43,7 @@ ALTER OPERATOR <replaceable>name</replaceable> ( { <replaceable>left_type</repla However, a superuser can alter ownership of any operator anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -98,7 +98,7 @@ ALTER OPERATOR @@ (text, text) OWNER TO joe; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/alter_opfamily.sgml b/doc/src/sgml/ref/alter_opfamily.sgml index ed4877d333..1018af8412 100644 --- a/doc/src/sgml/ref/alter_opfamily.sgml +++ b/doc/src/sgml/ref/alter_opfamily.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER OPERATOR FAMILY</refname> <refpurpose>change the definition of an operator family</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alteropfamily"> <primary>ALTER OPERATOR FAMILY</primary> </indexterm> @@ -33,7 +33,7 @@ ALTER OPERATOR FAMILY <replaceable>name</replaceable> USING <replaceable class=" ALTER OPERATOR FAMILY <replaceable>name</replaceable> USING <replaceable class="parameter">index_method</replaceable> OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -81,7 +81,7 @@ ALTER OPERATOR FAMILY <replaceable>name</replaceable> USING <replaceable class=" Refer to <xref linkend="xindex"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -208,7 +208,7 @@ ALTER OPERATOR FAMILY <replaceable>name</replaceable> USING <replaceable class=" </para> </refsect1> - + <refsect1> <title>Notes</title> @@ -244,7 +244,7 @@ ALTER OPERATOR FAMILY <replaceable>name</replaceable> USING <replaceable class=" cases where an operator might or might not be lossy. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -272,7 +272,7 @@ ALTER OPERATOR FAMILY integer_ops USING btree ADD OPERATOR 4 >= (int2, int4) , OPERATOR 5 > (int2, int4) , FUNCTION 1 btint24cmp(int2, int4) ; -</programlisting> +</programlisting> <para> To remove these entries again: @@ -296,7 +296,7 @@ ALTER OPERATOR FAMILY integer_ops USING btree DROP OPERATOR 4 (int2, int4) , OPERATOR 5 (int2, int4) , FUNCTION 1 (int2, int4) ; -</programlisting> +</programlisting> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml index 4d67965e50..020b113a32 100644 --- a/doc/src/sgml/ref/alter_schema.sgml +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -81,7 +81,7 @@ ALTER SCHEMA <replaceable>name</replaceable> OWNER TO <replaceable>new_owner</re <refsect1> <title>Compatibility</title> - + <para> There is no <command>ALTER SCHEMA</command> statement in the SQL standard. diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index aa2b0ebc89..37644d83b1 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -15,7 +15,7 @@ PostgreSQL documentation <refpurpose> change the definition of a sequence generator </refpurpose> - </refnamediv> + </refnamediv> <indexterm zone="sql-altersequence"> <primary>ALTER SEQUENCE</primary> diff --git a/doc/src/sgml/ref/alter_tablespace.sgml b/doc/src/sgml/ref/alter_tablespace.sgml index 0a9a658125..0cfc26437d 100644 --- a/doc/src/sgml/ref/alter_tablespace.sgml +++ b/doc/src/sgml/ref/alter_tablespace.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER TABLESPACE</refname> <refpurpose>change the definition of a tablespace</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-altertablespace"> <primary>ALTER TABLESPACE</primary> </indexterm> @@ -27,7 +27,7 @@ ALTER TABLESPACE <replaceable>name</replaceable> SET ( <replaceable class="PARAM ALTER TABLESPACE <replaceable>name</replaceable> RESET ( <replaceable class="PARAMETER">tablespace_option</replaceable> [, ... ] ) </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -43,7 +43,7 @@ ALTER TABLESPACE <replaceable>name</replaceable> RESET ( <replaceable class="PAR (Note that superusers have these privileges automatically.) </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -114,7 +114,7 @@ ALTER TABLESPACE index_space OWNER TO mary; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/alter_tsconfig.sgml b/doc/src/sgml/ref/alter_tsconfig.sgml index a832cba546..95843ac93e 100644 --- a/doc/src/sgml/ref/alter_tsconfig.sgml +++ b/doc/src/sgml/ref/alter_tsconfig.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER TEXT SEARCH CONFIGURATION</refname> <refpurpose>change the definition of a text search configuration</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-altertsconfig"> <primary>ALTER TEXT SEARCH CONFIGURATION</primary> </indexterm> @@ -35,7 +35,7 @@ ALTER TEXT SEARCH CONFIGURATION <replaceable>name</replaceable> RENAME TO <repla ALTER TEXT SEARCH CONFIGURATION <replaceable>name</replaceable> OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -51,7 +51,7 @@ ALTER TEXT SEARCH CONFIGURATION <replaceable>name</replaceable> OWNER TO <replac <command>ALTER TEXT SEARCH CONFIGURATION</>. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -156,7 +156,7 @@ ALTER TEXT SEARCH CONFIGURATION <replaceable>name</replaceable> OWNER TO <replac <programlisting> ALTER TEXT SEARCH CONFIGURATION my_config ALTER MAPPING REPLACE english WITH swedish; -</programlisting> +</programlisting> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/alter_tsdictionary.sgml b/doc/src/sgml/ref/alter_tsdictionary.sgml index 3a591f8d90..6858b9143a 100644 --- a/doc/src/sgml/ref/alter_tsdictionary.sgml +++ b/doc/src/sgml/ref/alter_tsdictionary.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER TEXT SEARCH DICTIONARY</refname> <refpurpose>change the definition of a text search dictionary</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-altertsdictionary"> <primary>ALTER TEXT SEARCH DICTIONARY</primary> </indexterm> @@ -28,7 +28,7 @@ ALTER TEXT SEARCH DICTIONARY <replaceable>name</replaceable> RENAME TO <replacea ALTER TEXT SEARCH DICTIONARY <replaceable>name</replaceable> OWNER TO <replaceable>new_owner</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -43,7 +43,7 @@ ALTER TEXT SEARCH DICTIONARY <replaceable>name</replaceable> OWNER TO <replaceab <command>ALTER TEXT SEARCH DICTIONARY</>. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -102,7 +102,7 @@ ALTER TEXT SEARCH DICTIONARY <replaceable>name</replaceable> OWNER TO <replaceab Template-specific options can appear in any order. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -113,7 +113,7 @@ ALTER TEXT SEARCH DICTIONARY <replaceable>name</replaceable> OWNER TO <replaceab <programlisting> ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian ); -</programlisting> +</programlisting> <para> The following example command changes the language option to dutch, @@ -122,7 +122,7 @@ ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian ); <programlisting> ALTER TEXT SEARCH DICTIONARY my_dict ( language = dutch, StopWords ); -</programlisting> +</programlisting> <para> The following example command <quote>updates</> the dictionary's diff --git a/doc/src/sgml/ref/alter_tsparser.sgml b/doc/src/sgml/ref/alter_tsparser.sgml index 02382aa2c7..2de260a7ab 100644 --- a/doc/src/sgml/ref/alter_tsparser.sgml +++ b/doc/src/sgml/ref/alter_tsparser.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER TEXT SEARCH PARSER</refname> <refpurpose>change the definition of a text search parser</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-altertsparser"> <primary>ALTER TEXT SEARCH PARSER</primary> </indexterm> @@ -24,7 +24,7 @@ PostgreSQL documentation ALTER TEXT SEARCH PARSER <replaceable>name</replaceable> RENAME TO <replaceable>new_name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -38,7 +38,7 @@ ALTER TEXT SEARCH PARSER <replaceable>name</replaceable> RENAME TO <replaceable> You must be a superuser to use <command>ALTER TEXT SEARCH PARSER</>. </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/alter_tstemplate.sgml b/doc/src/sgml/ref/alter_tstemplate.sgml index bdfe18b414..b729fdee91 100644 --- a/doc/src/sgml/ref/alter_tstemplate.sgml +++ b/doc/src/sgml/ref/alter_tstemplate.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER TEXT SEARCH TEMPLATE</refname> <refpurpose>change the definition of a text search template</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-altertstemplate"> <primary>ALTER TEXT SEARCH TEMPLATE</primary> </indexterm> @@ -24,7 +24,7 @@ PostgreSQL documentation ALTER TEXT SEARCH TEMPLATE <replaceable>name</replaceable> RENAME TO <replaceable>new_name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -38,7 +38,7 @@ ALTER TEXT SEARCH TEMPLATE <replaceable>name</replaceable> RENAME TO <replaceabl You must be a superuser to use <command>ALTER TEXT SEARCH TEMPLATE</>. </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index e22934d8cc..d332c8ea14 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation ALTER USER <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replaceable class="PARAMETER">option</replaceable> [ ... ] ] <phrase>where <replaceable class="PARAMETER">option</replaceable> can be:</phrase> - + SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE @@ -33,7 +33,7 @@ ALTER USER <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replace | LOGIN | NOLOGIN | CONNECTION LIMIT <replaceable class="PARAMETER">connlimit</replaceable> | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<replaceable class="PARAMETER">password</replaceable>' - | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' + | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' ALTER USER <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable> @@ -55,7 +55,7 @@ ALTER USER <replaceable class="PARAMETER">name</replaceable> RESET ALL <refsect1> <title>Compatibility</title> - + <para> The <command>ALTER USER</command> statement is a <productname>PostgreSQL</productname> extension. The SQL standard diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index 9bedbb0e6b..0d509319a3 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -13,8 +13,8 @@ PostgreSQL documentation <refnamediv> <refname>ALTER VIEW</refname> <refpurpose>change the definition of a view</refpurpose> - </refnamediv> - + </refnamediv> + <indexterm zone="sql-alterview"> <primary>ALTER VIEW</primary> </indexterm> @@ -28,7 +28,7 @@ ALTER VIEW <replaceable class="parameter">name</replaceable> RENAME TO <replacea ALTER VIEW <replaceable class="parameter">name</replaceable> SET SCHEMA <replaceable class="parameter">new_schema</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -49,7 +49,7 @@ ALTER VIEW <replaceable class="parameter">name</replaceable> SET SCHEMA <replace However, a superuser can alter ownership of any view anyway.) </para> </refsect1> - + <refsect1> <title>Parameters</title> diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index dad8d5f351..c4d90ef8c6 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -29,7 +29,7 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ READ WRITE | READ ONLY </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -59,11 +59,11 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <para> If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if - <xref linkend="sql-set-transaction"> + <xref linkend="sql-set-transaction"> was executed. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -84,7 +84,7 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ of the other parameters to this statement. </para> </refsect1> - + <refsect1> <title>Notes</title> @@ -92,7 +92,7 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <xref linkend="sql-start-transaction"> has the same functionality as <command>BEGIN</>. </para> - + <para> Use <xref linkend="SQL-COMMIT"> or <xref linkend="SQL-ROLLBACK"> @@ -102,7 +102,7 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <para> Issuing <command>BEGIN</> when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. - To nest transactions within a transaction block, use savepoints + To nest transactions within a transaction block, use savepoints (see <xref linkend="sql-savepoint">). </para> @@ -124,7 +124,7 @@ BEGIN; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 402d681837..25e3c817eb 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -51,7 +51,7 @@ CLOSE { <replaceable class="PARAMETER">name</replaceable> | ALL } disconnects. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -110,10 +110,10 @@ CLOSE liahona; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> - + <para> <command>CLOSE</command> is fully conforming with the SQL standard. <command>CLOSE ALL</> is a <productname>PostgreSQL</> diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index f57f0b3ddd..5ce3a41fc7 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -35,7 +35,7 @@ PostgreSQL documentation <group><arg>--all</arg><arg>-a</arg></group> </cmdsynopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -63,7 +63,7 @@ PostgreSQL documentation <para> <application>clusterdb</application> accepts the following command-line arguments: - + <variablelist> <varlistentry> <term><option>-a</></term> @@ -156,7 +156,7 @@ PostgreSQL documentation </para> <para> - <application>clusterdb</application> also accepts + <application>clusterdb</application> also accepts the following command-line arguments for connection parameters: <variablelist> @@ -177,7 +177,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -215,7 +215,7 @@ PostgreSQL documentation <listitem> <para> Force <application>clusterdb</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index b5f7e3196c..d81fd72641 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -70,12 +70,12 @@ COMMENT ON </para> <para> - Comments can be viewed using <application>psql</application>'s + Comments can be viewed using <application>psql</application>'s <command>\d</command> family of commands. Other user interfaces to retrieve comments can be built atop the same built-in functions that <application>psql</application> uses, namely <function>obj_description</>, <function>col_description</>, - and <function>shobj_description</> + and <function>shobj_description</> (see <xref linkend="functions-info-comment-table">). </para> </refsect1> @@ -113,7 +113,7 @@ COMMENT ON </para> </listitem> </varlistentry> - + <varlistentry> <term><replaceable>source_type</replaceable></term> <listitem> @@ -167,7 +167,7 @@ COMMENT ON <listitem> <para> - The data type(s) of the function's arguments (optionally + The data type(s) of the function's arguments (optionally schema-qualified), if any. </para> </listitem> @@ -201,7 +201,7 @@ COMMENT ON </para> </listitem> </varlistentry> - + </variablelist> </refsect1> diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 5e03b81b93..1a039c2e3e 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation COMMIT [ WORK | TRANSACTION ] </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -34,7 +34,7 @@ COMMIT [ WORK | TRANSACTION ] and are guaranteed to be durable if a crash occurs. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -78,7 +78,7 @@ COMMIT; <refsect1> <title>Compatibility</title> - + <para> The SQL standard only specifies the two forms <literal>COMMIT</literal> and <literal>COMMIT diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index e5eaa4b1e9..930435d81a 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -29,7 +29,7 @@ COMMIT PREPARED <replaceable class="PARAMETER">transaction_id</replaceable> <title>Description</title> <para> - <command>COMMIT PREPARED</command> commits a transaction that is in + <command>COMMIT PREPARED</command> commits a transaction that is in prepared state. </para> </refsect1> @@ -76,7 +76,7 @@ COMMIT PREPARED <replaceable class="PARAMETER">transaction_id</replaceable> <para> Commit the transaction identified by the transaction identifier <literal>foobar</>: - + <programlisting> COMMIT PREPARED 'foobar'; </programlisting> diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index 73244dc577..7c2e1a9e73 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -95,7 +95,7 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( value. If there is no final function then the ending state value is returned as-is. </para> - + <para> An aggregate function can provide an initial condition, that is, an initial value for the internal state value. @@ -104,7 +104,7 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( of a constant of the state value data type. If it is not supplied then the state value starts out null. </para> - + <para> If the state transition function is declared <quote>strict</quote>, then it cannot be called with null inputs. With such a transition @@ -122,14 +122,14 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( When these types are different, you must supply a nonnull initial condition or use a nonstrict transition function. </para> - + <para> If the state transition function is not strict, then it will be called unconditionally at each input row, and must deal with null inputs and null transition values for itself. This allows the aggregate author to have full control over the aggregate's handling of null values. </para> - + <para> If the final function is declared <quote>strict</quote>, then it will not be called when the ending state value is null; instead a null result @@ -139,7 +139,7 @@ CREATE AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <function>avg</function> returns null when it sees there were zero input rows. </para> - + <para> Aggregates that behave like <function>MIN</> or <function>MAX</> can sometimes be optimized by looking into an index instead of scanning every @@ -281,7 +281,7 @@ SELECT col FROM tab ORDER BY col USING sortop LIMIT 1; written in any order, not just the order illustrated above. </para> </refsect1> - + <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 3623b935cf..4a37191222 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -22,7 +22,7 @@ CREATE [ DEFAULT ] CONVERSION <replaceable>name</replaceable> FOR <replaceable>source_encoding</replaceable> TO <replaceable>dest_encoding</replaceable> FROM <replaceable>function_name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1 id="sql-createconversion-description"> <title>Description</title> @@ -145,7 +145,7 @@ CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc; </para> </refsect1> - + <refsect1 id="sql-createconversion-compat"> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 4efc48deb5..cd6ac69eb6 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -421,7 +421,7 @@ CREATE [ OR REPLACE ] FUNCTION LOCAL</> command: the effects of such a command will persist after function exit, unless the current transaction is rolled back. </para> - + <para> See <xref linkend="sql-set"> and <xref linkend="runtime-config"> diff --git a/doc/src/sgml/ref/create_group.sgml b/doc/src/sgml/ref/create_group.sgml index 9456fc2683..3a84c8358a 100644 --- a/doc/src/sgml/ref/create_group.sgml +++ b/doc/src/sgml/ref/create_group.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation CREATE GROUP <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replaceable class="PARAMETER">option</replaceable> [ ... ] ] <phrase>where <replaceable class="PARAMETER">option</replaceable> can be:</phrase> - + SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE @@ -32,13 +32,13 @@ CREATE GROUP <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <repla | INHERIT | NOINHERIT | LOGIN | NOLOGIN | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<replaceable class="PARAMETER">password</replaceable>' - | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' + | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' | IN ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | IN GROUP <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ADMIN <replaceable class="PARAMETER">role_name</replaceable> [, ...] | USER <replaceable class="PARAMETER">role_name</replaceable> [, ...] - | SYSID <replaceable class="PARAMETER">uid</replaceable> + | SYSID <replaceable class="PARAMETER">uid</replaceable> </synopsis> </refsynopsisdiv> @@ -49,11 +49,11 @@ CREATE GROUP <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <repla <command>CREATE GROUP</command> is now an alias for <xref linkend="sql-createrole">. </para> - </refsect1> - + </refsect1> + <refsect1> <title>Compatibility</title> - + <para> There is no <command>CREATE GROUP</command> statement in the SQL standard. diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index d7372aabca..f12f13dc08 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -39,7 +39,7 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL an index. The operator class specifies that certain operators will fill particular roles or <quote>strategies</> for this data type and this index method. The operator class also specifies the support procedures to - be used by + be used by the index method when the operator class is selected for an index column. All the operators and functions used by an operator class must be defined before the operator class can be created. @@ -80,7 +80,7 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL Refer to <xref linkend="xindex"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -228,7 +228,7 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL clauses can appear in any order. </para> </refsect1> - + <refsect1> <title>Notes</title> @@ -254,7 +254,7 @@ CREATE OPERATOR CLASS <replaceable class="parameter">name</replaceable> [ DEFAUL cases where an operator might or might not be lossy. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -279,9 +279,9 @@ CREATE OPERATOR CLASS gist__int_ops FUNCTION 5 g_int_penalty (internal, internal, internal), FUNCTION 6 g_int_picksplit (internal, internal), FUNCTION 7 g_int_same (_int4, _int4, internal); -</programlisting> +</programlisting> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index b7c40d4834..90da092450 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -215,10 +215,10 @@ CREATE OPERATOR <replaceable>name</replaceable> ( arguments, use the <literal>OPERATOR()</> syntax, for example: <programlisting> COMMUTATOR = OPERATOR(myschema.===) , -</programlisting> +</programlisting> </para> </refsect1> - + <refsect1> <title>Notes</title> @@ -248,7 +248,7 @@ COMMUTATOR = OPERATOR(myschema.===) , database. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -266,10 +266,10 @@ CREATE OPERATOR === ( JOIN = area_join_procedure, HASHES, MERGES ); -</programlisting> +</programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_opfamily.sgml b/doc/src/sgml/ref/create_opfamily.sgml index 8b03932e44..5bee54419a 100644 --- a/doc/src/sgml/ref/create_opfamily.sgml +++ b/doc/src/sgml/ref/create_opfamily.sgml @@ -67,7 +67,7 @@ CREATE OPERATOR FAMILY <replaceable class="parameter">name</replaceable> USING < Refer to <xref linkend="xindex"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -92,7 +92,7 @@ CREATE OPERATOR FAMILY <replaceable class="parameter">name</replaceable> USING < </varlistentry> </variablelist> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 9e7f64118a..05f93bf9a3 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation CREATE ROLE <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replaceable class="PARAMETER">option</replaceable> [ ... ] ] <phrase>where <replaceable class="PARAMETER">option</replaceable> can be:</phrase> - + SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE @@ -33,13 +33,13 @@ CREATE ROLE <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac | LOGIN | NOLOGIN | CONNECTION LIMIT <replaceable class="PARAMETER">connlimit</replaceable> | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<replaceable class="PARAMETER">password</replaceable>' - | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' + | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' | IN ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | IN GROUP <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ADMIN <replaceable class="PARAMETER">role_name</replaceable> [, ...] | USER <replaceable class="PARAMETER">role_name</replaceable> [, ...] - | SYSID <replaceable class="PARAMETER">uid</replaceable> + | SYSID <replaceable class="PARAMETER">uid</replaceable> </synopsis> </refsynopsisdiv> @@ -301,7 +301,7 @@ CREATE ROLE <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac </listitem> </varlistentry> </variablelist> - </refsect1> + </refsect1> <refsect1> <title>Notes</title> @@ -417,14 +417,14 @@ CREATE ROLE miriam WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01'; </programlisting> </para> - <para> + <para> Create a role that can create databases and manage roles: <programlisting> CREATE ROLE admin WITH CREATEDB CREATEROLE; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> @@ -438,7 +438,7 @@ CREATE ROLE <replaceable class="PARAMETER">name</> [ WITH ADMIN <replaceable cla <command>CREATE ROLE</command>, are <productname>PostgreSQL</productname> extensions. </para> - + <para> The SQL standard defines the concepts of users and roles, but it regards them as distinct concepts and leaves all commands defining diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 3298c0ad27..7f94d24865 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -345,7 +345,7 @@ END; <listitem> <para> The <literal>OWNED BY</> clause is a <productname>PostgreSQL</> - extension. + extension. </para> </listitem> </itemizedlist> diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 86da68b8a5..3a256d1aae 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -30,7 +30,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name [ WITH [ NO ] DATA ] </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -346,5 +346,5 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS <member><xref linkend="sql-values"></member> </simplelist> </refsect1> - + </refentry> diff --git a/doc/src/sgml/ref/create_tsconfig.sgml b/doc/src/sgml/ref/create_tsconfig.sgml index 35490ac38b..c34d1c0a22 100644 --- a/doc/src/sgml/ref/create_tsconfig.sgml +++ b/doc/src/sgml/ref/create_tsconfig.sgml @@ -60,7 +60,7 @@ CREATE TEXT SEARCH CONFIGURATION <replaceable class="parameter">name</replaceabl Refer to <xref linkend="textsearch"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -94,7 +94,7 @@ CREATE TEXT SEARCH CONFIGURATION <replaceable class="parameter">name</replaceabl </varlistentry> </variablelist> </refsect1> - + <refsect1> <title>Notes</title> @@ -105,7 +105,7 @@ CREATE TEXT SEARCH CONFIGURATION <replaceable class="parameter">name</replaceabl </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_tsdictionary.sgml b/doc/src/sgml/ref/create_tsdictionary.sgml index 9cd711c4d2..2673bc5df7 100644 --- a/doc/src/sgml/ref/create_tsdictionary.sgml +++ b/doc/src/sgml/ref/create_tsdictionary.sgml @@ -53,7 +53,7 @@ CREATE TEXT SEARCH DICTIONARY <replaceable class="parameter">name</replaceable> Refer to <xref linkend="textsearch"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -103,7 +103,7 @@ CREATE TEXT SEARCH DICTIONARY <replaceable class="parameter">name</replaceable> The options can appear in any order. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -118,9 +118,9 @@ CREATE TEXT SEARCH DICTIONARY my_russian ( language = russian, stopwords = myrussian ); -</programlisting> +</programlisting> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_tsparser.sgml b/doc/src/sgml/ref/create_tsparser.sgml index 2f0fc4ea6c..7643f0852d 100644 --- a/doc/src/sgml/ref/create_tsparser.sgml +++ b/doc/src/sgml/ref/create_tsparser.sgml @@ -58,7 +58,7 @@ CREATE TEXT SEARCH PARSER <replaceable class="parameter">name</replaceable> ( Refer to <xref linkend="textsearch"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -131,7 +131,7 @@ CREATE TEXT SEARCH PARSER <replaceable class="parameter">name</replaceable> ( The arguments can appear in any order, not only the one shown above. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_tstemplate.sgml b/doc/src/sgml/ref/create_tstemplate.sgml index 6a4a7fcb5f..532419c703 100644 --- a/doc/src/sgml/ref/create_tstemplate.sgml +++ b/doc/src/sgml/ref/create_tstemplate.sgml @@ -59,7 +59,7 @@ CREATE TEXT SEARCH TEMPLATE <replaceable class="parameter">name</replaceable> ( Refer to <xref linkend="textsearch"> for further information. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -104,7 +104,7 @@ CREATE TEXT SEARCH TEMPLATE <replaceable class="parameter">name</replaceable> ( The arguments can appear in any order, not only the one shown above. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index a4aaa3adc2..2356794cd4 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation CREATE USER <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replaceable class="PARAMETER">option</replaceable> [ ... ] ] <phrase>where <replaceable class="PARAMETER">option</replaceable> can be:</phrase> - + SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE @@ -33,13 +33,13 @@ CREATE USER <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac | LOGIN | NOLOGIN | CONNECTION LIMIT <replaceable class="PARAMETER">connlimit</replaceable> | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<replaceable class="PARAMETER">password</replaceable>' - | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' + | VALID UNTIL '<replaceable class="PARAMETER">timestamp</replaceable>' | IN ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | IN GROUP <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ROLE <replaceable class="PARAMETER">role_name</replaceable> [, ...] | ADMIN <replaceable class="PARAMETER">role_name</replaceable> [, ...] | USER <replaceable class="PARAMETER">role_name</replaceable> [, ...] - | SYSID <replaceable class="PARAMETER">uid</replaceable> + | SYSID <replaceable class="PARAMETER">uid</replaceable> </synopsis> </refsynopsisdiv> @@ -56,10 +56,10 @@ CREATE USER <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac <command>CREATE ROLE</command>. </para> </refsect1> - + <refsect1> <title>Compatibility</title> - + <para> The <command>CREATE USER</command> statement is a <productname>PostgreSQL</productname> extension. The SQL standard diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index 520a108638..633881d6f7 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -193,7 +193,7 @@ PostgreSQL documentation </para> <para> - The options <option>-D</option>, <option>-l</option>, <option>-E</option>, + The options <option>-D</option>, <option>-l</option>, <option>-E</option>, <option>-O</option>, and <option>-T</option> correspond to options of the underlying SQL command <xref linkend="SQL-CREATEDATABASE">; see there for more information @@ -210,8 +210,8 @@ PostgreSQL documentation <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the - server is running. If the value begins with a slash, it is used + Specifies the host name of the machine on which the + server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -222,7 +222,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or the local Unix domain socket file + Specifies the TCP port or the local Unix domain socket file extension on which the server is listening for connections. </para> </listitem> @@ -259,7 +259,7 @@ PostgreSQL documentation <listitem> <para> Force <application>createdb</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> diff --git a/doc/src/sgml/ref/createlang.sgml b/doc/src/sgml/ref/createlang.sgml index e157396de7..36bd318e1d 100644 --- a/doc/src/sgml/ref/createlang.sgml +++ b/doc/src/sgml/ref/createlang.sgml @@ -35,12 +35,12 @@ PostgreSQL documentation </cmdsynopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> <para> - <application>createlang</application> is a utility for adding a new + <application>createlang</application> is a utility for adding a new programming language to a <productname>PostgreSQL</productname> database. <application>createlang</application> is just a wrapper around the <xref linkend="sql-createlanguage"> @@ -54,7 +54,7 @@ PostgreSQL documentation <para> <application>createlang</application> accepts the following command-line arguments: - + <variablelist> <varlistentry> <term><replaceable class="parameter">langname</replaceable></term> @@ -123,18 +123,18 @@ PostgreSQL documentation </para> <para> - <application>createlang</application> also accepts + <application>createlang</application> also accepts the following command-line arguments for connection parameters: - + <variablelist> <varlistentry> <term><option>-h <replaceable class="parameter">host</replaceable></></term> <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the + Specifies the host name of the machine on which the server - is running. If the value begins with a slash, it is used + is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -145,7 +145,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -183,7 +183,7 @@ PostgreSQL documentation <listitem> <para> Force <application>createlang</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> @@ -251,7 +251,7 @@ PostgreSQL documentation Use <xref linkend="app-droplang"> to remove a language. </para> </refsect1> - + <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml index 681482e458..08c82e0752 100644 --- a/doc/src/sgml/ref/createuser.sgml +++ b/doc/src/sgml/ref/createuser.sgml @@ -27,12 +27,12 @@ PostgreSQL documentation <arg><replaceable>username</replaceable></arg> </cmdsynopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> <para> - <application>createuser</application> creates a + <application>createuser</application> creates a new <productname>PostgreSQL</productname> user (or more precisely, a role). Only superusers and users with <literal>CREATEROLE</> privilege can create new users, so <application>createuser</application> must be @@ -74,7 +74,7 @@ PostgreSQL documentation <productname>PostgreSQL</productname> installation. </para> </listitem> - </varlistentry> + </varlistentry> <varlistentry> <term><option>-c <replaceable class="parameter">number</replaceable></></term> @@ -275,16 +275,16 @@ PostgreSQL documentation <para> <application>createuser</application> also accepts the following command-line arguments for connection parameters: - + <variablelist> <varlistentry> <term><option>-h <replaceable class="parameter">host</replaceable></></term> <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the + Specifies the host name of the machine on which the server - is running. If the value begins with a slash, it is used + is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -295,7 +295,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> diff --git a/doc/src/sgml/ref/drop_cast.sgml b/doc/src/sgml/ref/drop_cast.sgml index 22d3ad5839..139e89daca 100644 --- a/doc/src/sgml/ref/drop_cast.sgml +++ b/doc/src/sgml/ref/drop_cast.sgml @@ -21,7 +21,7 @@ DROP CAST [ IF EXISTS ] (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) [ CASCADE | RESTRICT ] </synopsis> </refsynopsisdiv> - + <refsect1 id="sql-dropcast-description"> <title>Description</title> @@ -45,7 +45,7 @@ DROP CAST [ IF EXISTS ] (<replaceable>source_type</replaceable> AS <replaceable> <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the cast does not exist. A notice is issued + Do not throw an error if the cast does not exist. A notice is issued in this case. </para> </listitem> @@ -95,7 +95,7 @@ DROP CAST (text AS int); </programlisting> </para> </refsect1> - + <refsect1 id="sql-dropcast-compat"> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index 2d51be1c99..79e159dcbd 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -21,7 +21,7 @@ DROP CONVERSION [ IF EXISTS ] <replaceable>name</replaceable> [ CASCADE | RESTRICT ] </synopsis> </refsynopsisdiv> - + <refsect1 id="sql-dropconversion-description"> <title>Description</title> @@ -39,7 +39,7 @@ DROP CONVERSION [ IF EXISTS ] <replaceable>name</replaceable> [ CASCADE | RESTRI <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the conversion does not exist. + Do not throw an error if the conversion does not exist. A notice is issued in this case. </para> </listitem> diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index e6b641a72b..89ee7b2507 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation DROP DATABASE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -34,7 +34,7 @@ DROP DATABASE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to <literal>postgres</literal> or any - other database to issue this command.) + other database to issue this command.) </para> <para> @@ -50,7 +50,7 @@ DROP DATABASE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the database does not exist. A notice is issued + Do not throw an error if the database does not exist. A notice is issued in this case. </para> </listitem> diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index 6fc2f51186..689633f6dd 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -42,7 +42,7 @@ DROP DOMAIN [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, . <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the domain does not exist. A notice is issued + Do not throw an error if the domain does not exist. A notice is issued in this case. </para> </listitem> @@ -93,10 +93,10 @@ DROP DOMAIN box; <refsect1 id="SQL-DROPDOMAIN-compatibility"> <title>Compatibility</title> - + <para> This command conforms to the SQL standard, except for the - <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> + <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> extension. </para> </refsect1> diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index c8a3eec713..a26b4ff66c 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -46,7 +46,7 @@ DROP FUNCTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ( <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the function does not exist. A notice is issued + Do not throw an error if the function does not exist. A notice is issued in this case. </para> </listitem> @@ -96,7 +96,7 @@ DROP FUNCTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ( <listitem> <para> - The data type(s) of the function's arguments (optionally + The data type(s) of the function's arguments (optionally schema-qualified), if any. </para> </listitem> @@ -138,7 +138,7 @@ DROP FUNCTION sqrt(integer); <refsect1 id="SQL-DROPFUNCTION-compatibility"> <title>Compatibility</title> - + <para> A <command>DROP FUNCTION</command> statement is defined in the SQL standard, but it is not compatible with this command. diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index 75b6c6ba79..fb4ce2bf9c 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -43,7 +43,7 @@ DROP INDEX [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, .. <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the index does not exist. A notice is issued + Do not throw an error if the index does not exist. A notice is issued in this case. </para> </listitem> diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 0406f95f1d..6bf900e254 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -34,7 +34,7 @@ DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="PARAMETER">name</ or the owner of the language to use <command>DROP LANGUAGE</>. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -44,7 +44,7 @@ DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="PARAMETER">name</ <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the language does not exist. A notice is issued + Do not throw an error if the language does not exist. A notice is issued in this case. </para> </listitem> @@ -81,7 +81,7 @@ DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="PARAMETER">name</ </varlistentry> </variablelist> </refsect1> - + <refsect1> <title>Examples</title> @@ -94,7 +94,7 @@ DROP LANGUAGE plsample; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index 071eed003b..a20293ce97 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP OPERATOR CLASS</refname> <refpurpose>remove an operator class</refpurpose> </refnamediv> - + <indexterm zone="sql-dropopclass"> <primary>DROP OPERATOR CLASS</primary> </indexterm> @@ -40,7 +40,7 @@ DROP OPERATOR CLASS [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceab <literal>CASCADE</> for the drop to complete. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -50,7 +50,7 @@ DROP OPERATOR CLASS [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceab <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the operator class does not exist. A notice is issued + Do not throw an error if the operator class does not exist. A notice is issued in this case. </para> </listitem> @@ -94,7 +94,7 @@ DROP OPERATOR CLASS [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceab </varlistentry> </variablelist> </refsect1> - + <refsect1> <title>Notes</title> @@ -124,7 +124,7 @@ DROP OPERATOR CLASS widget_ops USING btree; such indexes along with the operator class. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index 886946a22a..aa227ab8d8 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP OPERATOR</refname> <refpurpose>remove an operator</refpurpose> </refnamediv> - + <indexterm zone="sql-dropoperator"> <primary>DROP OPERATOR</primary> </indexterm> @@ -34,7 +34,7 @@ DROP OPERATOR [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ( of the operator. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -44,7 +44,7 @@ DROP OPERATOR [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ( <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the operator does not exist. A notice is issued + Do not throw an error if the operator does not exist. A notice is issued in this case. </para> </listitem> @@ -126,7 +126,7 @@ DROP OPERATOR ! (bigint, none); </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_opfamily.sgml b/doc/src/sgml/ref/drop_opfamily.sgml index ea8a6b76f7..4cc67ef053 100644 --- a/doc/src/sgml/ref/drop_opfamily.sgml +++ b/doc/src/sgml/ref/drop_opfamily.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP OPERATOR FAMILY</refname> <refpurpose>remove an operator family</refpurpose> </refnamediv> - + <indexterm zone="sql-dropopfamily"> <primary>DROP OPERATOR FAMILY</primary> </indexterm> @@ -41,7 +41,7 @@ DROP OPERATOR FAMILY [ IF EXISTS ] <replaceable class="PARAMETER">name</replacea <literal>CASCADE</> for the drop to complete. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -111,7 +111,7 @@ DROP OPERATOR FAMILY float_ops USING btree; drop such indexes along with the operator family. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index c990fa4018..a3a999437c 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -61,7 +61,7 @@ DROP ROLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the role does not exist. A notice is issued + Do not throw an error if the role does not exist. A notice is issued in this case. </para> </listitem> @@ -99,10 +99,10 @@ DROP ROLE jonathan; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> - + <para> The SQL standard defines <command>DROP ROLE</command>, but it allows only one role to be dropped at a time, and it specifies different diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index d948efdfd0..fd24c70127 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -42,7 +42,7 @@ DROP RULE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ON <re <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the rule does not exist. A notice is issued + Do not throw an error if the rule does not exist. A notice is issued in this case. </para> </listitem> @@ -99,7 +99,7 @@ DROP RULE newrule ON mytable; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index 1e2e2b7562..50fb09b965 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -38,7 +38,7 @@ DROP SCHEMA [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, . even if he does not own some of the objects within the schema. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -47,7 +47,7 @@ DROP SCHEMA [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, . <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the schema does not exist. A notice is issued + Do not throw an error if the schema does not exist. A notice is issued in this case. </para> </listitem> @@ -96,15 +96,15 @@ DROP SCHEMA mystuff CASCADE; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> - + <para> <command>DROP SCHEMA</command> is fully conforming with the SQL standard, except that the standard only allows one schema to be - dropped per command, and apart from the - <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> + dropped per command, and apart from the + <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> extension. </para> </refsect1> diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index 53e7834bed..84a8ca188b 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -33,7 +33,7 @@ DROP SEQUENCE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, generators. A sequence can only be dropped by its owner or a superuser. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -42,7 +42,7 @@ DROP SEQUENCE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the sequence does not exist. A notice is issued + Do not throw an error if the sequence does not exist. A notice is issued in this case. </para> </listitem> @@ -89,16 +89,16 @@ DROP SEQUENCE serial; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> <para> <command>DROP SEQUENCE</command> conforms to the <acronym>SQL</acronym> standard, except that the standard only allows one - sequence to be dropped per command, and apart from the - <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> - extension. + sequence to be dropped per command, and apart from the + <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> + extension. </para> </refsect1> diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index 4b47ea74f7..7fa7e32ee0 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation DROP TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ] </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -45,7 +45,7 @@ DROP TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, .. constraint, not the other table entirely.) </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -54,7 +54,7 @@ DROP TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, .. <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the table does not exist. A notice is issued + Do not throw an error if the table does not exist. A notice is issued in this case. </para> </listitem> @@ -95,7 +95,7 @@ DROP TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, .. <title>Examples</title> <para> - To destroy two tables, <literal>films</literal> and + To destroy two tables, <literal>films</literal> and <literal>distributors</literal>: <programlisting> @@ -103,14 +103,14 @@ DROP TABLE films, distributors; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> <para> This command conforms to the SQL standard, except that the standard only - allows one table to be dropped per command, and apart from the - <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> + allows one table to be dropped per command, and apart from the + <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> extension. </para> </refsect1> diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index 4c5302968d..aa80be3c6f 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -53,7 +53,7 @@ DROP TABLESPACE [ IF EXISTS ] <replaceable class="PARAMETER">tablespace_name</re <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the tablespace does not exist. A notice is issued + Do not throw an error if the tablespace does not exist. A notice is issued in this case. </para> </listitem> diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index dcabff4291..444c928d1e 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -12,8 +12,8 @@ PostgreSQL documentation <refnamediv> <refname>DROP TRIGGER</refname> - <refpurpose>remove a trigger</refpurpose> - </refnamediv> + <refpurpose>remove a trigger</refpurpose> + </refnamediv> <indexterm zone="sql-droptrigger"> <primary>DROP TRIGGER</primary> @@ -44,7 +44,7 @@ DROP TRIGGER [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> ON <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the trigger does not exist. A notice is issued + Do not throw an error if the trigger does not exist. A notice is issued in this case. </para> </listitem> @@ -102,10 +102,10 @@ DROP TRIGGER if_dist_exists ON films; </programlisting> </para> </refsect1> - + <refsect1 id="SQL-DROPTRIGGER-compatibility"> <title>Compatibility</title> - + <para> The <command>DROP TRIGGER</command> statement in <productname>PostgreSQL</productname> is incompatible with the SQL diff --git a/doc/src/sgml/ref/drop_tsconfig.sgml b/doc/src/sgml/ref/drop_tsconfig.sgml index 4d7ef37595..8fcb0d3d5e 100644 --- a/doc/src/sgml/ref/drop_tsconfig.sgml +++ b/doc/src/sgml/ref/drop_tsconfig.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP TEXT SEARCH CONFIGURATION</refname> <refpurpose>remove a text search configuration</refpurpose> </refnamediv> - + <indexterm zone="sql-droptsconfig"> <primary>DROP TEXT SEARCH CONFIGURATION</primary> </indexterm> @@ -34,7 +34,7 @@ DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] <replaceable class="PARAMETER">name configuration. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -97,7 +97,7 @@ DROP TEXT SEARCH CONFIGURATION my_english; drop such indexes along with the text search configuration. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_tsdictionary.sgml b/doc/src/sgml/ref/drop_tsdictionary.sgml index 70e237028a..12b88cd7d3 100644 --- a/doc/src/sgml/ref/drop_tsdictionary.sgml +++ b/doc/src/sgml/ref/drop_tsdictionary.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP TEXT SEARCH DICTIONARY</refname> <refpurpose>remove a text search dictionary</refpurpose> </refnamediv> - + <indexterm zone="sql-droptsdictionary"> <primary>DROP TEXT SEARCH DICTIONARY</primary> </indexterm> @@ -34,7 +34,7 @@ DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] <replaceable class="PARAMETER">name</r dictionary. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -96,7 +96,7 @@ DROP TEXT SEARCH DICTIONARY english; drop such configurations along with the dictionary. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_tsparser.sgml b/doc/src/sgml/ref/drop_tsparser.sgml index b5ff9336cf..860d7e20bb 100644 --- a/doc/src/sgml/ref/drop_tsparser.sgml +++ b/doc/src/sgml/ref/drop_tsparser.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP TEXT SEARCH PARSER</refname> <refpurpose>remove a text search parser</refpurpose> </refnamediv> - + <indexterm zone="sql-droptsparser"> <primary>DROP TEXT SEARCH PARSER</primary> </indexterm> @@ -33,7 +33,7 @@ DROP TEXT SEARCH PARSER [ IF EXISTS ] <replaceable class="PARAMETER">name</repla parser. You must be a superuser to use this command. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -94,7 +94,7 @@ DROP TEXT SEARCH PARSER my_parser; drop such configurations along with the parser. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_tstemplate.sgml b/doc/src/sgml/ref/drop_tstemplate.sgml index 4bb246ce6c..8ad419d3ed 100644 --- a/doc/src/sgml/ref/drop_tstemplate.sgml +++ b/doc/src/sgml/ref/drop_tstemplate.sgml @@ -14,7 +14,7 @@ PostgreSQL documentation <refname>DROP TEXT SEARCH TEMPLATE</refname> <refpurpose>remove a text search template</refpurpose> </refnamediv> - + <indexterm zone="sql-droptstemplate"> <primary>DROP TEXT SEARCH TEMPLATE</primary> </indexterm> @@ -33,7 +33,7 @@ DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] <replaceable class="PARAMETER">name</rep template. You must be a superuser to use this command. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -95,7 +95,7 @@ DROP TEXT SEARCH TEMPLATE thesaurus; drop such dictionaries along with the template. </para> </refsect1> - + <refsect1> <title>Compatibility</title> diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index 76e31517a1..9de13068a7 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -33,7 +33,7 @@ DROP TYPE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... Only the owner of a type can remove it. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -42,7 +42,7 @@ DROP TYPE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the type does not exist. A notice is issued + Do not throw an error if the type does not exist. A notice is issued in this case. </para> </listitem> @@ -78,7 +78,7 @@ DROP TYPE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... </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 5f44076c52..5d7e413c0b 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -33,7 +33,7 @@ DROP VIEW [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... this command you must be the owner of the view. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -42,7 +42,7 @@ DROP VIEW [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ... <term><literal>IF EXISTS</literal></term> <listitem> <para> - Do not throw an error if the view does not exist. A notice is issued + Do not throw an error if the view does not exist. A notice is issued in this case. </para> </listitem> @@ -89,15 +89,15 @@ DROP VIEW kinds; </programlisting> </para> </refsect1> - + <refsect1> <title>Compatibility</title> <para> This command conforms to the SQL standard, except that the standard only - allows one view to be dropped per command, and apart from the - <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> - extension. + allows one view to be dropped per command, and apart from the + <literal>IF EXISTS</> option, which is a <productname>PostgreSQL</> + extension. </para> </refsect1> diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index ef75c35fcf..c169d7fcd4 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -121,9 +121,9 @@ PostgreSQL documentation <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the + Specifies the host name of the machine on which the server - is running. If the value begins with a slash, it is used + is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -134,7 +134,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -172,7 +172,7 @@ PostgreSQL documentation <listitem> <para> Force <application>dropdb</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> diff --git a/doc/src/sgml/ref/droplang.sgml b/doc/src/sgml/ref/droplang.sgml index f0e2bf9594..c9d034a4c1 100644 --- a/doc/src/sgml/ref/droplang.sgml +++ b/doc/src/sgml/ref/droplang.sgml @@ -34,14 +34,14 @@ PostgreSQL documentation <arg choice="plain"><replaceable>dbname</replaceable></arg> </cmdsynopsis> </refsynopsisdiv> - + <refsect1 id="R1-APP-DROPLANG-1"> <title> Description </title> <para> - <application>droplang</application> is a utility for removing an + <application>droplang</application> is a utility for removing an existing programming language from a <productname>PostgreSQL</productname> database. <application>droplang</application> can drop any procedural language, @@ -63,7 +63,7 @@ PostgreSQL documentation <para> <application>droplang</application> accepts the following command line arguments: - + <variablelist> <varlistentry> <term><replaceable class="parameter">langname</replaceable></term> @@ -131,18 +131,18 @@ PostgreSQL documentation </para> <para> - <application>droplang</application> also accepts + <application>droplang</application> also accepts the following command line arguments for connection parameters: - + <variablelist> <varlistentry> <term><option>-h <replaceable class="parameter">host</replaceable></></term> <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the + Specifies the host name of the machine on which the server - is running. If host begins with a slash, it is used + is running. If host begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -153,7 +153,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the Internet TCP/IP port or local Unix domain socket file + Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -191,7 +191,7 @@ PostgreSQL documentation <listitem> <para> Force <application>droplang</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> @@ -259,7 +259,7 @@ PostgreSQL documentation Use <xref linkend="app-createlang"> to add a language. </para> </refsect1> - + <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index ecf6d49563..0786612820 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -61,7 +61,7 @@ PostgreSQL documentation <term><replaceable class="parameter">username</replaceable></term> <listitem> <para> - Specifies the name of the <productname>PostgreSQL</productname> user to be removed. + Specifies the name of the <productname>PostgreSQL</productname> user to be removed. You will be prompted for a name if none is specified on the command line. </para> </listitem> @@ -115,16 +115,16 @@ PostgreSQL documentation <para> <application>dropuser</application> also accepts the following command-line arguments for connection parameters: - + <variablelist> <varlistentry> <term><option>-h <replaceable class="parameter">host</replaceable></></term> <term><option>--host <replaceable class="parameter">host</replaceable></></term> <listitem> <para> - Specifies the host name of the machine on which the + Specifies the host name of the machine on which the server - is running. If the value begins with a slash, it is used + is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. </para> </listitem> @@ -135,7 +135,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -173,7 +173,7 @@ PostgreSQL documentation <listitem> <para> Force <application>dropuser</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index a97041a06e..2a783ea477 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -153,7 +153,7 @@ PostgreSQL documentation </para> </listitem> </varlistentry> - + <varlistentry> <term><option>-v</option></term> <listitem> diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index 7de7232419..85248b4c2f 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -24,7 +24,7 @@ PostgreSQL documentation END [ WORK | TRANSACTION ] </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -36,7 +36,7 @@ END [ WORK | TRANSACTION ] that is equivalent to <xref linkend="sql-commit">. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -80,7 +80,7 @@ END; <refsect1> <title>Compatibility</title> - + <para> <command>END</command> is a <productname>PostgreSQL</productname> extension that provides functionality equivalent to <xref diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index 40b515a208..1e3cbea08f 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -378,7 +378,7 @@ FETCH PRIOR FROM liahona; CLOSE liahona; COMMIT WORK; </programlisting> - </para> + </para> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index 8ecacaada2..04f047b063 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -47,8 +47,8 @@ PostgreSQL documentation which the database data will live, generating the shared catalog tables (tables that belong to the whole cluster rather than to any particular database), and creating the <literal>template1</literal> - and <literal>postgres</literal> databases. When you later create a - new database, everything in the <literal>template1</literal> database is + and <literal>postgres</literal> databases. When you later create a + new database, everything in the <literal>template1</literal> database is copied. (Therefore, anything installed in <literal>template1</literal> is automatically copied into each database created later.) The <literal>postgres</literal> database is a default database meant @@ -89,7 +89,7 @@ PostgreSQL documentation <option>--lc-collate</option> and <option>--lc-ctype</option> options. Collation orders other than <literal>C</> or <literal>POSIX</> also have a performance penalty. For these reasons it is important to choose the - right locale when running <command>initdb</command>. + right locale when running <command>initdb</command>. </para> <para> @@ -120,7 +120,7 @@ PostgreSQL documentation <para> This option specifies the authentication method for local users used in <filename>pg_hba.conf</>. Do not use <literal>trust</> - unless you trust all local users on your system. <literal>Trust</> + unless you trust all local users on your system. <literal>Trust</> is the default for ease of installation. </para> </listitem> @@ -210,7 +210,7 @@ PostgreSQL documentation </para> </listitem> </varlistentry> - + <varlistentry> <term><option>-W</option></term> <term><option>--pwprompt</option></term> diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index baaf31ad8a..0c960aa622 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -76,7 +76,7 @@ LOCK [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ... — but it won't ensure that what the transaction reads corresponds to the latest committed values. </para> - + <para> If a transaction of this sort is going to change the data in the table, then it should use <literal>SHARE ROW EXCLUSIVE</> lock mode @@ -189,7 +189,7 @@ LOCK [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ... reference documentation. </para> </refsect1> - + <refsect1> <title>Examples</title> @@ -200,10 +200,10 @@ LOCK [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ... <programlisting> BEGIN WORK; LOCK TABLE films IN SHARE MODE; -SELECT id FROM films +SELECT id FROM films WHERE name = 'Star Wars: Episode I - The Phantom Menace'; -- Do ROLLBACK if record was not returned -INSERT INTO films_user_comments VALUES +INSERT INTO films_user_comments VALUES (_id_, 'GREAT! I was waiting for it for so long!'); COMMIT WORK; </programlisting> diff --git a/doc/src/sgml/ref/move.sgml b/doc/src/sgml/ref/move.sgml index deffbe6fa8..209d5fd823 100644 --- a/doc/src/sgml/ref/move.sgml +++ b/doc/src/sgml/ref/move.sgml @@ -40,7 +40,7 @@ MOVE [ <replaceable class="PARAMETER">direction</replaceable> [ FROM | IN ] ] <r </para> <para> - The parameters for the <command>MOVE</command> command are identical to + The parameters for the <command>MOVE</command> command are identical to those of the <command>FETCH</command> command; refer to <xref linkend="sql-fetch"> for details on syntax and usage. diff --git a/doc/src/sgml/ref/pg_config-ref.sgml b/doc/src/sgml/ref/pg_config-ref.sgml index 7af2a4e31a..2246b74df0 100644 --- a/doc/src/sgml/ref/pg_config-ref.sgml +++ b/doc/src/sgml/ref/pg_config-ref.sgml @@ -48,7 +48,7 @@ <para> Print the location of user executables. Use this, for example, to find the <command>psql</> program. This is normally also the location - where the <filename>pg_config</> program resides. + where the <filename>pg_config</> program resides. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/pg_controldata.sgml b/doc/src/sgml/ref/pg_controldata.sgml index 2cc0dd58d5..50b1909499 100644 --- a/doc/src/sgml/ref/pg_controldata.sgml +++ b/doc/src/sgml/ref/pg_controldata.sgml @@ -31,7 +31,7 @@ PostgreSQL documentation <para> <command>pg_controldata</command> prints information initialized during <command>initdb</>, such as the catalog version. - It also shows information about write-ahead logging and checkpoint + It also shows information about write-ahead logging and checkpoint processing. This information is cluster-wide, and not specific to any one database. </para> @@ -39,7 +39,7 @@ PostgreSQL documentation <para> This utility can only be run by the user who initialized the cluster because it requires read access to the data directory. - You can specify the data directory on the command line, or use + You can specify the data directory on the command line, or use the environment variable <envar>PGDATA</>. This utility supports the options <literal>-V</> and <literal>--version</>, which print the <application>pg_controldata</application> version and exit. It also diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 68dcc35c50..c1fe50d160 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -552,7 +552,7 @@ PostgreSQL documentation <para> <application>pg_dumpall</application> requires all needed - tablespace directories to exist before the restore; otherwise, + tablespace directories to exist before the restore; otherwise, database creation will fail for databases in non-default locations. </para> diff --git a/doc/src/sgml/ref/pg_resetxlog.sgml b/doc/src/sgml/ref/pg_resetxlog.sgml index 2d9f205345..05c7af3abf 100644 --- a/doc/src/sgml/ref/pg_resetxlog.sgml +++ b/doc/src/sgml/ref/pg_resetxlog.sgml @@ -180,7 +180,7 @@ PostgreSQL documentation </para> <para> - The <literal>-V</> and <literal>--version</> options print + The <literal>-V</> and <literal>--version</> options print the <application>pg_resetxlog</application> version and exit. The options <literal>-?</> and <literal>--help</> show supported arguments, and exit. @@ -192,7 +192,7 @@ PostgreSQL documentation <title>Notes</title> <para> - This command must not be used when the server is + This command must not be used when the server is running. <command>pg_resetxlog</command> will refuse to start up if it finds a server lock file in the data directory. If the server crashed then a lock file might have been left diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index fb1910a2dc..48574d3081 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -99,7 +99,7 @@ PostgreSQL documentation <refsect2> <title>General Purpose</title> - + <variablelist> <varlistentry> <term><option>-A 0|1</option></term> @@ -338,7 +338,7 @@ PostgreSQL documentation <term><option>--describe-config</option></term> <listitem> <para> - This option dumps out the server's internal configuration variables, + This option dumps out the server's internal configuration variables, descriptions, and defaults in tab-delimited <command>COPY</> format. It is designed primarily for use by administration tools. </para> @@ -371,7 +371,7 @@ PostgreSQL documentation <literal>n</literal>, <literal>m</literal>, and <literal>h</literal> disable nested-loop, merge and hash joins respectively. </para> - + <para> Neither sequential scans nor nested-loop joins can be disabled completely; the <literal>-fs</literal> and @@ -651,7 +651,7 @@ PostgreSQL documentation start and shut down the <command>postgres</command> server safely and comfortably. </para> - + <para> If at all possible, <emphasis>do not</emphasis> use <literal>SIGKILL</literal> to kill the main diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index e6c8ef3b10..6f18a97ca5 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -62,7 +62,7 @@ PREPARE <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable class <para> Prepared statements only last for the duration of the current database session. When the session ends, the prepared statement is - forgotten, so it must be recreated before being used again. This + forgotten, so it must be recreated before being used again. This also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use. The prepared statement can be diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index ddbf0ca65f..fa4d7b41c7 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -41,7 +41,7 @@ PostgreSQL documentation <arg><replaceable>dbname</replaceable></arg> </cmdsynopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -66,7 +66,7 @@ PostgreSQL documentation <para> <application>reindexdb</application> accepts the following command-line arguments: - + <variablelist> <varlistentry> <term><option>-a</></term> @@ -170,7 +170,7 @@ PostgreSQL documentation </para> <para> - <application>reindexdb</application> also accepts + <application>reindexdb</application> also accepts the following command-line arguments for connection parameters: <variablelist> @@ -191,7 +191,7 @@ PostgreSQL documentation <term><option>--port <replaceable class="parameter">port</replaceable></></term> <listitem> <para> - Specifies the TCP port or local Unix domain socket file + Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. </para> @@ -229,7 +229,7 @@ PostgreSQL documentation <listitem> <para> Force <application>reindexdb</application> to prompt for a - password before connecting to a database. + password before connecting to a database. </para> <para> diff --git a/doc/src/sgml/ref/release_savepoint.sgml b/doc/src/sgml/ref/release_savepoint.sgml index 3c2fff7d2a..99b16d48e9 100644 --- a/doc/src/sgml/ref/release_savepoint.sgml +++ b/doc/src/sgml/ref/release_savepoint.sgml @@ -29,7 +29,7 @@ PostgreSQL documentation RELEASE [ SAVEPOINT ] <replaceable>savepoint_name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -107,7 +107,7 @@ COMMIT; <refsect1> <title>Compatibility</title> - + <para> This command conforms to the <acronym>SQL</> standard. The standard specifies that the key word <literal>SAVEPOINT</literal> is diff --git a/doc/src/sgml/ref/rollback_prepared.sgml b/doc/src/sgml/ref/rollback_prepared.sgml index 265b483024..9dfe1416e0 100644 --- a/doc/src/sgml/ref/rollback_prepared.sgml +++ b/doc/src/sgml/ref/rollback_prepared.sgml @@ -29,7 +29,7 @@ ROLLBACK PREPARED <replaceable class="PARAMETER">transaction_id</replaceable> <title>Description</title> <para> - <command>ROLLBACK PREPARED</command> rolls back a transaction that is in + <command>ROLLBACK PREPARED</command> rolls back a transaction that is in prepared state. </para> </refsect1> @@ -76,7 +76,7 @@ ROLLBACK PREPARED <replaceable class="PARAMETER">transaction_id</replaceable> <para> Roll back the transaction identified by the transaction identifier <literal>foobar</>: - + <programlisting> ROLLBACK PREPARED 'foobar'; </programlisting> diff --git a/doc/src/sgml/ref/savepoint.sgml b/doc/src/sgml/ref/savepoint.sgml index d51cc7b4a7..2ea873bfc7 100644 --- a/doc/src/sgml/ref/savepoint.sgml +++ b/doc/src/sgml/ref/savepoint.sgml @@ -29,7 +29,7 @@ PostgreSQL documentation SAVEPOINT <replaceable>savepoint_name</replaceable> </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -44,7 +44,7 @@ SAVEPOINT <replaceable>savepoint_name</replaceable> the transaction state to what it was at the time of the savepoint. </para> </refsect1> - + <refsect1> <title>Parameters</title> @@ -110,7 +110,7 @@ COMMIT; <refsect1> <title>Compatibility</title> - + <para> SQL requires a savepoint to be destroyed automatically when another savepoint with the same name is established. In diff --git a/doc/src/sgml/ref/security_label.sgml b/doc/src/sgml/ref/security_label.sgml index 4a3747ceec..5bddaec6c6 100644 --- a/doc/src/sgml/ref/security_label.sgml +++ b/doc/src/sgml/ref/security_label.sgml @@ -146,7 +146,7 @@ SECURITY LABEL [ FOR <replaceable class="PARAMETER">provider</replaceable> ] ON <listitem> <para> - The data type(s) of the function's arguments (optionally + The data type(s) of the function's arguments (optionally schema-qualified), if any. </para> </listitem> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index d55760f189..3ef700b60d 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -25,7 +25,7 @@ SET [ SESSION | LOCAL ] <replaceable class="PARAMETER">configuration_parameter</ SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="PARAMETER">timezone</replaceable> | LOCAL | DEFAULT } </synopsis> </refsynopsisdiv> - + <refsect1> <title>Description</title> @@ -271,7 +271,7 @@ SELECT setseed(<replaceable>value</replaceable>); system view to perform the equivalent of <command>SET</>. </para> </refsect1> - + <refsect1> <title>Examples</title> diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 23638c766f..552c80cf06 100644 --- a/doc/src/sgml/ref/values.sgml +++ b/doc/src/sgml/ref/values.sgml @@ -115,7 +115,7 @@ VALUES ( <replaceable class="PARAMETER">expression</replaceable> [, ...] ) [, .. <listitem> <para> The number of rows to skip before starting to return rows. - For details see + For details see <xref linkend="sql-limit" endterm="sql-limit-title">. </para> </listitem> |