diff options
| author | Peter Eisentraut | 2017-10-20 01:16:39 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2017-10-20 23:26:10 +0000 |
| commit | 1ff01b3902cbf5b22d1a439014202499c21b2994 (patch) | |
| tree | 0eb543455c6b64c46371638230cb7b5ca93fe667 /doc/src/sgml/ref | |
| parent | 36ea99c84d856177ec307307788a279cc600566e (diff) | |
Convert SGML IDs to lower case
IDs in SGML are case insensitive, and we have accumulated a mix of upper
and lower case IDs, including different variants of the same ID. In
XML, these will be case sensitive, so we need to fix up those
differences. Going to all lower case seems most straightforward, and
the current build process already makes all anchors and lower case
anyway during the SGML->XML conversion, so this doesn't create any
difference in the output right now. A future XML-only build process
would, however, maintain any mixed case ID spellings in the output, so
that is another reason to clean this up beforehand.
Author: Alexander Lakhin <[email protected]>
Diffstat (limited to 'doc/src/sgml/ref')
193 files changed, 466 insertions, 466 deletions
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index 285d0d4ac65..d3415957856 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/abort.sgml PostgreSQL documentation --> -<refentry id="SQL-ABORT"> +<refentry id="sql-abort"> <indexterm zone="sql-abort"> <primary>ABORT</primary> </indexterm> @@ -33,7 +33,7 @@ ABORT [ WORK | TRANSACTION ] 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">, + <xref linkend="sql-rollback">, and is present only for historical reasons. </para> </refsect1> @@ -58,7 +58,7 @@ ABORT [ WORK | TRANSACTION ] <title>Notes</title> <para> - Use <xref linkend="SQL-COMMIT"> to + Use <xref linkend="sql-commit"> to successfully terminate a transaction. </para> diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index 43f0a1609b9..e00e726ad85 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_aggregate.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERAGGREGATE"> +<refentry id="sql-alteraggregate"> <indexterm zone="sql-alteraggregate"> <primary>ALTER AGGREGATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_collation.sgml b/doc/src/sgml/ref/alter_collation.sgml index 9d77ee5c2c3..c7ad7437e87 100644 --- a/doc/src/sgml/ref/alter_collation.sgml +++ b/doc/src/sgml/ref/alter_collation.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_collation.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERCOLLATION"> +<refentry id="sql-altercollation"> <indexterm zone="sql-altercollation"> <primary>ALTER COLLATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index 83fcbbd5a5d..08ed5e28fbf 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_conversion.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERCONVERSION"> +<refentry id="sql-alterconversion"> <indexterm zone="sql-alterconversion"> <primary>ALTER CONVERSION</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 35e4123cadd..1e09b5df1d9 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_database.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERDATABASE"> +<refentry id="sql-alterdatabase"> <indexterm zone="sql-alterdatabase"> <primary>ALTER DATABASE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml index 6c34f2446a7..bc7401f845a 100644 --- a/doc/src/sgml/ref/alter_default_privileges.sgml +++ b/doc/src/sgml/ref/alter_default_privileges.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_default_privileges.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERDEFAULTPRIVILEGES"> +<refentry id="sql-alterdefaultprivileges"> <indexterm zone="sql-alterdefaultprivileges"> <primary>ALTER DEFAULT PRIVILEGES</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index 96a7db95ecf..26e95aefcfd 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_domain.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERDOMAIN"> +<refentry id="sql-alterdomain"> <indexterm zone="sql-alterdomain"> <primary>ALTER DOMAIN</primary> </indexterm> @@ -80,7 +80,7 @@ ALTER DOMAIN <replaceable class="parameter">name</replaceable> <listitem> <para> This form adds a new constraint to a domain using the same syntax as - <xref linkend="SQL-CREATEDOMAIN">. + <xref linkend="sql-createdomain">. When a new constraint is added to a domain, all columns using that domain will be checked against the newly added constraint. These checks can be suppressed by adding the new constraint using the @@ -325,7 +325,7 @@ ALTER DOMAIN zipcode SET SCHEMA customers; </programlisting></para> </refsect1> - <refsect1 id="SQL-ALTERDOMAIN-compatibility"> + <refsect1 id="sql-alterdomain-compatibility"> <title>Compatibility</title> <para> @@ -338,7 +338,7 @@ ALTER DOMAIN zipcode SET SCHEMA customers; </para> </refsect1> - <refsect1 id="SQL-ALTERDOMAIN-see-also"> + <refsect1 id="sql-alterdomain-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/alter_event_trigger.sgml b/doc/src/sgml/ref/alter_event_trigger.sgml index 38b971fb08a..b913ac9a5bd 100644 --- a/doc/src/sgml/ref/alter_event_trigger.sgml +++ b/doc/src/sgml/ref/alter_event_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_event_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTEREVENTTRIGGER"> +<refentry id="sql-altereventtrigger"> <indexterm zone="sql-altereventtrigger"> <primary>ALTER EVENT TRIGGER</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_extension.sgml b/doc/src/sgml/ref/alter_extension.sgml index c6c831fa30a..c2b0669c381 100644 --- a/doc/src/sgml/ref/alter_extension.sgml +++ b/doc/src/sgml/ref/alter_extension.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_extension.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTEREXTENSION"> +<refentry id="sql-alterextension"> <indexterm zone="sql-alterextension"> <primary>ALTER EXTENSION</primary> </indexterm> @@ -319,7 +319,7 @@ ALTER EXTENSION hstore ADD FUNCTION populate_record(anyelement, hstore); </para> </refsect1> - <refsect1 id="SQL-ALTEREXTENSION-see-also"> + <refsect1 id="sql-alterextension-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index 1c0a26de6ba..21bc83e512c 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_foreign_data_wrapper.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERFOREIGNDATAWRAPPER"> +<refentry id="sql-alterforeigndatawrapper"> <indexterm zone="sql-alterforeigndatawrapper"> <primary>ALTER FOREIGN DATA WRAPPER</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_foreign_table.sgml b/doc/src/sgml/ref/alter_foreign_table.sgml index 44d981a5bda..df3d6d0696d 100644 --- a/doc/src/sgml/ref/alter_foreign_table.sgml +++ b/doc/src/sgml/ref/alter_foreign_table.sgml @@ -3,7 +3,7 @@ doc/src/sgml/rel/alter_foreign_table.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERFOREIGNTABLE"> +<refentry id="sql-alterforeigntable"> <indexterm zone="sql-alterforeigntable"> <primary>ALTER FOREIGN TABLE</primary> </indexterm> @@ -72,7 +72,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <listitem> <para> This form adds a new column to the foreign table, using the same syntax as - <xref linkend="SQL-CREATEFOREIGNTABLE">. + <xref linkend="sql-createforeigntable">. Unlike the case when adding a column to a regular table, nothing happens to the underlying storage: this action simply declares that some new column is now accessible through the foreign table. @@ -173,7 +173,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <listitem> <para> This form adds a new constraint to a foreign table, using the same - syntax as <xref linkend="SQL-CREATEFOREIGNTABLE">. + syntax as <xref linkend="sql-createforeigntable">. Currently only <literal>CHECK</literal> constraints are supported. </para> @@ -182,7 +182,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab done to verify the constraint is correct; rather, this action simply declares that some new condition should be assumed to hold for all rows in the foreign table. (See the discussion - in <xref linkend="SQL-CREATEFOREIGNTABLE">.) + in <xref linkend="sql-createforeigntable">.) If the constraint is marked <literal>NOT VALID</literal>, then it isn't assumed to hold, but is only recorded for possible future use. </para> diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index cdecf631b1e..fd35e98a886 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_function.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERFUNCTION"> +<refentry id="sql-alterfunction"> <indexterm zone="sql-alterfunction"> <primary>ALTER FUNCTION</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index a9001458731..172a62a6f7d 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_group.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERGROUP"> +<refentry id="sql-altergroup"> <indexterm zone="sql-altergroup"> <primary>ALTER GROUP</primary> </indexterm> @@ -50,8 +50,8 @@ ALTER GROUP <replaceable class="parameter">group_name</replaceable> RENAME TO <r <quote>group</quote> for this purpose.) These variants are effectively equivalent to granting or revoking membership in the role named as the <quote>group</quote>; so the preferred way to do this is to use - <xref linkend="SQL-GRANT"> or - <xref linkend="SQL-REVOKE">. + <xref linkend="sql-grant"> or + <xref linkend="sql-revoke">. </para> <para> diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index 30e399e62c8..5d0b792e505 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_index.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERINDEX"> +<refentry id="sql-alterindex"> <indexterm zone="sql-alterindex"> <primary>ALTER INDEX</primary> </indexterm> @@ -70,7 +70,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable> this command, use <command>ALTER DATABASE</command> or explicit <command>ALTER INDEX</command> invocations instead if desired. See also - <xref linkend="SQL-CREATETABLESPACE">. + <xref linkend="sql-createtablespace">. </para> </listitem> </varlistentry> @@ -91,11 +91,11 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable> <para> This form changes one or more index-method-specific storage parameters for the index. See - <xref linkend="SQL-CREATEINDEX"> + <xref linkend="sql-createindex"> for details on the available parameters. Note that the index contents will not be modified immediately by this command; depending on the parameter you might need to rebuild the index with - <xref linkend="SQL-REINDEX"> + <xref linkend="sql-reindex"> to get the desired effects. </para> </listitem> @@ -225,7 +225,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable> <para> These operations are also possible using - <xref linkend="SQL-ALTERTABLE">. + <xref linkend="sql-altertable">. <command>ALTER INDEX</command> is in fact just an alias for the forms of <command>ALTER TABLE</command> that apply to indexes. </para> diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml index 63d9ecd924d..389824e3d21 100644 --- a/doc/src/sgml/ref/alter_language.sgml +++ b/doc/src/sgml/ref/alter_language.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_language.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERLANGUAGE"> +<refentry id="sql-alterlanguage"> <indexterm zone="sql-alterlanguage"> <primary>ALTER LANGUAGE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_large_object.sgml b/doc/src/sgml/ref/alter_large_object.sgml index 5e680f7720c..0fbb8d5b624 100644 --- a/doc/src/sgml/ref/alter_large_object.sgml +++ b/doc/src/sgml/ref/alter_large_object.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_large_object.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERLARGEOBJECT"> +<refentry id="sql-alterlargeobject"> <indexterm zone="sql-alterlargeobject"> <primary>ALTER LARGE OBJECT</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml index eaea819744a..f41b5058ff3 100644 --- a/doc/src/sgml/ref/alter_materialized_view.sgml +++ b/doc/src/sgml/ref/alter_materialized_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_materialized_view.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERMATERIALIZEDVIEW"> +<refentry id="sql-altermaterializedview"> <indexterm zone="sql-altermaterializedview"> <primary>ALTER MATERIALIZED VIEW</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml index 834f3e4231d..e69bcf2dd76 100644 --- a/doc/src/sgml/ref/alter_opclass.sgml +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_opclass.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTEROPCLASS"> +<refentry id="sql-alteropclass"> <indexterm zone="sql-alteropclass"> <primary>ALTER OPERATOR CLASS</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_operator.sgml b/doc/src/sgml/ref/alter_operator.sgml index 3cc28d5b18a..4c6f75efff3 100644 --- a/doc/src/sgml/ref/alter_operator.sgml +++ b/doc/src/sgml/ref/alter_operator.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_operator.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTEROPERATOR"> +<refentry id="sql-alteroperator"> <indexterm zone="sql-alteroperator"> <primary>ALTER OPERATOR</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_opfamily.sgml b/doc/src/sgml/ref/alter_opfamily.sgml index d15fbfceea8..f327267ff81 100644 --- a/doc/src/sgml/ref/alter_opfamily.sgml +++ b/doc/src/sgml/ref/alter_opfamily.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_opfamily.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTEROPFAMILY"> +<refentry id="sql-alteropfamily"> <indexterm zone="sql-alteropfamily"> <primary>ALTER OPERATOR FAMILY</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_policy.sgml b/doc/src/sgml/ref/alter_policy.sgml index 3eb91556023..a49f2fc5a5f 100644 --- a/doc/src/sgml/ref/alter_policy.sgml +++ b/doc/src/sgml/ref/alter_policy.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_policy.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERPOLICY"> +<refentry id="sql-alterpolicy"> <indexterm zone="sql-alterpolicy"> <primary>ALTER POLICY</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 801404e0cf9..5557f9b2318 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_publication.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERPUBLICATION"> +<refentry id="sql-alterpublication"> <indexterm zone="sql-alterpublication"> <primary>ALTER PUBLICATION</primary> </indexterm> @@ -101,7 +101,7 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r <listitem> <para> This clause alters publication parameters originally set by - <xref linkend="SQL-CREATEPUBLICATION">. See there for more information. + <xref linkend="sql-createpublication">. See there for more information. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index e30ca104549..c135364d4ec 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_role.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERROLE"> +<refentry id="sql-alterrole"> <indexterm zone="sql-alterrole"> <primary>ALTER ROLE</primary> </indexterm> @@ -65,8 +65,8 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A <xref linkend="sql-createrole">. (All the possible attributes are covered, except that there are no options for adding or removing memberships; use - <xref linkend="SQL-GRANT"> and - <xref linkend="SQL-REVOKE"> for that.) + <xref linkend="sql-grant"> and + <xref linkend="sql-revoke"> for that.) Attributes not mentioned in the command retain their previous settings. Database superusers can change any of these settings for any role. Roles having <literal>CREATEROLE</literal> privilege can change any of these @@ -173,7 +173,7 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A <listitem> <para> These clauses alter attributes originally set by - <xref linkend="SQL-CREATEROLE">. For more information, see the + <xref linkend="sql-createrole">. For more information, see the <command>CREATE ROLE</command> reference page. </para> </listitem> @@ -236,14 +236,14 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A <title>Notes</title> <para> - Use <xref linkend="SQL-CREATEROLE"> - to add new roles, and <xref linkend="SQL-DROPROLE"> to remove a role. + Use <xref linkend="sql-createrole"> + to add new roles, and <xref linkend="sql-droprole"> to remove a role. </para> <para> <command>ALTER ROLE</command> cannot change a role's memberships. - Use <xref linkend="SQL-GRANT"> and - <xref linkend="SQL-REVOKE"> + Use <xref linkend="sql-grant"> and + <xref linkend="sql-revoke"> to do that. </para> diff --git a/doc/src/sgml/ref/alter_rule.sgml b/doc/src/sgml/ref/alter_rule.sgml index 26791b379bd..f8833feee71 100644 --- a/doc/src/sgml/ref/alter_rule.sgml +++ b/doc/src/sgml/ref/alter_rule.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_rule.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERRULE"> +<refentry id="sql-alterrule"> <indexterm zone="sql-alterrule"> <primary>ALTER RULE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml index 2ca406b9148..dc914209545 100644 --- a/doc/src/sgml/ref/alter_schema.sgml +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_schema.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSCHEMA"> +<refentry id="sql-alterschema"> <indexterm zone="sql-alterschema"> <primary>ALTER SCHEMA</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index 9b8ad365227..655b35c6fcd 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_sequence.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSEQUENCE"> +<refentry id="sql-altersequence"> <indexterm zone="sql-altersequence"> <primary>ALTER SEQUENCE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index 05e11f5ef28..53529abff7e 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_server.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSERVER"> +<refentry id="sql-alterserver"> <indexterm zone="sql-alterserver"> <primary>ALTER SERVER</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_statistics.sgml b/doc/src/sgml/ref/alter_statistics.sgml index 87acb879b03..d7b012fd543 100644 --- a/doc/src/sgml/ref/alter_statistics.sgml +++ b/doc/src/sgml/ref/alter_statistics.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_statistics.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSTATISTICS"> +<refentry id="sql-alterstatistics"> <indexterm zone="sql-alterstatistics"> <primary>ALTER STATISTICS</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index b76a21f6545..7e0240d696e 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_subscription.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSUBSCRIPTION"> +<refentry id="sql-altersubscription"> <indexterm zone="sql-altersubscription"> <primary>ALTER SUBSCRIPTION</primary> </indexterm> @@ -68,7 +68,7 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO < <listitem> <para> This clause alters the connection property originally set by - <xref linkend="SQL-CREATESUBSCRIPTION">. See there for more + <xref linkend="sql-createsubscription">. See there for more information. </para> </listitem> @@ -79,7 +79,7 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO < <listitem> <para> Changes list of subscribed publications. See - <xref linkend="SQL-CREATESUBSCRIPTION"> for more information. + <xref linkend="sql-createsubscription"> for more information. By default this command will also act like <literal>REFRESH PUBLICATION</literal>. </para> @@ -162,7 +162,7 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO < <listitem> <para> This clause alters parameters originally set by - <xref linkend="SQL-CREATESUBSCRIPTION">. See there for more + <xref linkend="sql-createsubscription">. See there for more information. The allowed options are <literal>slot_name</literal> and <literal>synchronous_commit</literal> </para> diff --git a/doc/src/sgml/ref/alter_system.sgml b/doc/src/sgml/ref/alter_system.sgml index b8ef117b7d7..887c4392dd5 100644 --- a/doc/src/sgml/ref/alter_system.sgml +++ b/doc/src/sgml/ref/alter_system.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_system.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERSYSTEM"> +<refentry id="sql-altersystem"> <indexterm zone="sql-altersystem"> <primary>ALTER SYSTEM</primary> </indexterm> @@ -135,8 +135,8 @@ ALTER SYSTEM RESET wal_level; <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="SQL-SET"></member> - <member><xref linkend="SQL-SHOW"></member> + <member><xref linkend="sql-set"></member> + <member><xref linkend="sql-show"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index b4b8dab9112..234ccb70e1c 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_table.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTABLE"> +<refentry id="sql-altertable"> <indexterm zone="sql-altertable"> <primary>ALTER TABLE</primary> </indexterm> @@ -109,7 +109,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form adds a new column to the table, using the same syntax as - <xref linkend="SQL-CREATETABLE">. If <literal>IF NOT EXISTS</literal> + <xref linkend="sql-createtable">. If <literal>IF NOT EXISTS</literal> is specified and a column already exists with this name, no error is thrown. </para> @@ -314,7 +314,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form adds a new constraint to a table using the same syntax as - <xref linkend="SQL-CREATETABLE">, plus the option <literal>NOT + <xref linkend="sql-createtable">, plus the option <literal>NOT VALID</literal>, which is currently only allowed for foreign key and CHECK constraints. If the constraint is marked <literal>NOT VALID</literal>, the @@ -483,7 +483,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> even if row level security is disabled - in this case, the policies will NOT be applied and the policies will be ignored. See also - <xref linkend="SQL-CREATEPOLICY">. + <xref linkend="sql-createpolicy">. </para> </listitem> </varlistentry> @@ -498,7 +498,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> disabled (the default) then row level security will not be applied when the user is the table owner. See also - <xref linkend="SQL-CREATEPOLICY">. + <xref linkend="sql-createpolicy">. </para> </listitem> </varlistentry> @@ -508,7 +508,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form selects the default index for future - <xref linkend="SQL-CLUSTER"> + <xref linkend="sql-cluster"> operations. It does not actually re-cluster the table. </para> <para> @@ -522,7 +522,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form removes the most recently used - <xref linkend="SQL-CLUSTER"> + <xref linkend="sql-cluster"> index specification from the table. This affects future cluster operations that don't specify an index. </para> @@ -582,7 +582,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <literal>information_schema</literal> relations are not considered part of the system catalogs and will be moved. See also - <xref linkend="SQL-CREATETABLESPACE">. + <xref linkend="sql-createtablespace">. </para> </listitem> </varlistentry> @@ -592,7 +592,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form changes the table from unlogged to logged or vice-versa - (see <xref linkend="SQL-CREATETABLE-UNLOGGED">). It cannot be applied + (see <xref linkend="sql-createtable-unlogged">). It cannot be applied to a temporary table. </para> </listitem> @@ -603,13 +603,13 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <listitem> <para> This form changes one or more storage parameters for the table. See - <xref linkend="SQL-CREATETABLE-storage-parameters" - endterm="SQL-CREATETABLE-storage-parameters-title"> + <xref linkend="sql-createtable-storage-parameters" + endterm="sql-createtable-storage-parameters-title"> for details on the available parameters. Note that the table contents will not be modified immediately by this command; depending on the parameter you might need to rewrite the table to get the desired effects. - That can be done with <link linkend="SQL-VACUUM">VACUUM - FULL</link>, <xref linkend="SQL-CLUSTER"> or one of the forms + That can be done with <link linkend="sql-vacuum">VACUUM + FULL</link>, <xref linkend="sql-cluster"> or one of the forms of <command>ALTER TABLE</command> that forces a table rewrite. For planner related parameters, changes will take effect from the next time the table is locked so currently executing queries will not be @@ -722,7 +722,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> </listitem> </varlistentry> - <varlistentry id="SQL-CREATETABLE-REPLICA-IDENTITY"> + <varlistentry id="sql-createtable-replica-identity"> <term><literal>REPLICA IDENTITY</literal></term> <listitem> <para> @@ -810,7 +810,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> <para> If the new partition is a foreign table, nothing is done to verify that all the rows in the foreign table obey the partition constraint. - (See the discussion in <xref linkend="SQL-CREATEFOREIGNTABLE"> about + (See the discussion in <xref linkend="sql-createforeigntable"> about constraints on the foreign table.) </para> diff --git a/doc/src/sgml/ref/alter_tablespace.sgml b/doc/src/sgml/ref/alter_tablespace.sgml index def554bfb33..4d6f011e2fb 100644 --- a/doc/src/sgml/ref/alter_tablespace.sgml +++ b/doc/src/sgml/ref/alter_tablespace.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_tablespace.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTABLESPACE"> +<refentry id="sql-altertablespace"> <indexterm zone="sql-altertablespace"> <primary>ALTER TABLESPACE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index 2e872cf11f2..4b4dacbf28d 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTRIGGER"> +<refentry id="sql-altertrigger"> <indexterm zone="sql-altertrigger"> <primary>ALTER TRIGGER</primary> </indexterm> @@ -90,7 +90,7 @@ ALTER TRIGGER <replaceable class="parameter">name</replaceable> ON <replaceable <para> The ability to temporarily enable or disable a trigger is provided by - <xref linkend="SQL-ALTERTABLE">, not by + <xref linkend="sql-altertable">, not by <command>ALTER TRIGGER</command>, because <command>ALTER TRIGGER</command> has no convenient way to express the option of enabling or disabling all of a table's triggers at once. diff --git a/doc/src/sgml/ref/alter_tsconfig.sgml b/doc/src/sgml/ref/alter_tsconfig.sgml index b44aac9bf58..630927c15ba 100644 --- a/doc/src/sgml/ref/alter_tsconfig.sgml +++ b/doc/src/sgml/ref/alter_tsconfig.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_tsconfig.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTSCONFIG"> +<refentry id="sql-altertsconfig"> <indexterm zone="sql-altertsconfig"> <primary>ALTER TEXT SEARCH CONFIGURATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_tsdictionary.sgml b/doc/src/sgml/ref/alter_tsdictionary.sgml index 16d76687ab1..75a8b1dac62 100644 --- a/doc/src/sgml/ref/alter_tsdictionary.sgml +++ b/doc/src/sgml/ref/alter_tsdictionary.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_tsdictionary.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTSDICTIONARY"> +<refentry id="sql-altertsdictionary"> <indexterm zone="sql-altertsdictionary"> <primary>ALTER TEXT SEARCH DICTIONARY</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_tsparser.sgml b/doc/src/sgml/ref/alter_tsparser.sgml index 737a5075657..c71faeec050 100644 --- a/doc/src/sgml/ref/alter_tsparser.sgml +++ b/doc/src/sgml/ref/alter_tsparser.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_tsparser.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTSPARSER"> +<refentry id="sql-altertsparser"> <indexterm zone="sql-altertsparser"> <primary>ALTER TEXT SEARCH PARSER</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_tstemplate.sgml b/doc/src/sgml/ref/alter_tstemplate.sgml index d9a753017b5..210baa7125c 100644 --- a/doc/src/sgml/ref/alter_tstemplate.sgml +++ b/doc/src/sgml/ref/alter_tstemplate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_tstemplate.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTSTEMPLATE"> +<refentry id="sql-altertstemplate"> <indexterm zone="sql-altertstemplate"> <primary>ALTER TEXT SEARCH TEMPLATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml index 75be3187f14..7c32f0c5d5a 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_type.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERTYPE"> +<refentry id="sql-altertype"> <indexterm zone="sql-altertype"> <primary>ALTER TYPE</primary> </indexterm> @@ -52,7 +52,7 @@ ALTER TYPE <replaceable class="parameter">name</replaceable> RENAME VALUE <repla <listitem> <para> This form adds a new attribute to a composite type, using the same syntax as - <xref linkend="SQL-CREATETYPE">. + <xref linkend="sql-createtype">. </para> </listitem> </varlistentry> @@ -364,7 +364,7 @@ ALTER TYPE colors RENAME VALUE 'purple' TO 'mauve'; </para> </refsect1> - <refsect1 id="SQL-ALTERTYPE-see-also"> + <refsect1 id="sql-altertype-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 1a240ff4301..8e03510bd4e 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_user.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERUSER"> +<refentry id="sql-alteruser"> <indexterm zone="sql-alteruser"> <primary>ALTER USER</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_user_mapping.sgml b/doc/src/sgml/ref/alter_user_mapping.sgml index 18271d51995..eecff388cb0 100644 --- a/doc/src/sgml/ref/alter_user_mapping.sgml +++ b/doc/src/sgml/ref/alter_user_mapping.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_user_mapping.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERUSERMAPPING"> +<refentry id="sql-alterusermapping"> <indexterm zone="sql-alterusermapping"> <primary>ALTER USER MAPPING</primary> </indexterm> diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index e7180b44093..f33519bd79a 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/alter_view.sgml PostgreSQL documentation --> -<refentry id="SQL-ALTERVIEW"> +<refentry id="sql-alterview"> <indexterm zone="sql-alterview"> <primary>ALTER VIEW</primary> </indexterm> diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 12f2f093372..bc33f0fa236 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/analyze.sgml PostgreSQL documentation --> -<refentry id="SQL-ANALYZE"> +<refentry id="sql-analyze"> <indexterm zone="sql-analyze"> <primary>ANALYZE</primary> </indexterm> diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index fd6f073d18e..45f85aea34e 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/begin.sgml PostgreSQL documentation --> -<refentry id="SQL-BEGIN"> +<refentry id="sql-begin"> <indexterm zone="sql-begin"> <primary>BEGIN</primary> </indexterm> @@ -95,8 +95,8 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ </para> <para> - Use <xref linkend="SQL-COMMIT"> or - <xref linkend="SQL-ROLLBACK"> + Use <xref linkend="sql-commit"> or + <xref linkend="sql-rollback"> to terminate a transaction block. </para> diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 4d71c45797d..7ecc0cc4632 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/close.sgml PostgreSQL documentation --> -<refentry id="SQL-CLOSE"> +<refentry id="sql-close"> <indexterm zone="sql-close"> <primary>CLOSE</primary> </indexterm> diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index 5c5db750771..1210b5dffbf 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/cluster.sgml PostgreSQL documentation --> -<refentry id="SQL-CLUSTER"> +<refentry id="sql-cluster"> <indexterm zone="sql-cluster"> <primary>CLUSTER</primary> </indexterm> @@ -57,7 +57,7 @@ CLUSTER [VERBOSE] <command>CLUSTER <replaceable class="parameter">table_name</replaceable></command> reclusters the table using the same index as before. You can also use the <literal>CLUSTER</literal> or <literal>SET WITHOUT CLUSTER</literal> - forms of <xref linkend="SQL-ALTERTABLE"> to set the index to be used for + forms of <xref linkend="sql-altertable"> to set the index to be used for future cluster operations, or to clear any previous setting. </para> diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index 081bbc5f7a3..d2d4b52f48c 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/clusterdb.sgml PostgreSQL documentation --> -<refentry id="APP-CLUSTERDB"> +<refentry id="app-clusterdb"> <indexterm zone="app-clusterdb"> <primary>clusterdb</primary> </indexterm> @@ -60,7 +60,7 @@ PostgreSQL documentation <para> <application>clusterdb</application> is a wrapper around the SQL - command <xref linkend="SQL-CLUSTER">. + command <xref linkend="sql-cluster">. There is no effective difference between clustering databases via this utility and via other methods for accessing the server. </para> @@ -289,8 +289,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-CLUSTER"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-cluster"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index ab2e09d5218..d705792a451 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/comment.sgml PostgreSQL documentation --> -<refentry id="SQL-COMMENT"> +<refentry id="sql-comment"> <indexterm zone="sql-comment"> <primary>COMMENT</primary> </indexterm> diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 8e3f53957ee..e41d6ff3cfb 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/commit.sgml PostgreSQL documentation --> -<refentry id="SQL-COMMIT"> +<refentry id="sql-commit"> <indexterm zone="sql-commit"> <primary>COMMIT</primary> </indexterm> @@ -55,7 +55,7 @@ COMMIT [ WORK | TRANSACTION ] <title>Notes</title> <para> - Use <xref linkend="SQL-ROLLBACK"> to + Use <xref linkend="sql-rollback"> to abort a transaction. </para> diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index 35bbf85af7e..c200a3e5737 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/commit_prepared.sgml PostgreSQL documentation --> -<refentry id="SQL-COMMIT-PREPARED"> +<refentry id="sql-commit-prepared"> <indexterm zone="sql-commit-prepared"> <primary>COMMIT PREPARED</primary> </indexterm> diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 8f0974b2569..eb91ad971d7 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -4,7 +4,7 @@ PostgreSQL documentation --> -<refentry id="SQL-COPY"> +<refentry id="sql-copy"> <indexterm zone="sql-copy"> <primary>COPY</primary> </indexterm> @@ -451,7 +451,7 @@ COPY <replaceable class="parameter">count</replaceable> <para> Do not confuse <command>COPY</command> with the <application>psql</application> instruction - <command><link linkend="APP-PSQL-meta-commands-copy">\copy</link></command>. <command>\copy</command> invokes + <command><link linkend="app-psql-meta-commands-copy">\copy</link></command>. <command>\copy</command> invokes <command>COPY FROM STDIN</command> or <command>COPY TO STDOUT</command>, and then fetches/stores the data in a file accessible to the <application>psql</application> client. Thus, diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index 3de30fa5808..4a8cee80574 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_aggregate.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEAGGREGATE"> +<refentry id="sql-createaggregate"> <indexterm zone="sql-createaggregate"> <primary>CREATE AGGREGATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index 89af1e50519..cd4565e3368 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/create_cast.sgml --> -<refentry id="SQL-CREATECAST"> +<refentry id="sql-createcast"> <indexterm zone="sql-createcast"> <primary>CREATE CAST</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_collation.sgml b/doc/src/sgml/ref/create_collation.sgml index d4e99e925f0..cc76b040272 100644 --- a/doc/src/sgml/ref/create_collation.sgml +++ b/doc/src/sgml/ref/create_collation.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/create_collation.sgml --> -<refentry id="SQL-CREATECOLLATION"> +<refentry id="sql-createcollation"> <indexterm zone="sql-createcollation"> <primary>CREATE COLLATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 03e0315eef7..44475eb30ea 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/create_conversion.sgml --> -<refentry id="SQL-CREATECONVERSION"> +<refentry id="sql-createconversion"> <indexterm zone="sql-createconversion"> <primary>CREATE CONVERSION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 8adfa3a37bf..3e35c776ead 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_database.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEDATABASE"> +<refentry id="sql-createdatabase"> <indexterm zone="sql-createdatabase"> <primary>CREATE DATABASE</primary> </indexterm> @@ -45,7 +45,7 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable> <para> To create a database, you must be a superuser or have the special <literal>CREATEDB</literal> privilege. - See <xref linkend="SQL-CREATEUSER">. + See <xref linkend="sql-createuser">. </para> <para> @@ -203,11 +203,11 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable> </para> <para> - Use <xref linkend="SQL-DROPDATABASE"> to remove a database. + Use <xref linkend="sql-dropdatabase"> to remove a database. </para> <para> - The program <xref linkend="APP-CREATEDB"> is a + The program <xref linkend="app-createdb"> is a wrapper program around this command, provided for convenience. </para> diff --git a/doc/src/sgml/ref/create_domain.sgml b/doc/src/sgml/ref/create_domain.sgml index 705ff55c49f..d38914e2888 100644 --- a/doc/src/sgml/ref/create_domain.sgml +++ b/doc/src/sgml/ref/create_domain.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_domain.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEDOMAIN"> +<refentry id="sql-createdomain"> <indexterm zone="sql-createdomain"> <primary>CREATE DOMAIN</primary> </indexterm> @@ -242,7 +242,7 @@ CREATE TABLE us_snail_addy ( </programlisting></para> </refsect1> - <refsect1 id="SQL-CREATEDOMAIN-compatibility"> + <refsect1 id="sql-createdomain-compatibility"> <title>Compatibility</title> <para> @@ -251,7 +251,7 @@ CREATE TABLE us_snail_addy ( </para> </refsect1> - <refsect1 id="SQL-CREATEDOMAIN-see-also"> + <refsect1 id="sql-createdomain-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/create_event_trigger.sgml b/doc/src/sgml/ref/create_event_trigger.sgml index 9652f024121..42cd0656122 100644 --- a/doc/src/sgml/ref/create_event_trigger.sgml +++ b/doc/src/sgml/ref/create_event_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_event_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEEVENTTRIGGER"> +<refentry id="sql-createeventtrigger"> <indexterm zone="sql-createeventtrigger"> <primary>CREATE EVENT TRIGGER</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_extension.sgml b/doc/src/sgml/ref/create_extension.sgml index a3a7892812a..3e0f849f5b5 100644 --- a/doc/src/sgml/ref/create_extension.sgml +++ b/doc/src/sgml/ref/create_extension.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_extension.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEEXTENSION"> +<refentry id="sql-createextension"> <indexterm zone="sql-createextension"> <primary>CREATE EXTENSION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml index 87403a55e3b..d9a1c187358 100644 --- a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_foreign_data_wrapper.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEFOREIGNDATAWRAPPER"> +<refentry id="sql-createforeigndatawrapper"> <indexterm zone="sql-createforeigndatawrapper"> <primary>CREATE FOREIGN DATA WRAPPER</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 47705fd187e..212c62ae1b7 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/create_foreign_table.sgml --> -<refentry id="SQL-CREATEFOREIGNTABLE"> +<refentry id="sql-createforeigntable"> <indexterm zone="sql-createforeigntable"> <primary>CREATE FOREIGN TABLE</primary> </indexterm> @@ -51,7 +51,7 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] </synopsis> </refsynopsisdiv> - <refsect1 id="SQL-CREATEFOREIGNTABLE-description"> + <refsect1 id="sql-createforeigntable-description"> <title>Description</title> <para> @@ -252,7 +252,7 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] <para> The name of an existing foreign server to use for the foreign table. For details on defining a server, see <xref - linkend="SQL-CREATESERVER">. + linkend="sql-createserver">. </para> </listitem> </varlistentry> @@ -310,7 +310,7 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] </para> </refsect1> - <refsect1 id="SQL-CREATEFOREIGNTABLE-examples"> + <refsect1 id="sql-createforeigntable-examples"> <title>Examples</title> <para> @@ -342,8 +342,8 @@ CREATE FOREIGN TABLE measurement_y2016m07 </refsect1> - <refsect1 id="SQL-CREATEFOREIGNTABLE-compatibility"> - <title id="SQL-CREATEFOREIGNTABLE-compatibility-title">Compatibility</title> + <refsect1 id="sql-createforeigntable-compatibility"> + <title id="sql-createforeigntable-compatibility-title">Compatibility</title> <para> The <command>CREATE FOREIGN TABLE</command> command largely conforms to the diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 97cb9b7fc8a..970dc133595 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -2,7 +2,7 @@ doc/src/sgml/ref/create_function.sgml --> -<refentry id="SQL-CREATEFUNCTION"> +<refentry id="sql-createfunction"> <indexterm zone="sql-createfunction"> <primary>CREATE FUNCTION</primary> </indexterm> @@ -543,7 +543,7 @@ CREATE [ OR REPLACE ] FUNCTION the SQL function. The string <replaceable class="parameter">obj_file</replaceable> is the name of the shared library file containing the compiled C function, and is interpreted - as for the <xref linkend="SQL-LOAD"> command. The string + as for the <xref linkend="sql-load"> command. The string <replaceable class="parameter">link_symbol</replaceable> is the function's link symbol, that is, the name of the function in the C language source code. If the link symbol is omitted, it is assumed diff --git a/doc/src/sgml/ref/create_group.sgml b/doc/src/sgml/ref/create_group.sgml index 7896043a116..0382349404c 100644 --- a/doc/src/sgml/ref/create_group.sgml +++ b/doc/src/sgml/ref/create_group.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_group.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEGROUP"> +<refentry id="sql-creategroup"> <indexterm zone="sql-creategroup"> <primary>CREATE GROUP</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index bb2601dc8c8..92c0090dfd4 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_index.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEINDEX"> +<refentry id="sql-createindex"> <indexterm zone="sql-createindex"> <primary>CREATE INDEX</primary> </indexterm> @@ -120,8 +120,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= updates, or deletes on the table; whereas a standard index build locks out writes (but not reads) on the table until it's done. There are several caveats to be aware of when using this option - — see <xref linkend="SQL-CREATEINDEX-CONCURRENTLY" - endterm="SQL-CREATEINDEX-CONCURRENTLY-title">. + — see <xref linkend="sql-createindex-concurrently" + endterm="sql-createindex-concurrently-title">. </para> </listitem> </varlistentry> @@ -288,8 +288,8 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= </variablelist> - <refsect2 id="SQL-CREATEINDEX-storage-parameters"> - <title id="SQL-CREATEINDEX-storage-parameters-title">Index Storage Parameters</title> + <refsect2 id="sql-createindex-storage-parameters"> + <title id="sql-createindex-storage-parameters-title">Index Storage Parameters</title> <para> The optional <literal>WITH</literal> clause specifies <firstterm>storage @@ -409,10 +409,10 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= </variablelist> </refsect2> - <refsect2 id="SQL-CREATEINDEX-CONCURRENTLY"> - <title id="SQL-CREATEINDEX-CONCURRENTLY-title">Building Indexes Concurrently</title> + <refsect2 id="sql-createindex-concurrently"> + <title id="sql-createindex-concurrently-title">Building Indexes Concurrently</title> - <indexterm zone="SQL-CREATEINDEX-CONCURRENTLY"> + <indexterm zone="sql-createindex-concurrently"> <primary>index</primary> <secondary>building concurrently</secondary> </indexterm> diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 20d56a766f3..92dae40ecc6 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_language.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATELANGUAGE"> +<refentry id="sql-createlanguage"> <indexterm zone="sql-createlanguage"> <primary>CREATE LANGUAGE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_materialized_view.sgml b/doc/src/sgml/ref/create_materialized_view.sgml index 126aa5666f8..8dd138f8161 100644 --- a/doc/src/sgml/ref/create_materialized_view.sgml +++ b/doc/src/sgml/ref/create_materialized_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_materialized_view.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEMATERIALIZEDVIEW"> +<refentry id="sql-creatematerializedview"> <indexterm zone="sql-creatematerializedview"> <primary>CREATE MATERIALIZED VIEW</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index 08eb7f2a083..882100583e5 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_opclass.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEOPCLASS"> +<refentry id="sql-createopclass"> <indexterm zone="sql-createopclass"> <primary>CREATE OPERATOR CLASS</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index 11c38fd38be..774616e244f 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_operator.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEOPERATOR"> +<refentry id="sql-createoperator"> <indexterm zone="sql-createoperator"> <primary>CREATE OPERATOR</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_opfamily.sgml b/doc/src/sgml/ref/create_opfamily.sgml index ca5261b7a08..0953e238ce7 100644 --- a/doc/src/sgml/ref/create_opfamily.sgml +++ b/doc/src/sgml/ref/create_opfamily.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_opfamily.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEOPFAMILY"> +<refentry id="sql-createopfamily"> <indexterm zone="sql-createopfamily"> <primary>CREATE OPERATOR FAMILY</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_policy.sgml b/doc/src/sgml/ref/create_policy.sgml index 1bcf2de4290..64d3a6baa6c 100644 --- a/doc/src/sgml/ref/create_policy.sgml +++ b/doc/src/sgml/ref/create_policy.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_policy.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEPOLICY"> +<refentry id="sql-createpolicy"> <indexterm zone="sql-createpolicy"> <primary>CREATE POLICY</primary> </indexterm> @@ -222,7 +222,7 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable <variablelist> - <varlistentry id="SQL-CREATEPOLICY-ALL"> + <varlistentry id="sql-createpolicy-all"> <term><literal>ALL</literal></term> <listitem> <para> @@ -253,7 +253,7 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable </listitem> </varlistentry> - <varlistentry id="SQL-CREATEPOLICY-SELECT"> + <varlistentry id="sql-createpolicy-select"> <term><literal>SELECT</literal></term> <listitem> <para> @@ -273,7 +273,7 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable </listitem> </varlistentry> - <varlistentry id="SQL-CREATEPOLICY-INSERT"> + <varlistentry id="sql-createpolicy-insert"> <term><literal>INSERT</literal></term> <listitem> <para> @@ -294,7 +294,7 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable </listitem> </varlistentry> - <varlistentry id="SQL-CREATEPOLICY-UPDATE"> + <varlistentry id="sql-createpolicy-update"> <term><literal>UPDATE</literal></term> <listitem> <para> @@ -353,7 +353,7 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable </listitem> </varlistentry> - <varlistentry id="SQL-CREATEPOLICY-DELETE"> + <varlistentry id="sql-createpolicy-delete"> <term><literal>DELETE</literal></term> <listitem> <para> diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index b997d387e77..55771d1d310 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_publication.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEPUBLICATION"> +<refentry id="sql-createpublication"> <indexterm zone="sql-createpublication"> <primary>CREATE PUBLICATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 4a4061a2371..7c050a3addf 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_role.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEROLE"> +<refentry id="sql-createrole"> <indexterm zone="sql-createrole"> <primary>CREATE ROLE</primary> </indexterm> @@ -329,8 +329,8 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac <title>Notes</title> <para> - Use <xref linkend="SQL-ALTERROLE"> to - change the attributes of a role, and <xref linkend="SQL-DROPROLE"> + Use <xref linkend="sql-alterrole"> to + change the attributes of a role, and <xref linkend="sql-droprole"> to remove a role. All the attributes specified by <command>CREATE ROLE</command> can be modified by later <command>ALTER ROLE</command> commands. @@ -339,8 +339,8 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac <para> The preferred way to add and remove members of roles that are being used as groups is to use - <xref linkend="SQL-GRANT"> and - <xref linkend="SQL-REVOKE">. + <xref linkend="sql-grant"> and + <xref linkend="sql-revoke">. </para> <para> @@ -358,7 +358,7 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac a member of a role with <literal>CREATEDB</literal> privilege does not immediately grant the ability to create databases, even if <literal>INHERIT</literal> is set; it would be necessary to become that role via - <xref linkend="SQL-SET-ROLE"> before + <xref linkend="sql-set-role"> before creating a database. </para> @@ -385,7 +385,7 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac <para> <productname>PostgreSQL</productname> includes a program <xref - linkend="APP-CREATEUSER"> that has + linkend="app-createuser"> that has the same functionality as <command>CREATE ROLE</command> (in fact, it calls this command) but can be run from the command shell. </para> @@ -402,7 +402,7 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac with this command. The password will be transmitted to the server in cleartext, and it might also be logged in the client's command history or the server log. The command <xref - linkend="APP-CREATEUSER">, however, transmits + linkend="app-createuser">, however, transmits the password encrypted. Also, <xref linkend="app-psql"> contains a command <command>\password</command> that can be used to safely change the diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index c772c383991..c6403c05306 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_rule.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATERULE"> +<refentry id="sql-createrule"> <indexterm zone="sql-createrule"> <primary>CREATE RULE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index ce3530c0489..ed856e21e47 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_schema.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATESCHEMA"> +<refentry id="sql-createschema"> <indexterm zone="sql-createschema"> <primary>CREATE SCHEMA</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 9248b1d459a..0cea9a49ce8 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_sequence.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATESEQUENCE"> +<refentry id="sql-createsequence"> <indexterm zone="sql-createsequence"> <primary>CREATE SEQUENCE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml index e14ce43bf9e..e13636a2682 100644 --- a/doc/src/sgml/ref/create_server.sgml +++ b/doc/src/sgml/ref/create_server.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_server.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATESERVER"> +<refentry id="sql-createserver"> <indexterm zone="sql-createserver"> <primary>CREATE SERVER</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_statistics.sgml b/doc/src/sgml/ref/create_statistics.sgml index 066af8a4b4d..bb99d8e785d 100644 --- a/doc/src/sgml/ref/create_statistics.sgml +++ b/doc/src/sgml/ref/create_statistics.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_statistics.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATESTATISTICS"> +<refentry id="sql-createstatistics"> <indexterm zone="sql-createstatistics"> <primary>CREATE STATISTICS</primary> </indexterm> @@ -29,7 +29,7 @@ CREATE STATISTICS [ IF NOT EXISTS ] <replaceable class="parameter">statistics_na </refsynopsisdiv> - <refsect1 id="SQL-CREATESTATISTICS-description"> + <refsect1 id="sql-createstatistics-description"> <title>Description</title> <para> @@ -125,7 +125,7 @@ CREATE STATISTICS [ IF NOT EXISTS ] <replaceable class="parameter">statistics_na </para> </refsect1> - <refsect1 id="SQL-CREATESTATISTICS-examples"> + <refsect1 id="sql-createstatistics-examples"> <title>Examples</title> <para> diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index cd51b7fcac5..2a1514a5ac2 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_subscription.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATESUBSCRIPTION"> +<refentry id="sql-createsubscription"> <indexterm zone="sql-createsubscription"> <primary>CREATE SUBSCRIPTION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 2db2e9fc444..4f7b741526f 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_table.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETABLE"> +<refentry id="sql-createtable"> <indexterm zone="sql-createtable"> <primary>CREATE TABLE</primary> </indexterm> @@ -102,7 +102,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </refsynopsisdiv> - <refsect1 id="SQL-CREATETABLE-description"> + <refsect1 id="sql-createtable-description"> <title>Description</title> <para> @@ -157,7 +157,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace <variablelist> - <varlistentry id="SQL-CREATETABLE-TEMPORARY"> + <varlistentry id="sql-createtable-temporary"> <term><literal>TEMPORARY</literal> or <literal>TEMP</literal></term> <listitem> <para> @@ -191,7 +191,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </listitem> </varlistentry> - <varlistentry id="SQL-CREATETABLE-UNLOGGED"> + <varlistentry id="sql-createtable-unlogged"> <term><literal>UNLOGGED</literal></term> <listitem> <para> @@ -249,7 +249,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </listitem> </varlistentry> - <varlistentry id="SQL-CREATETABLE-PARTITION"> + <varlistentry id="sql-createtable-partition"> <term><literal>PARTITION OF <replaceable class="parameter">parent_table</replaceable> { FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable> | DEFAULT }</literal></term> <listitem> <para> @@ -783,7 +783,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </listitem> </varlistentry> - <varlistentry id="SQL-CREATETABLE-EXCLUDE"> + <varlistentry id="sql-createtable-exclude"> <term><literal>EXCLUDE [ USING <replaceable class="parameter">index_method</replaceable> ] ( <replaceable class="parameter">exclude_element</replaceable> WITH <replaceable class="parameter">operator</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable> [ WHERE ( <replaceable class="parameter">predicate</replaceable> ) ]</literal></term> <listitem> <para> @@ -1120,8 +1120,8 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </variablelist> - <refsect2 id="SQL-CREATETABLE-storage-parameters"> - <title id="SQL-CREATETABLE-storage-parameters-title">Storage Parameters</title> + <refsect2 id="sql-createtable-storage-parameters"> + <title id="sql-createtable-storage-parameters-title">Storage Parameters</title> <indexterm zone="sql-createtable-storage-parameters"> <primary>storage parameters</primary> @@ -1132,7 +1132,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace for tables, and for indexes associated with a <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, or <literal>EXCLUDE</literal> constraint. Storage parameters for - indexes are documented in <xref linkend="SQL-CREATEINDEX">. + indexes are documented in <xref linkend="sql-createindex">. The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with @@ -1360,7 +1360,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </refsect2> </refsect1> - <refsect1 id="SQL-CREATETABLE-notes"> + <refsect1 id="sql-createtable-notes"> <title>Notes</title> <para> @@ -1407,7 +1407,7 @@ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replace </refsect1> - <refsect1 id="SQL-CREATETABLE-examples"> + <refsect1 id="sql-createtable-examples"> <title>Examples</title> <para> @@ -1709,8 +1709,8 @@ CREATE TABLE cities_partdef </programlisting></para> </refsect1> - <refsect1 id="SQL-CREATETABLE-compatibility"> - <title id="SQL-CREATETABLE-compatibility-title">Compatibility</title> + <refsect1 id="sql-createtable-compatibility"> + <title id="sql-createtable-compatibility-title">Compatibility</title> <para> The <command>CREATE TABLE</command> command conforms to the diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 8198442a974..89ca82baa5c 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_table_as.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETABLEAS"> +<refentry id="sql-createtableas"> <indexterm zone="sql-createtableas"> <primary>CREATE TABLE AS</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_tablespace.sgml b/doc/src/sgml/ref/create_tablespace.sgml index 4d95cac9e59..ed9635ef400 100644 --- a/doc/src/sgml/ref/create_tablespace.sgml +++ b/doc/src/sgml/ref/create_tablespace.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_tablespace.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETABLESPACE"> +<refentry id="sql-createtablespace"> <indexterm zone="sql-createtablespace"> <primary>CREATE TABLESPACE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_transform.sgml b/doc/src/sgml/ref/create_transform.sgml index 647c3b9f057..dfb83a76da4 100644 --- a/doc/src/sgml/ref/create_transform.sgml +++ b/doc/src/sgml/ref/create_transform.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/create_transform.sgml --> -<refentry id="SQL-CREATETRANSFORM"> +<refentry id="sql-createtransform"> <indexterm zone="sql-createtransform"> <primary>CREATE TRANSFORM</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 6726e3c7663..9e97c364ef8 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETRIGGER"> +<refentry id="sql-createtrigger"> <indexterm zone="sql-createtrigger"> <primary>CREATE TRIGGER</primary> </indexterm> @@ -170,7 +170,7 @@ CREATE [ CONSTRAINT ] TRIGGER <replaceable class="parameter">name</replaceable> When the <literal>CONSTRAINT</literal> option is specified, this command creates a <firstterm>constraint trigger</firstterm>. This is the same as a regular trigger except that the timing of the trigger firing can be adjusted using - <xref linkend="SQL-SET-CONSTRAINTS">. + <xref linkend="sql-set-constraints">. Constraint triggers must be <literal>AFTER ROW</literal> triggers on plain tables (not foreign tables). They can be fired either at the end of the statement causing the triggering @@ -302,7 +302,7 @@ UPDATE OF <replaceable>column_name1</replaceable> [, <replaceable>column_name2</ <listitem> <para> The default timing of the trigger. - See the <xref linkend="SQL-CREATETABLE"> documentation for details of + See the <xref linkend="sql-createtable"> documentation for details of these constraint options. This can only be specified for constraint triggers. </para> @@ -422,7 +422,7 @@ UPDATE OF <replaceable>column_name1</replaceable> [, <replaceable>column_name2</ </variablelist> </refsect1> - <refsect1 id="SQL-CREATETRIGGER-notes"> + <refsect1 id="sql-createtrigger-notes"> <title>Notes</title> <para> @@ -523,7 +523,7 @@ UPDATE OF <replaceable>column_name1</replaceable> [, <replaceable>column_name2</ </para> </refsect1> - <refsect1 id="SQL-CREATETRIGGER-examples"> + <refsect1 id="sql-createtrigger-examples"> <title>Examples</title> <para> @@ -610,7 +610,7 @@ CREATE TRIGGER paired_items_update </para> </refsect1> - <refsect1 id="SQL-CREATETRIGGER-compatibility"> + <refsect1 id="sql-createtrigger-compatibility"> <title>Compatibility</title> <!-- diff --git a/doc/src/sgml/ref/create_tsconfig.sgml b/doc/src/sgml/ref/create_tsconfig.sgml index d1792e5d29d..49634b43629 100644 --- a/doc/src/sgml/ref/create_tsconfig.sgml +++ b/doc/src/sgml/ref/create_tsconfig.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_tsconfig.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETSCONFIG"> +<refentry id="sql-createtsconfig"> <indexterm zone="sql-createtsconfig"> <primary>CREATE TEXT SEARCH CONFIGURATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_tsdictionary.sgml b/doc/src/sgml/ref/create_tsdictionary.sgml index 9c95c116083..20a01765b75 100644 --- a/doc/src/sgml/ref/create_tsdictionary.sgml +++ b/doc/src/sgml/ref/create_tsdictionary.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_tsdictionary.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETSDICTIONARY"> +<refentry id="sql-createtsdictionary"> <indexterm zone="sql-createtsdictionary"> <primary>CREATE TEXT SEARCH DICTIONARY</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_tsparser.sgml b/doc/src/sgml/ref/create_tsparser.sgml index 044581f6f29..8e5e1b0b484 100644 --- a/doc/src/sgml/ref/create_tsparser.sgml +++ b/doc/src/sgml/ref/create_tsparser.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_tsparser.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETSPARSER"> +<refentry id="sql-createtsparser"> <indexterm zone="sql-createtsparser"> <primary>CREATE TEXT SEARCH PARSER</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_tstemplate.sgml b/doc/src/sgml/ref/create_tstemplate.sgml index e10f18b28b8..0340e1ab1f4 100644 --- a/doc/src/sgml/ref/create_tstemplate.sgml +++ b/doc/src/sgml/ref/create_tstemplate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_tstemplate.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETSTEMPLATE"> +<refentry id="sql-createtstemplate"> <indexterm zone="sql-createtstemplate"> <primary>CREATE TEXT SEARCH TEMPLATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index 02ca27b281e..1b409ad22f6 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_type.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATETYPE"> +<refentry id="sql-createtype"> <indexterm zone="sql-createtype"> <primary>CREATE TYPE</primary> </indexterm> @@ -111,7 +111,7 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> </para> </refsect2> - <refsect2 id="SQL-CREATETYPE-enum"> + <refsect2 id="sql-createtype-enum"> <title>Enumerated Types</title> <para> @@ -123,7 +123,7 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> </para> </refsect2> - <refsect2 id="SQL-CREATETYPE-RANGE"> + <refsect2 id="sql-createtype-range"> <title>Range Types</title> <para> @@ -769,7 +769,7 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> </variablelist> </refsect1> - <refsect1 id="SQL-CREATETYPE-notes"> + <refsect1 id="sql-createtype-notes"> <title>Notes</title> <para> @@ -928,7 +928,7 @@ CREATE TABLE big_objs ( </para> </refsect1> - <refsect1 id="SQL-CREATETYPE-compatibility"> + <refsect1 id="sql-createtype-compatibility"> <title>Compatibility</title> <para> @@ -947,7 +947,7 @@ CREATE TABLE big_objs ( </para> </refsect1> - <refsect1 id="SQL-CREATETYPE-see-also"> + <refsect1 id="sql-createtype-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index 500169da986..13dfd64c6d0 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_user.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEUSER"> +<refentry id="sql-createuser"> <indexterm zone="sql-createuser"> <primary>CREATE USER</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_user_mapping.sgml b/doc/src/sgml/ref/create_user_mapping.sgml index 10182e14266..d18cc91a002 100644 --- a/doc/src/sgml/ref/create_user_mapping.sgml +++ b/doc/src/sgml/ref/create_user_mapping.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_user_mapping.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEUSERMAPPING"> +<refentry id="sql-createusermapping"> <indexterm zone="sql-createusermapping"> <primary>CREATE USER MAPPING</primary> </indexterm> diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index c0dd0224955..e52a4b85a77 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/create_view.sgml PostgreSQL documentation --> -<refentry id="SQL-CREATEVIEW"> +<refentry id="sql-createview"> <indexterm zone="sql-createview"> <primary>CREATE VIEW</primary> </indexterm> @@ -165,10 +165,10 @@ CREATE VIEW [ <replaceable>schema</replaceable> . ] <replaceable>view_name</repl <varlistentry> <term><literal>WITH [ CASCADED | LOCAL ] CHECK OPTION</literal> - <indexterm zone="SQL-CREATEVIEW"> + <indexterm zone="sql-createview"> <primary>CHECK OPTION</primary> </indexterm> - <indexterm zone="SQL-CREATEVIEW"> + <indexterm zone="sql-createview"> <primary>WITH CHECK OPTION</primary> </indexterm> </term> @@ -278,8 +278,8 @@ CREATE VIEW vista AS SELECT text 'Hello World' AS hello; to replace it (this includes being a member of the owning role). </para> - <refsect2 id="SQL-CREATEVIEW-updatable-views"> - <title id="SQL-CREATEVIEW-updatable-views-title">Updatable Views</title> + <refsect2 id="sql-createview-updatable-views"> + <title id="sql-createview-updatable-views-title">Updatable Views</title> <indexterm zone="sql-createview-updatable-views"> <primary>updatable views</primary> diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index 0112d3a848f..265d14e1491 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/createdb.sgml PostgreSQL documentation --> -<refentry id="APP-CREATEDB"> +<refentry id="app-createdb"> <indexterm zone="app-createdb"> <primary>createdb</primary> </indexterm> @@ -30,7 +30,7 @@ PostgreSQL documentation </refsynopsisdiv> - <refsect1 id="R1-APP-CREATEDB-1"> + <refsect1 id="r1-app-createdb-1"> <title> Description </title> @@ -48,7 +48,7 @@ PostgreSQL documentation <para> <application>createdb</application> is a wrapper around the - <acronym>SQL</acronym> command <xref linkend="SQL-CREATEDATABASE">. + <acronym>SQL</acronym> command <xref linkend="sql-createdatabase">. There is no effective difference between creating databases via this utility and via other methods for accessing the server. </para> @@ -199,7 +199,7 @@ PostgreSQL documentation 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 + SQL command <xref linkend="sql-createdatabase">; see there for more information about them. </para> @@ -337,8 +337,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-CREATEDATABASE"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-createdatabase"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml index 788ee81dafb..f3c50c41131 100644 --- a/doc/src/sgml/ref/createuser.sgml +++ b/doc/src/sgml/ref/createuser.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/createuser.sgml PostgreSQL documentation --> -<refentry id="APP-CREATEUSER"> +<refentry id="app-createuser"> <indexterm zone="app-createuser"> <primary>createuser</primary> </indexterm> @@ -49,7 +49,7 @@ PostgreSQL documentation <para> <application>createuser</application> is a wrapper around the - <acronym>SQL</acronym> command <xref linkend="SQL-CREATEROLE">. + <acronym>SQL</acronym> command <xref linkend="sql-createrole">. There is no effective difference between creating users via this utility and via other methods for accessing the server. </para> @@ -415,8 +415,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-CREATEROLE"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-createrole"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/deallocate.sgml b/doc/src/sgml/ref/deallocate.sgml index 394b125f523..4e23c6e091e 100644 --- a/doc/src/sgml/ref/deallocate.sgml +++ b/doc/src/sgml/ref/deallocate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/deallocate.sgml PostgreSQL documentation --> -<refentry id="SQL-DEALLOCATE"> +<refentry id="sql-deallocate"> <indexterm zone="sql-deallocate"> <primary>DEALLOCATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index 8eae0354af8..a70e2466e5d 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/declare.sgml PostgreSQL documentation --> -<refentry id="SQL-DECLARE"> +<refentry id="sql-declare"> <indexterm zone="sql-declare"> <primary>DECLARE</primary> </indexterm> diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index 570e9aa7108..d7869efd9a2 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/delete.sgml PostgreSQL documentation --> -<refentry id="SQL-DELETE"> +<refentry id="sql-delete"> <indexterm zone="sql-delete"> <primary>DELETE</primary> </indexterm> diff --git a/doc/src/sgml/ref/discard.sgml b/doc/src/sgml/ref/discard.sgml index f432e70430d..063342494fa 100644 --- a/doc/src/sgml/ref/discard.sgml +++ b/doc/src/sgml/ref/discard.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/discard.sgml PostgreSQL documentation --> -<refentry id="SQL-DISCARD"> +<refentry id="sql-discard"> <indexterm zone="sql-discard"> <primary>DISCARD</primary> </indexterm> diff --git a/doc/src/sgml/ref/do.sgml b/doc/src/sgml/ref/do.sgml index 5d2e9b1b8ce..c14dff0a281 100644 --- a/doc/src/sgml/ref/do.sgml +++ b/doc/src/sgml/ref/do.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/do.sgml PostgreSQL documentation --> -<refentry id="SQL-DO"> +<refentry id="sql-do"> <indexterm zone="sql-do"> <primary>DO</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index ac29e7a4193..1e5b3e8bd47 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_aggregate.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPAGGREGATE"> +<refentry id="sql-dropaggregate"> <indexterm zone="sql-dropaggregate"> <primary>DROP AGGREGATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_cast.sgml b/doc/src/sgml/ref/drop_cast.sgml index dae3a39fce2..6e0d7416371 100644 --- a/doc/src/sgml/ref/drop_cast.sgml +++ b/doc/src/sgml/ref/drop_cast.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/drop_cast.sgml --> -<refentry id="SQL-DROPCAST"> +<refentry id="sql-dropcast"> <indexterm zone="sql-dropcast"> <primary>DROP CAST</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_collation.sgml b/doc/src/sgml/ref/drop_collation.sgml index 23f8e88fc95..03df0d17b1e 100644 --- a/doc/src/sgml/ref/drop_collation.sgml +++ b/doc/src/sgml/ref/drop_collation.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/drop_collation.sgml --> -<refentry id="SQL-DROPCOLLATION"> +<refentry id="sql-dropcollation"> <indexterm zone="sql-dropcollation"> <primary>DROP COLLATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index 9d56ec51a59..d5cf18c3e91 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/drop_conversion.sgml --> -<refentry id="SQL-DROPCONVERSION"> +<refentry id="sql-dropconversion"> <indexterm zone="sql-dropconversion"> <primary>DROP CONVERSION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index 7e5fbe7396c..bbf3fd37769 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_database.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPDATABASE"> +<refentry id="sql-dropdatabase"> <indexterm zone="sql-dropdatabase"> <primary>DROP DATABASE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index b1dac01e652..59379e82348 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_domain.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPDOMAIN"> +<refentry id="sql-dropdomain"> <indexterm zone="sql-dropdomain"> <primary>DROP DOMAIN</primary> </indexterm> @@ -81,7 +81,7 @@ DROP DOMAIN [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, . </variablelist> </refsect1> - <refsect1 id="SQL-DROPDOMAIN-examples"> + <refsect1 id="sql-dropdomain-examples"> <title>Examples</title> <para> @@ -92,7 +92,7 @@ DROP DOMAIN box; </programlisting></para> </refsect1> - <refsect1 id="SQL-DROPDOMAIN-compatibility"> + <refsect1 id="sql-dropdomain-compatibility"> <title>Compatibility</title> <para> @@ -102,7 +102,7 @@ DROP DOMAIN box; </para> </refsect1> - <refsect1 id="SQL-DROPDOMAIN-see-also"> + <refsect1 id="sql-dropdomain-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/drop_event_trigger.sgml b/doc/src/sgml/ref/drop_event_trigger.sgml index 583048dc0f4..a773170fa68 100644 --- a/doc/src/sgml/ref/drop_event_trigger.sgml +++ b/doc/src/sgml/ref/drop_event_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_event_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPEVENTTRIGGER"> +<refentry id="sql-dropeventtrigger"> <indexterm zone="sql-dropeventtrigger"> <primary>DROP EVENT TRIGGER</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_extension.sgml b/doc/src/sgml/ref/drop_extension.sgml index f75308a20d3..bb296df17f3 100644 --- a/doc/src/sgml/ref/drop_extension.sgml +++ b/doc/src/sgml/ref/drop_extension.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_extension.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPEXTENSION"> +<refentry id="sql-dropextension"> <indexterm zone="sql-dropextension"> <primary>DROP EXTENSION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml index a3c73a0d46b..8e8968ab1a6 100644 --- a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_foreign_data_wrapper.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPFOREIGNDATAWRAPPER"> +<refentry id="sql-dropforeigndatawrapper"> <indexterm zone="sql-dropforeigndatawrapper"> <primary>DROP FOREIGN DATA WRAPPER</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_foreign_table.sgml b/doc/src/sgml/ref/drop_foreign_table.sgml index 456d55d1122..b12de03e65d 100644 --- a/doc/src/sgml/ref/drop_foreign_table.sgml +++ b/doc/src/sgml/ref/drop_foreign_table.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/drop_foreign_table.sgml --> -<refentry id="SQL-DROPFOREIGNTABLE"> +<refentry id="sql-dropforeigntable"> <indexterm zone="sql-dropforeigntable"> <primary>DROP FOREIGN TABLE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index 9c9adb9a46d..05b405dda17 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_function.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPFUNCTION"> +<refentry id="sql-dropfunction"> <indexterm zone="sql-dropfunction"> <primary>DROP FUNCTION</primary> </indexterm> @@ -127,7 +127,7 @@ DROP FUNCTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [ </variablelist> </refsect1> - <refsect1 id="SQL-DROPFUNCTION-examples"> + <refsect1 id="sql-dropfunction-examples"> <title>Examples</title> <para> @@ -159,7 +159,7 @@ DROP FUNCTION update_employee_salaries(); </para> </refsect1> - <refsect1 id="SQL-DROPFUNCTION-compatibility"> + <refsect1 id="sql-dropfunction-compatibility"> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/drop_group.sgml b/doc/src/sgml/ref/drop_group.sgml index 5987c5f760b..7844db0f7d6 100644 --- a/doc/src/sgml/ref/drop_group.sgml +++ b/doc/src/sgml/ref/drop_group.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_group.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPGROUP"> +<refentry id="sql-dropgroup"> <indexterm zone="sql-dropgroup"> <primary>DROP GROUP</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index de36c135d16..fd235a0c276 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_index.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPINDEX"> +<refentry id="sql-dropindex"> <indexterm zone="sql-dropindex"> <primary>DROP INDEX</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 524d7583703..350375baef1 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_language.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPLANGUAGE"> +<refentry id="sql-droplanguage"> <indexterm zone="sql-droplanguage"> <primary>DROP LANGUAGE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_materialized_view.sgml b/doc/src/sgml/ref/drop_materialized_view.sgml index a898a1fc0af..b115aceb384 100644 --- a/doc/src/sgml/ref/drop_materialized_view.sgml +++ b/doc/src/sgml/ref/drop_materialized_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_materialized_view.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPMATERIALIZEDVIEW"> +<refentry id="sql-dropmaterializedview"> <indexterm zone="sql-dropmaterializedview"> <primary>DROP MATERIALIZED VIEW</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index 83af6d7e485..53a40ff73ec 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_opclass.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPOPCLASS"> +<refentry id="sql-dropopclass"> <indexterm zone="sql-dropopclass"> <primary>DROP OPERATOR CLASS</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index 5897c99a620..b10bed09cc8 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_operator.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPOPERATOR"> +<refentry id="sql-dropoperator"> <indexterm zone="sql-dropoperator"> <primary>DROP OPERATOR</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_opfamily.sgml b/doc/src/sgml/ref/drop_opfamily.sgml index b825978aee9..eb92664d85e 100644 --- a/doc/src/sgml/ref/drop_opfamily.sgml +++ b/doc/src/sgml/ref/drop_opfamily.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_opfamily.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPOPFAMILY"> +<refentry id="sql-dropopfamily"> <indexterm zone="sql-dropopfamily"> <primary>DROP OPERATOR FAMILY</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index 8b4b3644e66..1eb054dee61 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_owned.sgml PostgreSQL documentation --> -<refentry id="SQL-DROP-OWNED"> +<refentry id="sql-drop-owned"> <indexterm zone="sql-drop-owned"> <primary>DROP OWNED</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_policy.sgml b/doc/src/sgml/ref/drop_policy.sgml index f4746921054..2bc1e25f9c3 100644 --- a/doc/src/sgml/ref/drop_policy.sgml +++ b/doc/src/sgml/ref/drop_policy.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_policy.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPPOLICY"> +<refentry id="sql-droppolicy"> <indexterm zone="sql-droppolicy"> <primary>DROP POLICY</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_publication.sgml b/doc/src/sgml/ref/drop_publication.sgml index 1c129c04443..3195c040bb3 100644 --- a/doc/src/sgml/ref/drop_publication.sgml +++ b/doc/src/sgml/ref/drop_publication.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_publication.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPPUBLICATION"> +<refentry id="sql-droppublication"> <indexterm zone="sql-droppublication"> <primary>DROP PUBLICATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index 3c1bbaba6fd..413d1870d42 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_role.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPROLE"> +<refentry id="sql-droprole"> <indexterm zone="sql-droprole"> <primary>DROP ROLE</primary> </indexterm> @@ -83,7 +83,7 @@ DROP ROLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ... <para> <productname>PostgreSQL</productname> includes a program <xref - linkend="APP-DROPUSER"> that has the + linkend="app-dropuser"> that has the same functionality as this command (in fact, it calls this command) but can be run from the command shell. </para> diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index d3fdf55080c..6955016c272 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_rule.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPRULE"> +<refentry id="sql-droprule"> <indexterm zone="sql-droprule"> <primary>DROP RULE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index bb3af1e1863..2e608b2b207 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_schema.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPSCHEMA"> +<refentry id="sql-dropschema"> <indexterm zone="sql-dropschema"> <primary>DROP SCHEMA</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index 5027129b38b..be30f8f8104 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_sequence.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPSEQUENCE"> +<refentry id="sql-dropsequence"> <indexterm zone="sql-dropsequence"> <primary>DROP SEQUENCE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_server.sgml b/doc/src/sgml/ref/drop_server.sgml index 8ef0e014e4f..fa941e8cd20 100644 --- a/doc/src/sgml/ref/drop_server.sgml +++ b/doc/src/sgml/ref/drop_server.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_server.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPSERVER"> +<refentry id="sql-dropserver"> <indexterm zone="sql-dropserver"> <primary>DROP SERVER</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_statistics.sgml b/doc/src/sgml/ref/drop_statistics.sgml index fd2087db6a7..b34d070d50c 100644 --- a/doc/src/sgml/ref/drop_statistics.sgml +++ b/doc/src/sgml/ref/drop_statistics.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_statistics.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPSTATISTICS"> +<refentry id="sql-dropstatistics"> <indexterm zone="sql-dropstatistics"> <primary>DROP STATISTICS</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml index 58b14894757..5ab2f9eae84 100644 --- a/doc/src/sgml/ref/drop_subscription.sgml +++ b/doc/src/sgml/ref/drop_subscription.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_subscription.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPSUBSCRIPTION"> +<refentry id="sql-dropsubscription"> <indexterm zone="sql-dropsubscription"> <primary>DROP SUBSCRIPTION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index cea7e003511..b2153699103 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_table.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTABLE"> +<refentry id="sql-droptable"> <indexterm zone="sql-droptable"> <primary>DROP TABLE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index 4343035ebb2..b761a4d92e0 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_tablespace.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTABLESPACE"> +<refentry id="sql-droptablespace"> <indexterm zone="sql-droptablespace"> <primary>DROP TABLESPACE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_transform.sgml b/doc/src/sgml/ref/drop_transform.sgml index 698920a2266..c7de707fcc4 100644 --- a/doc/src/sgml/ref/drop_transform.sgml +++ b/doc/src/sgml/ref/drop_transform.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/drop_transform.sgml --> -<refentry id="SQL-DROPTRANSFORM"> +<refentry id="sql-droptransform"> <indexterm zone="sql-droptransform"> <primary>DROP TRANSFORM</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index d44bf138a67..118f38f3f48 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_trigger.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTRIGGER"> +<refentry id="sql-droptrigger"> <indexterm zone="sql-droptrigger"> <primary>DROP TRIGGER</primary> </indexterm> @@ -92,7 +92,7 @@ DROP TRIGGER [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ON </variablelist> </refsect1> - <refsect1 id="SQL-DROPTRIGGER-examples"> + <refsect1 id="sql-droptrigger-examples"> <title>Examples</title> <para> @@ -104,7 +104,7 @@ DROP TRIGGER if_dist_exists ON films; </programlisting></para> </refsect1> - <refsect1 id="SQL-DROPTRIGGER-compatibility"> + <refsect1 id="sql-droptrigger-compatibility"> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/drop_tsconfig.sgml b/doc/src/sgml/ref/drop_tsconfig.sgml index cc053beceb7..b7acf46ff7a 100644 --- a/doc/src/sgml/ref/drop_tsconfig.sgml +++ b/doc/src/sgml/ref/drop_tsconfig.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_tsconfig.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTSCONFIG"> +<refentry id="sql-droptsconfig"> <indexterm zone="sql-droptsconfig"> <primary>DROP TEXT SEARCH CONFIGURATION</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_tsdictionary.sgml b/doc/src/sgml/ref/drop_tsdictionary.sgml index 66af10fb0f4..b670f55ff2b 100644 --- a/doc/src/sgml/ref/drop_tsdictionary.sgml +++ b/doc/src/sgml/ref/drop_tsdictionary.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_tsdictionary.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTSDICTIONARY"> +<refentry id="sql-droptsdictionary"> <indexterm zone="sql-droptsdictionary"> <primary>DROP TEXT SEARCH DICTIONARY</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_tsparser.sgml b/doc/src/sgml/ref/drop_tsparser.sgml index 3fa9467ebdd..dea9b2b1bda 100644 --- a/doc/src/sgml/ref/drop_tsparser.sgml +++ b/doc/src/sgml/ref/drop_tsparser.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_tsparser.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTSPARSER"> +<refentry id="sql-droptsparser"> <indexterm zone="sql-droptsparser"> <primary>DROP TEXT SEARCH PARSER</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_tstemplate.sgml b/doc/src/sgml/ref/drop_tstemplate.sgml index ad832754573..244af48191e 100644 --- a/doc/src/sgml/ref/drop_tstemplate.sgml +++ b/doc/src/sgml/ref/drop_tstemplate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_tstemplate.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTSTEMPLATE"> +<refentry id="sql-droptstemplate"> <indexterm zone="sql-droptstemplate"> <primary>DROP TEXT SEARCH TEMPLATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index 92ac2729caf..37449ed19fd 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_type.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPTYPE"> +<refentry id="sql-droptype"> <indexterm zone="sql-droptype"> <primary>DROP TYPE</primary> </indexterm> @@ -81,7 +81,7 @@ DROP TYPE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ... </variablelist> </refsect1> - <refsect1 id="SQL-DROPTYPE-examples"> + <refsect1 id="sql-droptype-examples"> <title>Examples</title> <para> @@ -91,7 +91,7 @@ DROP TYPE box; </programlisting></para> </refsect1> - <refsect1 id="SQL-DROPTYPE-compatibility"> + <refsect1 id="sql-droptype-compatibility"> <title>Compatibility</title> <para> @@ -104,7 +104,7 @@ DROP TYPE box; </para> </refsect1> - <refsect1 id="SQL-DROPTYPE-see-also"> + <refsect1 id="sql-droptype-see-also"> <title>See Also</title> <simplelist type="inline"> diff --git a/doc/src/sgml/ref/drop_user.sgml b/doc/src/sgml/ref/drop_user.sgml index 3cb90522daa..0e680f30f63 100644 --- a/doc/src/sgml/ref/drop_user.sgml +++ b/doc/src/sgml/ref/drop_user.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_user.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPUSER"> +<refentry id="sql-dropuser"> <indexterm zone="sql-dropuser"> <primary>DROP USER</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_user_mapping.sgml b/doc/src/sgml/ref/drop_user_mapping.sgml index 27284acae4c..393a1eadcf6 100644 --- a/doc/src/sgml/ref/drop_user_mapping.sgml +++ b/doc/src/sgml/ref/drop_user_mapping.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_user_mapping.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPUSERMAPPING"> +<refentry id="sql-dropusermapping"> <indexterm zone="sql-dropusermapping"> <primary>DROP USER MAPPING</primary> </indexterm> diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index a33b33335b0..47e55bffb47 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/drop_view.sgml PostgreSQL documentation --> -<refentry id="SQL-DROPVIEW"> +<refentry id="sql-dropview"> <indexterm zone="sql-dropview"> <primary>DROP VIEW</primary> </indexterm> diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index 9dd44be8828..f7ca0877b1d 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/dropdb.sgml PostgreSQL documentation --> -<refentry id="APP-DROPDB"> +<refentry id="app-dropdb"> <indexterm zone="app-dropdb"> <primary>dropdb</primary> </indexterm> @@ -41,7 +41,7 @@ PostgreSQL documentation <para> <application>dropdb</application> is a wrapper around the - <acronym>SQL</acronym> command <xref linkend="SQL-DROPDATABASE">. + <acronym>SQL</acronym> command <xref linkend="sql-dropdatabase">. There is no effective difference between dropping databases via this utility and via other methods for accessing the server. </para> @@ -243,8 +243,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-DROPDATABASE"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-dropdatabase"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index 1387b7dc2da..4c6a8bdb409 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/dropuser.sgml PostgreSQL documentation --> -<refentry id="APP-DROPUSER"> +<refentry id="app-dropuser"> <indexterm zone="app-dropuser"> <primary>dropuser</primary> </indexterm> @@ -42,7 +42,7 @@ PostgreSQL documentation <para> <application>dropuser</application> is a wrapper around the - <acronym>SQL</acronym> command <xref linkend="SQL-DROPROLE">. + <acronym>SQL</acronym> command <xref linkend="sql-droprole">. There is no effective difference between dropping users via this utility and via other methods for accessing the server. </para> @@ -235,8 +235,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-DROPROLE"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-droprole"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index a9eaff815dc..18e7ed526ae 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/ecpg-ref.sgml PostgreSQL documentation --> -<refentry id="APP-ECPG"> +<refentry id="app-ecpg"> <indexterm zone="app-ecpg"> <primary>ecpg</primary> </indexterm> @@ -28,7 +28,7 @@ PostgreSQL documentation </refsynopsisdiv> - <refsect1 id="APP-ECPG-description"> + <refsect1 id="app-ecpg-description"> <title>Description</title> <para> diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index 1f74118efd9..4904980dab4 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/end.sgml PostgreSQL documentation --> -<refentry id="SQL-END"> +<refentry id="sql-end"> <indexterm zone="sql-end"> <primary>END</primary> </indexterm> @@ -57,7 +57,7 @@ END [ WORK | TRANSACTION ] <title>Notes</title> <para> - Use <xref linkend="SQL-ROLLBACK"> to + Use <xref linkend="sql-rollback"> to abort a transaction. </para> diff --git a/doc/src/sgml/ref/execute.sgml b/doc/src/sgml/ref/execute.sgml index 6ac413d8086..113a07a3ce5 100644 --- a/doc/src/sgml/ref/execute.sgml +++ b/doc/src/sgml/ref/execute.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/execute.sgml PostgreSQL documentation --> -<refentry id="SQL-EXECUTE"> +<refentry id="sql-execute"> <indexterm zone="sql-execute"> <primary>EXECUTE</primary> </indexterm> diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index bbf2e11cbb9..a32c1505111 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/explain.sgml PostgreSQL documentation --> -<refentry id="SQL-EXPLAIN"> +<refentry id="sql-explain"> <indexterm zone="sql-explain"> <primary>EXPLAIN</primary> </indexterm> diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index fb79a1ac61a..aa2e8f64b8a 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/fetch.sgml PostgreSQL documentation --> -<refentry id="SQL-FETCH"> +<refentry id="sql-fetch"> <indexterm zone="sql-fetch"> <primary>FETCH</primary> diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index fd9fe03a6ad..475c85b835e 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/grant.sgml PostgreSQL documentation --> -<refentry id="SQL-GRANT"> +<refentry id="sql-grant"> <indexterm zone="sql-grant"> <primary>GRANT</primary> </indexterm> @@ -429,7 +429,7 @@ GRANT <replaceable class="parameter">role_name</replaceable> [, ...] TO <replace </refsect1> - <refsect1 id="SQL-GRANT-notes"> + <refsect1 id="sql-grant-notes"> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/import_foreign_schema.sgml b/doc/src/sgml/ref/import_foreign_schema.sgml index 9bc83f1c6a6..66c8462a5a8 100644 --- a/doc/src/sgml/ref/import_foreign_schema.sgml +++ b/doc/src/sgml/ref/import_foreign_schema.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/import_foreign_schema.sgml PostgreSQL documentation --> -<refentry id="SQL-IMPORTFOREIGNSCHEMA"> +<refentry id="sql-importforeignschema"> <indexterm zone="sql-importforeignschema"> <primary>IMPORT FOREIGN SCHEMA</primary> </indexterm> @@ -29,7 +29,7 @@ IMPORT FOREIGN SCHEMA <replaceable class="parameter">remote_schema</replaceable> </synopsis> </refsynopsisdiv> - <refsect1 id="SQL-IMPORTFOREIGNSCHEMA-description"> + <refsect1 id="sql-importforeignschema-description"> <title>Description</title> <para> @@ -120,7 +120,7 @@ IMPORT FOREIGN SCHEMA <replaceable class="parameter">remote_schema</replaceable> </variablelist> </refsect1> - <refsect1 id="SQL-IMPORTFOREIGNSCHEMA-examples"> + <refsect1 id="sql-importforeignschema-examples"> <title>Examples</title> <para> @@ -144,7 +144,7 @@ IMPORT FOREIGN SCHEMA foreign_films LIMIT TO (actors, directors) </programlisting></para> </refsect1> - <refsect1 id="SQL-IMPORTFOREIGNSCHEMA-compatibility"> + <refsect1 id="sql-importforeignschema-compatibility"> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index 6696d4d05ab..9a02bc1dbb1 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/initdb.sgml PostgreSQL documentation --> -<refentry id="APP-INITDB"> +<refentry id="app-initdb"> <indexterm zone="app-initdb"> <primary>initdb</primary> </indexterm> @@ -33,7 +33,7 @@ PostgreSQL documentation </cmdsynopsis> </refsynopsisdiv> - <refsect1 id="R1-APP-INITDB-1"> + <refsect1 id="r1-app-initdb-1"> <title> Description </title> diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 7f44ec31d15..f13fad4dd68 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/insert.sgml PostgreSQL documentation --> -<refentry id="SQL-INSERT"> +<refentry id="sql-insert"> <indexterm zone="sql-insert"> <primary>INSERT</primary> </indexterm> @@ -128,7 +128,7 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac <refsect1> <title>Parameters</title> - <refsect2 id="SQL-INSERTING-PARAMS"> + <refsect2 id="sql-inserting-params"> <title id="sql-inserting-params-title">Inserting</title> <para> @@ -304,10 +304,10 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac <refsect2 id="sql-on-conflict"> <title id="sql-on-conflict-title"><literal>ON CONFLICT</literal> Clause</title> - <indexterm zone="SQL-INSERT"> + <indexterm zone="sql-insert"> <primary>UPSERT</primary> </indexterm> - <indexterm zone="SQL-INSERT"> + <indexterm zone="sql-insert"> <primary>ON CONFLICT</primary> </indexterm> <para> diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 65275627174..f4c25efbd04 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/listen.sgml PostgreSQL documentation --> -<refentry id="SQL-LISTEN"> +<refentry id="sql-listen"> <indexterm zone="sql-listen"> <primary>LISTEN</primary> </indexterm> diff --git a/doc/src/sgml/ref/load.sgml b/doc/src/sgml/ref/load.sgml index b9e3fe8b255..14886199dee 100644 --- a/doc/src/sgml/ref/load.sgml +++ b/doc/src/sgml/ref/load.sgml @@ -2,7 +2,7 @@ doc/src/sgml/ref/load.sgml --> -<refentry id="SQL-LOAD"> +<refentry id="sql-load"> <indexterm zone="sql-load"> <primary>LOAD</primary> </indexterm> diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 6d68ec6c53b..49e29339386 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/lock.sgml PostgreSQL documentation --> -<refentry id="SQL-LOCK"> +<refentry id="sql-lock"> <indexterm zone="sql-lock"> <primary>LOCK</primary> </indexterm> @@ -236,7 +236,7 @@ COMMIT WORK; There is no <command>LOCK TABLE</command> in the SQL standard, which instead uses <command>SET TRANSACTION</command> to specify concurrency levels on transactions. <productname>PostgreSQL</productname> supports that too; - see <xref linkend="SQL-SET-TRANSACTION"> for details. + see <xref linkend="sql-set-transaction"> for details. </para> <para> diff --git a/doc/src/sgml/ref/move.sgml b/doc/src/sgml/ref/move.sgml index 4bf78968588..50533e5e0ea 100644 --- a/doc/src/sgml/ref/move.sgml +++ b/doc/src/sgml/ref/move.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/move.sgml PostgreSQL documentation --> -<refentry id="SQL-MOVE"> +<refentry id="sql-move"> <indexterm zone="sql-move"> <primary>MOVE</primary> </indexterm> diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index 4376b9fdd73..481163634fa 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/notify.sgml PostgreSQL documentation --> -<refentry id="SQL-NOTIFY"> +<refentry id="sql-notify"> <indexterm zone="sql-notify"> <primary>NOTIFY</primary> </indexterm> diff --git a/doc/src/sgml/ref/pg_basebackup.sgml b/doc/src/sgml/ref/pg_basebackup.sgml index 1944c185cb9..167d523f5dc 100644 --- a/doc/src/sgml/ref/pg_basebackup.sgml +++ b/doc/src/sgml/ref/pg_basebackup.sgml @@ -45,7 +45,7 @@ PostgreSQL documentation out of backup mode automatically. Backups are always taken of the entire database cluster; it is not possible to back up individual databases or database objects. For individual database backups, a tool such as - <xref linkend="APP-PGDUMP"> must be used. + <xref linkend="app-pgdump"> must be used. </para> <para> @@ -768,7 +768,7 @@ PostgreSQL documentation <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="APP-PGDUMP"></member> + <member><xref linkend="app-pgdump"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/pg_controldata.sgml b/doc/src/sgml/ref/pg_controldata.sgml index 4d4feacb931..9a676e0a78b 100644 --- a/doc/src/sgml/ref/pg_controldata.sgml +++ b/doc/src/sgml/ref/pg_controldata.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/pg_controldata.sgml PostgreSQL documentation --> -<refentry id="APP-PGCONTROLDATA"> +<refentry id="app-pgcontroldata"> <indexterm zone="app-pgcontroldata"> <primary>pg_controldata</primary> </indexterm> @@ -27,7 +27,7 @@ PostgreSQL documentation </cmdsynopsis> </refsynopsisdiv> - <refsect1 id="R1-APP-PGCONTROLDATA-1"> + <refsect1 id="r1-app-pgcontroldata-1"> <title>Description</title> <para> <command>pg_controldata</command> prints information initialized during diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/sgml/ref/pg_ctl-ref.sgml index 3bcf0a2e9f0..f930c7e2452 100644 --- a/doc/src/sgml/ref/pg_ctl-ref.sgml +++ b/doc/src/sgml/ref/pg_ctl-ref.sgml @@ -610,10 +610,10 @@ PostgreSQL documentation </refsect1> - <refsect1 id="R1-APP-PGCTL-2"> + <refsect1 id="r1-app-pgctl-2"> <title>Examples</title> - <refsect2 id="R2-APP-PGCTL-3"> + <refsect2 id="r2-app-pgctl-3"> <title>Starting the Server</title> <para> @@ -632,7 +632,7 @@ PostgreSQL documentation </screen></para> </refsect2> - <refsect2 id="R2-APP-PGCTL-4"> + <refsect2 id="r2-app-pgctl-4"> <title>Stopping the Server</title> <para> To stop the server, use: @@ -646,7 +646,7 @@ PostgreSQL documentation </screen></para> </refsect2> - <refsect2 id="R2-APP-PGCTL-5"> + <refsect2 id="r2-app-pgctl-5"> <title>Restarting the Server</title> <para> @@ -668,7 +668,7 @@ PostgreSQL documentation </screen></para> </refsect2> - <refsect2 id="R2-APP-PGCTL-6"> + <refsect2 id="r2-app-pgctl-6"> <title>Showing the Server Status</title> <para> diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 79a9ee09830..57272e33bfe 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/pg_dump.sgml PostgreSQL documentation --> -<refentry id="APP-PGDUMP"> +<refentry id="app-pgdump"> <indexterm zone="app-pgdump"> <primary>pg_dump</primary> </indexterm> @@ -375,7 +375,7 @@ PostgreSQL documentation <replaceable class="parameter">schema</replaceable> parameter is interpreted as a pattern according to the same rules used by <application>psql</application>'s <literal>\d</literal> commands (see <xref - linkend="APP-PSQL-patterns" endterm="APP-PSQL-patterns-title">), + linkend="app-psql-patterns" endterm="app-psql-patterns-title">), so multiple schemas can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards; see @@ -526,7 +526,7 @@ PostgreSQL documentation <replaceable class="parameter">table</replaceable> parameter is interpreted as a pattern according to the same rules used by <application>psql</application>'s <literal>\d</literal> commands (see <xref - linkend="APP-PSQL-patterns" endterm="APP-PSQL-patterns-title">), + linkend="app-psql-patterns" endterm="app-psql-patterns-title">), so multiple tables can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards; see @@ -1374,7 +1374,7 @@ CREATE DATABASE foo WITH TEMPLATE template0; To specify an upper-case or mixed-case name in <option>-t</option> and related switches, you need to double-quote the name; else it will be folded to lower case (see <xref - linkend="APP-PSQL-patterns" endterm="APP-PSQL-patterns-title">). But + linkend="app-psql-patterns" endterm="app-psql-patterns-title">). But double quotes are special to the shell, so in turn they must be quoted. Thus, to dump a single table with a mixed-case name, you need something like diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 0a64c3548ef..ce6b895da28 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/pg_dumpall.sgml PostgreSQL documentation --> -<refentry id="APP-PG-DUMPALL"> +<refentry id="app-pg-dumpall"> <indexterm zone="app-pg-dumpall"> <primary>pg_dumpall</primary> </indexterm> diff --git a/doc/src/sgml/ref/pg_receivewal.sgml b/doc/src/sgml/ref/pg_receivewal.sgml index 5395fde6d6a..4d13c57ffa0 100644 --- a/doc/src/sgml/ref/pg_receivewal.sgml +++ b/doc/src/sgml/ref/pg_receivewal.sgml @@ -426,7 +426,7 @@ PostgreSQL documentation <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="APP-PGBASEBACKUP"></member> + <member><xref linkend="app-pgbasebackup"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/pg_recvlogical.sgml b/doc/src/sgml/ref/pg_recvlogical.sgml index 5add6113f3b..86f660070f1 100644 --- a/doc/src/sgml/ref/pg_recvlogical.sgml +++ b/doc/src/sgml/ref/pg_recvlogical.sgml @@ -279,7 +279,7 @@ PostgreSQL documentation <para> The database to connect to. See the description of the actions for what this means in detail. This can be a <application>libpq</application> connection string; - see <xref linkend="LIBPQ-CONNSTRING"> for more information. Defaults + see <xref linkend="libpq-connstring"> for more information. Defaults to user name. </para> </listitem> diff --git a/doc/src/sgml/ref/pg_resetwal.sgml b/doc/src/sgml/ref/pg_resetwal.sgml index c8e5790a8e7..0c30addd30b 100644 --- a/doc/src/sgml/ref/pg_resetwal.sgml +++ b/doc/src/sgml/ref/pg_resetwal.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/pg_resetwal.sgml PostgreSQL documentation --> -<refentry id="APP-PGRESETWAL"> +<refentry id="app-pgresetwal"> <indexterm zone="app-pgresetwal"> <primary>pg_resetwal</primary> </indexterm> @@ -29,7 +29,7 @@ PostgreSQL documentation </cmdsynopsis> </refsynopsisdiv> - <refsect1 id="R1-APP-PGRESETWAL-1"> + <refsect1 id="r1-app-pgresetwal-1"> <title>Description</title> <para> <command>pg_resetwal</command> clears the write-ahead log (WAL) and diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index ed535f6f89a..2b0a3340257 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -1,6 +1,6 @@ <!-- doc/src/sgml/ref/pg_restore.sgml --> -<refentry id="APP-PGRESTORE"> +<refentry id="app-pgrestore"> <indexterm zone="app-pgrestore"> <primary>pg_restore</primary> </indexterm> diff --git a/doc/src/sgml/ref/pg_waldump.sgml b/doc/src/sgml/ref/pg_waldump.sgml index 0b39726e30c..40049c51e54 100644 --- a/doc/src/sgml/ref/pg_waldump.sgml +++ b/doc/src/sgml/ref/pg_waldump.sgml @@ -29,7 +29,7 @@ PostgreSQL documentation </cmdsynopsis> </refsynopsisdiv> - <refsect1 id="R1-APP-PGWALDUMP-1"> + <refsect1 id="r1-app-pgwaldump-1"> <title>Description</title> <para> <command>pg_waldump</command> displays the write-ahead log (WAL) and is mainly diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index bcf188f4b94..fb91ef8d50f 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/prepare.sgml PostgreSQL documentation --> -<refentry id="SQL-PREPARE"> +<refentry id="sql-prepare"> <indexterm zone="sql-prepare"> <primary>PREPARE</primary> </indexterm> @@ -123,7 +123,7 @@ PREPARE <replaceable class="parameter">name</replaceable> [ ( <replaceable class </variablelist> </refsect1> - <refsect1 id="SQL-PREPARE-notes"> + <refsect1 id="sql-prepare-notes"> <title>Notes</title> <para> diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index 4f78e6b1313..6a1766ed3cb 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/prepare_transaction.sgml PostgreSQL documentation --> -<refentry id="SQL-PREPARE-TRANSACTION"> +<refentry id="sql-prepare-transaction"> <indexterm zone="sql-prepare-transaction"> <primary>PREPARE TRANSACTION</primary> </indexterm> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 8cbe0569cf4..e520cdf3ba1 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/psql-ref.sgml PostgreSQL documentation --> -<refentry id="APP-PSQL"> +<refentry id="app-psql"> <indexterm zone="app-psql"> <primary>psql</primary> </indexterm> @@ -45,7 +45,7 @@ PostgreSQL documentation </para> </refsect1> - <refsect1 id="R1-APP-PSQL-3"> + <refsect1 id="r1-app-psql-3"> <title>Options</title> <variablelist> @@ -629,7 +629,7 @@ EOF <refsect1> <title>Usage</title> - <refsect2 id="R2-APP-PSQL-connecting"> + <refsect2 id="r2-app-psql-connecting"> <title>Connecting to a Database</title> <para> @@ -701,7 +701,7 @@ $ <userinput>psql postgresql://dbmaster:5433/mydb?sslmode=require</userinput> </para> </refsect2> - <refsect2 id="R2-APP-PSQL-4"> + <refsect2 id="r2-app-psql-4"> <title>Entering SQL Commands</title> <para> @@ -730,8 +730,8 @@ testdb=> <para> Whenever a command is executed, <application>psql</application> also polls for asynchronous notification events generated by - <xref linkend="SQL-LISTEN"> and - <xref linkend="SQL-NOTIFY">. + <xref linkend="sql-listen"> and + <xref linkend="sql-notify">. </para> <para> @@ -741,7 +741,7 @@ testdb=> </para> </refsect2> - <refsect2 id="APP-PSQL-meta-commands"> + <refsect2 id="app-psql-meta-commands"> <title>Meta-Commands</title> <para> @@ -779,7 +779,7 @@ testdb=> If an unquoted colon (<literal>:</literal>) followed by a <application>psql</application> variable name appears within an argument, it is replaced by the variable's value, as described in <xref - linkend="APP-PSQL-interpolation" endterm="APP-PSQL-interpolation-title">. + linkend="app-psql-interpolation" endterm="app-psql-interpolation-title">. The forms <literal>:'<replaceable>variable_name</replaceable>'</literal> and <literal>:"<replaceable>variable_name</replaceable>"</literal> described there work as well. @@ -949,7 +949,7 @@ testdb=> </listitem> </varlistentry> - <varlistentry id="APP-PSQL-meta-commands-copy"> + <varlistentry id="app-psql-meta-commands-copy"> <term><literal>\copy { <replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column_list</replaceable> ) ] | ( <replaceable class="parameter">query</replaceable> ) } { <literal>from</literal> | <literal>to</literal> } { <replaceable class="parameter">'filename'</replaceable> | program <replaceable class="parameter">'command'</replaceable> | stdin | stdout | pstdin | pstdout } @@ -958,7 +958,7 @@ testdb=> <listitem> <para> Performs a frontend (client) copy. This is an operation that - runs an <acronym>SQL</acronym> <xref linkend="SQL-COPY"> + runs an <acronym>SQL</acronym> <xref linkend="sql-copy"> command, but instead of the server reading or writing the specified file, <application>psql</application> reads or writes the file and @@ -1028,7 +1028,7 @@ testdb=> </varlistentry> - <varlistentry id="APP-PSQL-meta-commands-crosstabview"> + <varlistentry id="app-psql-meta-commands-crosstabview"> <term><literal>\crosstabview [ <replaceable class="parameter">colV</replaceable> [ <replaceable class="parameter">colH</replaceable> @@ -1102,7 +1102,7 @@ testdb=> <varlistentry> - <term><literal>\d[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\d[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1116,7 +1116,7 @@ testdb=> also shown. For foreign tables, the associated foreign server is shown as well. (<quote>Matching the pattern</quote> is defined in - <xref linkend="APP-PSQL-patterns" endterm="APP-PSQL-patterns-title"> + <xref linkend="app-psql-patterns" endterm="app-psql-patterns-title"> below.) </para> @@ -1131,7 +1131,7 @@ testdb=> more information is displayed: any comments associated with the columns of the table are shown, as is the presence of OIDs in the table, the view definition if the relation is a view, a non-default - <link linkend="SQL-CREATETABLE-REPLICA-IDENTITY">replica + <link linkend="sql-createtable-replica-identity">replica identity</link> setting. </para> @@ -1155,7 +1155,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\da[S] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\da[S] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1171,7 +1171,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dA[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dA[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1185,7 +1185,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\db[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\db[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1201,7 +1201,7 @@ testdb=> <varlistentry> - <term><literal>\dc[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dc[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists conversions between character-set encodings. @@ -1219,7 +1219,7 @@ testdb=> <varlistentry> - <term><literal>\dC[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dC[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists type casts. @@ -1234,7 +1234,7 @@ testdb=> <varlistentry> - <term><literal>\dd[S] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dd[S] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Shows the descriptions of objects of type <literal>constraint</literal>, @@ -1263,7 +1263,7 @@ testdb=> <varlistentry> - <term><literal>\dD[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dD[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists domains. If <replaceable @@ -1280,7 +1280,7 @@ testdb=> <varlistentry> - <term><literal>\ddp [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\ddp [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists default access privilege settings. An entry is shown for @@ -1302,12 +1302,12 @@ testdb=> <varlistentry> - <term><literal>\dE[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\di[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dm[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\ds[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dt[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dv[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dE[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\di[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dm[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\ds[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dt[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dv[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1333,7 +1333,7 @@ testdb=> <varlistentry> - <term><literal>\des[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\des[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign servers (mnemonic: <quote>external @@ -1349,7 +1349,7 @@ testdb=> <varlistentry> - <term><literal>\det[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\det[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign tables (mnemonic: <quote>external tables</quote>). @@ -1364,7 +1364,7 @@ testdb=> <varlistentry> - <term><literal>\deu[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\deu[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists user mappings (mnemonic: <quote>external @@ -1387,7 +1387,7 @@ testdb=> <varlistentry> - <term><literal>\dew[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dew[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign-data wrappers (mnemonic: <quote>external @@ -1403,7 +1403,7 @@ testdb=> <varlistentry> - <term><literal>\df[antwS+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\df[antwS+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1437,7 +1437,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dF[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dF[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search configurations. @@ -1451,7 +1451,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFd[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFd[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search dictionaries. @@ -1465,7 +1465,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFp[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFp[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search parsers. @@ -1479,7 +1479,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFt[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFt[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search templates. @@ -1493,7 +1493,7 @@ testdb=> <varlistentry> - <term><literal>\dg[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dg[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists database roles. @@ -1523,7 +1523,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dL[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dL[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists procedural languages. If <replaceable @@ -1540,7 +1540,7 @@ testdb=> <varlistentry> - <term><literal>\dn[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dn[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1557,7 +1557,7 @@ testdb=> <varlistentry> - <term><literal>\do[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\do[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists operators with their operand and result types. @@ -1575,7 +1575,7 @@ testdb=> <varlistentry> - <term><literal>\dO[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dO[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists collations. @@ -1595,7 +1595,7 @@ testdb=> <varlistentry> - <term><literal>\dp [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dp [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists tables, views and sequences with their @@ -1616,7 +1616,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\drds [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">role-pattern</replaceable></link> [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">database-pattern</replaceable></link> ] ]</literal></term> + <term><literal>\drds [ <link linkend="app-psql-patterns"><replaceable class="parameter">role-pattern</replaceable></link> [ <link linkend="app-psql-patterns"><replaceable class="parameter">database-pattern</replaceable></link> ] ]</literal></term> <listitem> <para> Lists defined configuration settings. These settings can be @@ -1638,7 +1638,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dRp[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dRp[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists replication publications. @@ -1652,7 +1652,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dRs[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dRs[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists replication subscriptions. @@ -1666,7 +1666,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dT[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dT[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists data types. @@ -1683,7 +1683,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\du[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\du[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists database roles. @@ -1702,7 +1702,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dx[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dx[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists installed extensions. @@ -1716,7 +1716,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dy[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dy[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists event triggers. @@ -2027,7 +2027,7 @@ CREATE INDEX <para> Sends the current query buffer to the server and stores the query's output into <application>psql</application> variables (see <xref - linkend="APP-PSQL-variables" endterm="APP-PSQL-variables-title">). + linkend="app-psql-variables" endterm="app-psql-variables-title">). The query to be executed must return exactly one row. Each column of the row is stored into a separate variable, named the same as the column. For example: @@ -2253,7 +2253,7 @@ SELECT <varlistentry> - <term><literal>\l[+]</literal> or <literal>\list[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\l[+]</literal> or <literal>\list[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> List the databases in the server and show their names, owners, @@ -2831,8 +2831,8 @@ lo_import 152801 <para> Illustrations of how these different formats look can be seen in - the <xref linkend="APP-PSQL-examples" - endterm="APP-PSQL-examples-title"> section. + the <xref linkend="app-psql-examples" + endterm="app-psql-examples-title"> section. </para> <tip> @@ -2917,8 +2917,8 @@ lo_import 152801 <para> Valid variable names can contain letters, digits, and underscores. See the section <xref - linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title"> below for details. + linkend="app-psql-variables" + endterm="app-psql-variables-title"> below for details. Variable names are case-sensitive. </para> @@ -2926,14 +2926,14 @@ lo_import 152801 Certain variables are special, in that they control <application>psql</application>'s behavior or are automatically set to reflect connection state. These variables are - documented in <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title">, below. + documented in <xref linkend="app-psql-variables" + endterm="app-psql-variables-title">, below. </para> <note> <para> This command is unrelated to the <acronym>SQL</acronym> - command <xref linkend="SQL-SET">. + command <xref linkend="sql-set">. </para> </note> </listitem> @@ -3070,8 +3070,8 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput> Most variables that control <application>psql</application>'s behavior cannot be unset; instead, an <literal>\unset</literal> command is interpreted as setting them to their default values. - See <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title">, below. + See <xref linkend="app-psql-variables" + endterm="app-psql-variables-title">, below. </para> </listitem> </varlistentry> @@ -3131,7 +3131,7 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput> <varlistentry> - <term><literal>\z [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\z [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists tables, views and sequences with their @@ -3229,8 +3229,8 @@ select 1\; select 2\; select 3; </variablelist> </para> - <refsect3 id="APP-PSQL-patterns"> - <title id="APP-PSQL-patterns-title">Patterns</title> + <refsect3 id="app-psql-patterns"> + <title id="app-psql-patterns-title">Patterns</title> <indexterm> <primary>patterns</primary> @@ -3322,8 +3322,8 @@ select 1\; select 2\; select 3; <refsect2> <title>Advanced Features</title> - <refsect3 id="APP-PSQL-variables"> - <title id="APP-PSQL-variables-title">Variables</title> + <refsect3 id="app-psql-variables"> + <title id="app-psql-variables-title">Variables</title> <para> <application>psql</application> provides variable substitution @@ -3347,8 +3347,8 @@ testdb=> <userinput>\echo :foo</userinput> bar </programlisting> This works in both regular SQL commands and meta-commands; there is - more detail in <xref linkend="APP-PSQL-interpolation" - endterm="APP-PSQL-interpolation-title">, below. + more detail in <xref linkend="app-psql-interpolation" + endterm="app-psql-interpolation-title">, below. </para> <para> @@ -3742,8 +3742,8 @@ bar <para> These specify what the prompts <application>psql</application> issues should look like. See <xref - linkend="APP-PSQL-prompting" - endterm="APP-PSQL-prompting-title"> below. + linkend="app-psql-prompting" + endterm="app-psql-prompting-title"> below. </para> </listitem> </varlistentry> @@ -3875,8 +3875,8 @@ bar </refsect3> - <refsect3 id="APP-PSQL-interpolation"> - <title id="APP-PSQL-interpolation-title"><acronym>SQL</acronym> Interpolation</title> + <refsect3 id="app-psql-interpolation"> + <title id="app-psql-interpolation-title"><acronym>SQL</acronym> Interpolation</title> <para> A key feature of <application>psql</application> @@ -3960,8 +3960,8 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:'content');</userinput> </refsect3> - <refsect3 id="APP-PSQL-prompting"> - <title id="APP-PSQL-prompting-title">Prompting</title> + <refsect3 id="app-psql-prompting"> + <title id="app-psql-prompting-title">Prompting</title> <para> The prompts <application>psql</application> issues can be customized @@ -4118,8 +4118,8 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:'content');</userinput> <para> The value of the <application>psql</application> variable <replaceable class="parameter">name</replaceable>. See the - section <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title"> for details. + section <xref linkend="app-psql-variables" + endterm="app-psql-variables-title"> for details. </para> </listitem> </varlistentry> @@ -4499,8 +4499,8 @@ PSQL_EDITOR_LINENUMBER_ARG='--line ' </refsect1> - <refsect1 id="APP-PSQL-examples"> - <title id="APP-PSQL-examples-title">Examples</title> + <refsect1 id="app-psql-examples"> + <title id="app-psql-examples-title">Examples</title> <para> The first example shows how to spread a command over several lines of diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index 2bbd6b8f07a..e29b88292be 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/reassign_owned.sgml PostgreSQL documentation --> -<refentry id="SQL-REASSIGN-OWNED"> +<refentry id="sql-reassign-owned"> <indexterm zone="sql-reassign-owned"> <primary>REASSIGN OWNED</primary> </indexterm> diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml index 0135d15cece..e2ee836efb9 100644 --- a/doc/src/sgml/ref/refresh_materialized_view.sgml +++ b/doc/src/sgml/ref/refresh_materialized_view.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/refresh_materialized_view.sgml PostgreSQL documentation --> -<refentry id="SQL-REFRESHMATERIALIZEDVIEW"> +<refentry id="sql-refreshmaterializedview"> <indexterm zone="sql-refreshmaterializedview"> <primary>REFRESH MATERIALIZED VIEW</primary> </indexterm> @@ -93,7 +93,7 @@ REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] <replaceable class="parameter">name</ <para> While the default index for future - <xref linkend="SQL-CLUSTER"> + <xref linkend="sql-cluster"> operations is retained, <command>REFRESH MATERIALIZED VIEW</command> does not order the generated rows based on this property. If you want the data to be ordered upon generation, you must use an <literal>ORDER BY</literal> diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 3dc2608f76e..2e053c4c24d 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/reindex.sgml PostgreSQL documentation --> -<refentry id="SQL-REINDEX"> +<refentry id="sql-reindex"> <indexterm zone="sql-reindex"> <primary>REINDEX</primary> </indexterm> diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 627be6a0add..a7cc9c2d946 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/reindexdb.sgml PostgreSQL documentation --> -<refentry id="APP-REINDEXDB"> +<refentry id="app-reindexdb"> <indexterm zone="app-reindexdb"> <primary>reindexdb</primary> </indexterm> @@ -93,7 +93,7 @@ PostgreSQL documentation <para> <application>reindexdb</application> is a wrapper around the SQL - command <xref linkend="SQL-REINDEX">. + command <xref linkend="sql-reindex">. There is no effective difference between reindexing databases via this utility and via other methods for accessing the server. </para> @@ -357,8 +357,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-REINDEX"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-reindex"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/release_savepoint.sgml b/doc/src/sgml/ref/release_savepoint.sgml index 2e8dcc0746e..7e629176b71 100644 --- a/doc/src/sgml/ref/release_savepoint.sgml +++ b/doc/src/sgml/ref/release_savepoint.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/release_savepoint.sgml PostgreSQL documentation --> -<refentry id="SQL-RELEASE-SAVEPOINT"> +<refentry id="sql-release-savepoint"> <indexterm zone="sql-release-savepoint"> <primary>RELEASE SAVEPOINT</primary> </indexterm> diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index b434ad10c28..bf3f5226ec2 100644 --- a/doc/src/sgml/ref/reset.sgml +++ b/doc/src/sgml/ref/reset.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/reset.sgml PostgreSQL documentation --> -<refentry id="SQL-RESET"> +<refentry id="sql-reset"> <indexterm zone="sql-reset"> <primary>RESET</primary> </indexterm> @@ -106,8 +106,8 @@ RESET timezone; <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="SQL-SET"></member> - <member><xref linkend="SQL-SHOW"></member> + <member><xref linkend="sql-set"></member> + <member><xref linkend="sql-show"></member> </simplelist> </refsect1> </refentry> diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index c893666e83a..e3e3f2ffc3f 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/revoke.sgml PostgreSQL documentation --> -<refentry id="SQL-REVOKE"> +<refentry id="sql-revoke"> <indexterm zone="sql-revoke"> <primary>REVOKE</primary> </indexterm> @@ -111,7 +111,7 @@ REVOKE [ ADMIN OPTION FOR ] </synopsis> </refsynopsisdiv> - <refsect1 id="SQL-REVOKE-description"> + <refsect1 id="sql-revoke-description"> <title>Description</title> <para> @@ -174,7 +174,7 @@ REVOKE [ ADMIN OPTION FOR ] </para> </refsect1> - <refsect1 id="SQL-REVOKE-notes"> + <refsect1 id="sql-revoke-notes"> <title>Notes</title> <para> @@ -246,7 +246,7 @@ REVOKE [ ADMIN OPTION FOR ] </para> </refsect1> - <refsect1 id="SQL-REVOKE-examples"> + <refsect1 id="sql-revoke-examples"> <title>Examples</title> <para> @@ -278,7 +278,7 @@ REVOKE admins FROM joe; </programlisting></para> </refsect1> - <refsect1 id="SQL-REVOKE-compatibility"> + <refsect1 id="sql-revoke-compatibility"> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index 1a0e5a0ebcf..1f99343b08d 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/rollback.sgml PostgreSQL documentation --> -<refentry id="SQL-ROLLBACK"> +<refentry id="sql-rollback"> <indexterm zone="sql-rollback"> <primary>ROLLBACK</primary> </indexterm> @@ -54,7 +54,7 @@ ROLLBACK [ WORK | TRANSACTION ] <title>Notes</title> <para> - Use <xref linkend="SQL-COMMIT"> to + Use <xref linkend="sql-commit"> to successfully terminate a transaction. </para> diff --git a/doc/src/sgml/ref/rollback_prepared.sgml b/doc/src/sgml/ref/rollback_prepared.sgml index 6c44049a898..d7468f78d72 100644 --- a/doc/src/sgml/ref/rollback_prepared.sgml +++ b/doc/src/sgml/ref/rollback_prepared.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/rollback_prepared.sgml PostgreSQL documentation --> -<refentry id="SQL-ROLLBACK-PREPARED"> +<refentry id="sql-rollback-prepared"> <indexterm zone="sql-rollback-prepared"> <primary>ROLLBACK PREPARED</primary> </indexterm> diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml index f1da804f67f..1957cace117 100644 --- a/doc/src/sgml/ref/rollback_to.sgml +++ b/doc/src/sgml/ref/rollback_to.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/rollback_to.sgml PostgreSQL documentation --> -<refentry id="SQL-ROLLBACK-TO"> +<refentry id="sql-rollback-to"> <indexterm zone="sql-rollback-to"> <primary>ROLLBACK TO SAVEPOINT</primary> </indexterm> @@ -64,7 +64,7 @@ ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] <replaceable>savepoint_name</re <title>Notes</title> <para> - Use <xref linkend="SQL-RELEASE-SAVEPOINT"> to destroy a savepoint + Use <xref linkend="sql-release-savepoint"> to destroy a savepoint without discarding the effects of commands executed after it was established. </para> diff --git a/doc/src/sgml/ref/savepoint.sgml b/doc/src/sgml/ref/savepoint.sgml index 6d40f4da420..6fa11a7358f 100644 --- a/doc/src/sgml/ref/savepoint.sgml +++ b/doc/src/sgml/ref/savepoint.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/savepoint.sgml PostgreSQL documentation --> -<refentry id="SQL-SAVEPOINT"> +<refentry id="sql-savepoint"> <indexterm zone="sql-savepoint"> <primary>SAVEPOINT</primary> </indexterm> @@ -64,8 +64,8 @@ SAVEPOINT <replaceable>savepoint_name</replaceable> <title>Notes</title> <para> - Use <xref linkend="SQL-ROLLBACK-TO"> to - rollback to a savepoint. Use <xref linkend="SQL-RELEASE-SAVEPOINT"> + Use <xref linkend="sql-rollback-to"> to + rollback to a savepoint. Use <xref linkend="sql-release-savepoint"> to destroy a savepoint, keeping the effects of commands executed after it was established. </para> diff --git a/doc/src/sgml/ref/security_label.sgml b/doc/src/sgml/ref/security_label.sgml index 999f9c80cd5..ce5a1c19754 100644 --- a/doc/src/sgml/ref/security_label.sgml +++ b/doc/src/sgml/ref/security_label.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/security_label.sgml PostgreSQL documentation --> -<refentry id="SQL-SECURITY-LABEL"> +<refentry id="sql-security-label"> <indexterm zone="sql-security-label"> <primary>SECURITY LABEL</primary> </indexterm> diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 7355e790f69..3aab3fd8a72 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/select.sgml PostgreSQL documentation --> -<refentry id="SQL-SELECT"> +<refentry id="sql-select"> <indexterm zone="sql-select"> <primary>SELECT</primary> </indexterm> @@ -218,7 +218,7 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] <refsect1> <title>Parameters</title> - <refsect2 id="SQL-WITH"> + <refsect2 id="sql-with"> <title id="sql-with-title"><literal>WITH</literal> Clause</title> <para> @@ -295,7 +295,7 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] </para> </refsect2> - <refsect2 id="SQL-FROM"> + <refsect2 id="sql-from"> <title id="sql-from-title"><literal>FROM</literal> Clause</title> <para> @@ -666,7 +666,7 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] </para> </refsect2> - <refsect2 id="SQL-WHERE"> + <refsect2 id="sql-where"> <title id="sql-where-title"><literal>WHERE</literal> Clause</title> <para> @@ -683,7 +683,7 @@ WHERE <replaceable class="parameter">condition</replaceable> </para> </refsect2> - <refsect2 id="SQL-GROUPBY"> + <refsect2 id="sql-groupby"> <title id="sql-groupby-title"><literal>GROUP BY</literal> Clause</title> <para> @@ -757,7 +757,7 @@ GROUP BY <replaceable class="parameter">grouping_element</replaceable> [, ...] </para> </refsect2> - <refsect2 id="SQL-HAVING"> + <refsect2 id="sql-having"> <title id="sql-having-title"><literal>HAVING</literal> Clause</title> <para> @@ -800,7 +800,7 @@ HAVING <replaceable class="parameter">condition</replaceable> </para> </refsect2> - <refsect2 id="SQL-WINDOW"> + <refsect2 id="sql-window"> <title id="sql-window-title"><literal>WINDOW</literal> Clause</title> <para> @@ -1073,7 +1073,7 @@ SELECT DISTINCT ON (location) location, time, report </para> </refsect2> - <refsect2 id="SQL-UNION"> + <refsect2 id="sql-union"> <title id="sql-union-title"><literal>UNION</literal> Clause</title> <para> @@ -1126,7 +1126,7 @@ SELECT DISTINCT ON (location) location, time, report </para> </refsect2> - <refsect2 id="SQL-INTERSECT"> + <refsect2 id="sql-intersect"> <title id="sql-intersect-title"><literal>INTERSECT</literal> Clause</title> <para> @@ -1174,7 +1174,7 @@ SELECT DISTINCT ON (location) location, time, report </para> </refsect2> - <refsect2 id="SQL-EXCEPT"> + <refsect2 id="sql-except"> <title id="sql-except-title"><literal>EXCEPT</literal> Clause</title> <para> @@ -1218,7 +1218,7 @@ SELECT DISTINCT ON (location) location, time, report </para> </refsect2> - <refsect2 id="SQL-ORDERBY"> + <refsect2 id="sql-orderby"> <title id="sql-orderby-title"><literal>ORDER BY</literal> Clause</title> <para> @@ -1316,7 +1316,7 @@ SELECT name FROM distributors ORDER BY code; </para> </refsect2> - <refsect2 id="SQL-LIMIT"> + <refsect2 id="sql-limit"> <title id="sql-limit-title"><literal>LIMIT</literal> Clause</title> <para> @@ -1396,7 +1396,7 @@ FETCH { FIRST | NEXT } [ <replaceable class="parameter">count</replaceable> ] { </para> </refsect2> - <refsect2 id="SQL-FOR-UPDATE-SHARE"> + <refsect2 id="sql-for-update-share"> <title id="sql-for-update-share-title">The Locking Clause</title> <para> @@ -1560,7 +1560,7 @@ SELECT * FROM (SELECT * FROM mytable FOR UPDATE) ss ORDER BY column1; </caution> </refsect2> - <refsect2 id="SQL-TABLE"> + <refsect2 id="sql-table"> <title><literal>TABLE</literal> Command</title> <para> diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index 63c02349aa4..a5b6ac9245a 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/select_into.sgml PostgreSQL documentation --> -<refentry id="SQL-SELECTINTO"> +<refentry id="sql-selectinto"> <indexterm zone="sql-selectinto"> <primary>SELECT INTO</primary> </indexterm> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 8c44d0e156d..4bc8108765c 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/set.sgml PostgreSQL documentation --> -<refentry id="SQL-SET"> +<refentry id="sql-set"> <indexterm zone="sql-set"> <primary>SET</primary> </indexterm> @@ -323,8 +323,8 @@ SET TIME ZONE 'Europe/Rome'; <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="SQL-RESET"></member> - <member><xref linkend="SQL-SHOW"></member> + <member><xref linkend="sql-reset"></member> + <member><xref linkend="sql-show"></member> </simplelist> </refsect1> </refentry> diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 237a0a3988f..671332afc7a 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -1,5 +1,5 @@ <!-- doc/src/sgml/ref/set_constraints.sgml --> -<refentry id="SQL-SET-CONSTRAINTS"> +<refentry id="sql-set-constraints"> <indexterm zone="sql-set-constraints"> <primary>SET CONSTRAINTS</primary> </indexterm> diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index eac4b3405ae..351e953f757 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/set_role.sgml PostgreSQL documentation --> -<refentry id="SQL-SET-ROLE"> +<refentry id="sql-set-role"> <indexterm zone="sql-set-role"> <primary>SET ROLE</primary> </indexterm> @@ -48,7 +48,7 @@ RESET ROLE <para> The <literal>SESSION</literal> and <literal>LOCAL</literal> modifiers act the same - as for the regular <xref linkend="SQL-SET"> + as for the regular <xref linkend="sql-set"> command. </para> diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index a8aee6f6323..45fa378e188 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -1,5 +1,5 @@ <!-- doc/src/sgml/ref/set_session_auth.sgml --> -<refentry id="SQL-SET-SESSION-AUTHORIZATION"> +<refentry id="sql-set-session-authorization"> <indexterm zone="sql-set-session-authorization"> <primary>SET SESSION AUTHORIZATION</primary> </indexterm> @@ -54,7 +54,7 @@ RESET SESSION AUTHORIZATION <para> The <literal>SESSION</literal> and <literal>LOCAL</literal> modifiers act the same - as for the regular <xref linkend="SQL-SET"> + as for the regular <xref linkend="sql-set"> command. </para> diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index f5631372f56..3ab1e6f7719 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -1,5 +1,5 @@ <!-- doc/src/sgml/ref/set_transaction.sgml --> -<refentry id="SQL-SET-TRANSACTION"> +<refentry id="sql-set-transaction"> <indexterm zone="sql-set-transaction"> <primary>SET TRANSACTION</primary> </indexterm> @@ -237,7 +237,7 @@ SET TRANSACTION SNAPSHOT '00000003-0000001B-1'; </programlisting></para> </refsect1> - <refsect1 id="R1-SQL-SET-TRANSACTION-3"> + <refsect1 id="r1-sql-set-transaction-3"> <title>Compatibility</title> <para> diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml index 2a2b2fbb9f3..53b47ac3d8f 100644 --- a/doc/src/sgml/ref/show.sgml +++ b/doc/src/sgml/ref/show.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/show.sgml PostgreSQL documentation --> -<refentry id="SQL-SHOW"> +<refentry id="sql-show"> <indexterm zone="sql-show"> <primary>SHOW</primary> </indexterm> @@ -52,7 +52,7 @@ SHOW ALL <para> The name of a run-time parameter. Available parameters are documented in <xref linkend="runtime-config"> and on the <xref - linkend="SQL-SET"> reference page. In + linkend="sql-set"> reference page. In addition, there are a few parameters that can be shown but not set: @@ -192,8 +192,8 @@ SHOW ALL; <title>See Also</title> <simplelist type="inline"> - <member><xref linkend="SQL-SET"></member> - <member><xref linkend="SQL-RESET"></member> + <member><xref linkend="sql-set"></member> + <member><xref linkend="sql-reset"></member> </simplelist> </refsect1> diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index 8dcf6318d23..605fda53575 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/start_transaction.sgml PostgreSQL documentation --> -<refentry id="SQL-START-TRANSACTION"> +<refentry id="sql-start-transaction"> <indexterm zone="sql-start-transaction"> <primary>START TRANSACTION</primary> </indexterm> diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index 80abe675253..68925169879 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/truncate.sgml PostgreSQL documentation --> -<refentry id="SQL-TRUNCATE"> +<refentry id="sql-truncate"> <indexterm zone="sql-truncate"> <primary>TRUNCATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index 1ea9aa3a0bd..1bffac3cb2c 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/unlisten.sgml PostgreSQL documentation --> -<refentry id="SQL-UNLISTEN"> +<refentry id="sql-unlisten"> <indexterm zone="sql-unlisten"> <primary>UNLISTEN</primary> </indexterm> diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index 1ede52384f3..0e99aa97398 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/update.sgml PostgreSQL documentation --> -<refentry id="SQL-UPDATE"> +<refentry id="sql-update"> <indexterm zone="sql-update"> <primary>UPDATE</primary> </indexterm> diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index 2e205668c1c..7ecd08977c5 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/vacuum.sgml PostgreSQL documentation --> -<refentry id="SQL-VACUUM"> +<refentry id="sql-vacuum"> <indexterm zone="sql-vacuum"> <primary>VACUUM</primary> </indexterm> diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 277c231687b..2d47d8c1f11 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/vacuumdb.sgml PostgreSQL documentation --> -<refentry id="APP-VACUUMDB"> +<refentry id="app-vacuumdb"> <indexterm zone="app-vacuumdb"> <primary>vacuumdb</primary> </indexterm> @@ -62,7 +62,7 @@ PostgreSQL documentation <para> <application>vacuumdb</application> is a wrapper around the SQL - command <xref linkend="SQL-VACUUM">. + command <xref linkend="sql-vacuum">. There is no effective difference between vacuuming and analyzing databases via this utility and via other methods for accessing the server. @@ -382,8 +382,8 @@ PostgreSQL documentation <title>Diagnostics</title> <para> - In case of difficulty, see <xref linkend="SQL-VACUUM"> - and <xref linkend="APP-PSQL"> for + In case of difficulty, see <xref linkend="sql-vacuum"> + and <xref linkend="app-psql"> for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 75a594725b8..6b8083fc9d3 100644 --- a/doc/src/sgml/ref/values.sgml +++ b/doc/src/sgml/ref/values.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/values.sgml PostgreSQL documentation --> -<refentry id="SQL-VALUES"> +<refentry id="sql-values"> <indexterm zone="sql-values"> <primary>VALUES</primary> </indexterm> |