diff options
Diffstat (limited to 'doc/src/sgml/ref')
70 files changed, 204 insertions, 200 deletions
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index 03729133651..16b5602487d 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -33,7 +33,7 @@ ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] 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"/>, + <link linkend="sql-rollback"><command>ROLLBACK</command></link>, and is present only for historical reasons. </para> </refsect1> @@ -57,8 +57,8 @@ ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] <listitem> <para> If <literal>AND CHAIN</literal> is specified, a new transaction is - immediately started with the same transaction characteristics (see <xref - linkend="sql-set-transaction"/>) as the just finished one. Otherwise, + immediately started with the same transaction characteristics (see <link + linkend="sql-set-transaction"><command>SET TRANSACTION</command></link>) as the just finished one. Otherwise, no new transaction is started. </para> </listitem> @@ -70,7 +70,7 @@ ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] <title>Notes</title> <para> - Use <xref linkend="sql-commit"/> to + Use <link linkend="sql-commit"><command>COMMIT</command></link> 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 95934a100f8..aee10a5ca2e 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -142,7 +142,7 @@ ALTER AGGREGATE <replaceable>name</replaceable> ( <replaceable>aggregate_signatu The recommended syntax for referencing an ordered-set aggregate is to write <literal>ORDER BY</literal> between the direct and aggregated argument specifications, in the same style as in - <xref linkend="sql-createaggregate"/>. However, it will also work to + <link linkend="sql-createaggregate"><command>CREATE AGGREGATE</command></link>. However, it will also work to omit <literal>ORDER BY</literal> and just run the direct and aggregated argument specifications into a single list. In this abbreviated form, if <literal>VARIADIC "any"</literal> was used in both the direct and diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index afa42b4926f..2db53725139 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -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"/>. + <link linkend="sql-createdomain"><command>CREATE DOMAIN</command></link>. 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 diff --git a/doc/src/sgml/ref/alter_foreign_table.sgml b/doc/src/sgml/ref/alter_foreign_table.sgml index 04d53628ec2..7ca03f3ac9f 100644 --- a/doc/src/sgml/ref/alter_foreign_table.sgml +++ b/doc/src/sgml/ref/alter_foreign_table.sgml @@ -71,7 +71,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"/>. + <link linkend="sql-createforeigntable"><command>CREATE FOREIGN TABLE</command></link>. 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. @@ -133,8 +133,8 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <para> This form sets the per-column statistics-gathering target for subsequent - <xref linkend="sql-analyze"/> operations. - See the similar form of <xref linkend="sql-altertable"/> + <link linkend="sql-analyze"><command>ANALYZE</command></link> operations. + See the similar form of <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for more details. </para> </listitem> @@ -146,7 +146,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <listitem> <para> This form sets or resets per-attribute options. - See the similar form of <xref linkend="sql-altertable"/> + See the similar form of <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for more details. </para> </listitem> @@ -159,7 +159,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <listitem> <para> This form sets the storage mode for a column. - See the similar form of <xref linkend="sql-altertable"/> + See the similar form of <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for more details. Note that the storage mode has no effect unless the table's foreign-data wrapper chooses to pay attention to it. @@ -172,7 +172,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 <link linkend="sql-createforeigntable"><command>CREATE FOREIGN TABLE</command></link>. Currently only <literal>CHECK</literal> constraints are supported. </para> @@ -181,7 +181,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 <link linkend="sql-createforeigntable"><command>CREATE FOREIGN TABLE</command></link>.) 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> @@ -216,7 +216,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <listitem> <para> These forms configure the firing of trigger(s) belonging to the foreign - table. See the similar form of <xref linkend="sql-altertable"/> for more + table. See the similar form of <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for more details. </para> </listitem> @@ -239,7 +239,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab <para> This form adds the target foreign table as a new child of the specified parent table. - See the similar form of <xref linkend="sql-altertable"/> + See the similar form of <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for more details. </para> </listitem> @@ -503,7 +503,7 @@ ALTER FOREIGN TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceab </para> <para> - Refer to <xref linkend="sql-createforeigntable"/> for a further description of valid + Refer to <link linkend="sql-createforeigntable"><command>CREATE FOREIGN TABLE</command></link> for a further description of valid parameters. </para> </refsect1> diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index f6e51631099..fa4a8df9124 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -51,14 +51,14 @@ 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"/>. + <link linkend="sql-grant"><command>GRANT</command></link> or + <link linkend="sql-revoke"><command>REVOKE</command></link>. </para> <para> The third variant changes the name of the group. This is exactly equivalent to renaming the role with - <xref linkend="sql-alterrole"/>. + <link linkend="sql-alterrole"><command>ALTER ROLE</command></link>. </para> </refsect1> diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index a5e3b06ee49..793119d2fc1 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -81,7 +81,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"/>. + <link linkend="sql-createtablespace"><command>CREATE TABLESPACE</command></link>. </para> </listitem> </varlistentry> @@ -118,11 +118,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"/> + <link linkend="sql-createindex"><command>CREATE INDEX</command></link> 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"/> + <link linkend="sql-reindex"><command>REINDEX</command></link> to get the desired effects. </para> </listitem> @@ -144,7 +144,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable> <listitem> <para> This form sets the per-column statistics-gathering target for - subsequent <xref linkend="sql-analyze"/> operations, though can + subsequent <link linkend="sql-analyze"><command>ANALYZE</command></link> operations, though can be used only on index columns that are defined as an expression. Since expressions lack a unique name, we refer to them using the ordinal number of the index column. @@ -252,7 +252,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable> <para> These operations are also possible using - <xref linkend="sql-altertable"/>. + <link linkend="sql-altertable"><command>ALTER TABLE</command></link>. <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_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml index 78ee99bb9ca..bf379db77e3 100644 --- a/doc/src/sgml/ref/alter_materialized_view.sgml +++ b/doc/src/sgml/ref/alter_materialized_view.sgml @@ -72,7 +72,8 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE <replaceable class="parameter">name</r The statement subforms and actions available for <command>ALTER MATERIALIZED VIEW</command> are a subset of those available for <command>ALTER TABLE</command>, and have the same meaning when used for - materialized views. See the descriptions for <xref linkend="sql-altertable"/> + materialized views. See the descriptions for + <link linkend="sql-altertable"><command>ALTER TABLE</command></link> for details. </para> </refsect1> diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index d5f166c129b..aef30521bcc 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -63,11 +63,11 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A <para> The first variant of this command listed in the synopsis can change many of the role attributes that can be specified in - <xref linkend="sql-createrole"/>. + <link linkend="sql-createrole"><command>CREATE ROLE</command></link>. (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.) + <link linkend="sql-grant"><command>GRANT</command></link> and + <link linkend="sql-revoke"><command>REVOKE</command></link> 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 @@ -103,8 +103,8 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A default, overriding whatever setting is present in <filename>postgresql.conf</filename> or has been received from the <command>postgres</command> command line. This only happens at login time; executing - <xref linkend="sql-set-role"/> or - <xref linkend="sql-set-session-authorization"/> does not cause new + <link linkend="sql-set-role"><command>SET ROLE</command></link> or + <link linkend="sql-set-session-authorization"><command>SET SESSION AUTHORIZATION</command></link> does not cause new configuration values to be set. Settings set for all databases are overridden by database-specific settings attached to a role. Settings for specific databases or specific roles override @@ -176,7 +176,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 + <link linkend="sql-createrole"><command>CREATE ROLE</command></link>. For more information, see the <command>CREATE ROLE</command> reference page. </para> </listitem> @@ -220,8 +220,8 @@ ALTER ROLE { <replaceable class="parameter">role_specification</replaceable> | A <para> Role-specific variable settings take effect only at login; - <xref linkend="sql-set-role"/> and - <xref linkend="sql-set-session-authorization"/> + <link linkend="sql-set-role"><command>SET ROLE</command></link> and + <link linkend="sql-set-session-authorization"><command>SET SESSION AUTHORIZATION</command></link> do not process role-specific variable settings. </para> @@ -239,14 +239,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 <link linkend="sql-createrole"><command>CREATE ROLE</command></link> + to add new roles, and <link linkend="sql-droprole"><command>DROP ROLE</command></link> 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 <link linkend="sql-grant"><command>GRANT</command></link> and + <link linkend="sql-revoke"><command>REVOKE</command></link> to do that. </para> diff --git a/doc/src/sgml/ref/alter_statistics.sgml b/doc/src/sgml/ref/alter_statistics.sgml index 5f60ca8eac2..ce6cdf2bb1e 100644 --- a/doc/src/sgml/ref/alter_statistics.sgml +++ b/doc/src/sgml/ref/alter_statistics.sgml @@ -99,7 +99,7 @@ ALTER STATISTICS <replaceable class="parameter">name</replaceable> SET STATISTIC <listitem> <para> The statistic-gathering target for this statistics object for subsequent - <xref linkend="sql-analyze"/> operations. + <link linkend="sql-analyze"><command>ANALYZE</command></link> operations. The target can be set in the range 0 to 10000; alternatively, set it to -1 to revert to using the maximum of the statistics target of the referenced columns, if set, or the system default statistics diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index f034e75ec09..c25ef5abd6a 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -152,7 +152,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <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> + <link linkend="sql-createtable"><command>CREATE TABLE</command></link>. If <literal>IF NOT EXISTS</literal> is specified and a column already exists with this name, no error is thrown. </para> @@ -268,7 +268,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> These forms change whether a column is an identity column or change the generation attribute of an existing identity column. - See <xref linkend="sql-createtable"/> for details. + See <link linkend="sql-createtable"><command>CREATE TABLE</command></link> for details. Like <literal>SET DEFAULT</literal>, these forms only affect the behavior of subsequent <command>INSERT</command> and <command>UPDATE</command> commands; they do not cause rows @@ -290,7 +290,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> These forms alter the sequence that underlies an existing identity column. <replaceable>sequence_option</replaceable> is an option - supported by <xref linkend="sql-altersequence"/> such + supported by <link linkend="sql-altersequence"><command>ALTER SEQUENCE</command></link> such as <literal>INCREMENT BY</literal>. </para> </listitem> @@ -302,7 +302,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> This form sets the per-column statistics-gathering target for subsequent - <xref linkend="sql-analyze"/> operations. + <link linkend="sql-analyze"><command>ANALYZE</command></link> operations. The target can be set in the range 0 to 10000; alternatively, set it to -1 to revert to using the system default statistics target (<xref linkend="guc-default-statistics-target"/>). @@ -326,7 +326,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM defined per-attribute options are <literal>n_distinct</literal> and <literal>n_distinct_inherited</literal>, which override the number-of-distinct-values estimates made by subsequent - <xref linkend="sql-analyze"/> + <link linkend="sql-analyze"><command>ANALYZE</command></link> operations. <literal>n_distinct</literal> affects the statistics for the table itself, while <literal>n_distinct_inherited</literal> affects the statistics gathered for the table plus its inheritance children. When set to a @@ -388,7 +388,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <listitem> <para> This form adds a new constraint to a table using the same constraint - syntax as <xref linkend="sql-createtable"/>, plus the option <literal>NOT + syntax as <link linkend="sql-createtable"><command>CREATE TABLE</command></link>, plus the option <literal>NOT VALID</literal>, which is currently only allowed for foreign key and CHECK constraints. </para> @@ -422,7 +422,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> Additional restrictions apply when unique or primary key constraints - are added to partitioned tables; see <xref linkend="sql-createtable"/>. + are added to partitioned tables; see <link linkend="sql-createtable"><command>CREATE TABLE</command></link>. Also, foreign key constraints on partitioned tables may not be declared <literal>NOT VALID</literal> at present. </para> @@ -598,7 +598,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM even if row level security is disabled. In this case, the policies will <emphasis>not</emphasis> be applied and the policies will be ignored. See also - <xref linkend="sql-createpolicy"/>. + <link linkend="sql-createpolicy"><command>CREATE POLICY</command></link>. </para> </listitem> </varlistentry> @@ -613,7 +613,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM disabled (the default) then row level security will not be applied when the user is the table owner. See also - <xref linkend="sql-createpolicy"/>. + <link linkend="sql-createpolicy"><command>CREATE POLICY</command></link>. </para> </listitem> </varlistentry> @@ -623,7 +623,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <listitem> <para> This form selects the default index for future - <xref linkend="sql-cluster"/> + <link linkend="sql-cluster"><command>CLUSTER</command></link> operations. It does not actually re-cluster the table. </para> <para> @@ -637,7 +637,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <listitem> <para> This form removes the most recently used - <xref linkend="sql-cluster"/> + <link linkend="sql-cluster"><command>CLUSTER</command></link> index specification from the table. This affects future cluster operations that don't specify an index. </para> @@ -685,7 +685,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <literal>information_schema</literal> relations are not considered part of the system catalogs and will be moved. See also - <xref linkend="sql-createtablespace"/>. + <link linkend="sql-createtablespace"><command>CREATE TABLESPACE</command></link>. </para> </listitem> </varlistentry> @@ -707,12 +707,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> This form changes one or more storage parameters for the table. See <xref linkend="sql-createtable-storage-parameters"/> in the - <xref linkend="sql-createtable"/> documentation + <link linkend="sql-createtable"><command>CREATE TABLE</command></link> documentation 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"><command>VACUUM + FULL</command></link>, <link linkend="sql-cluster"><command>CLUSTER</command></link> 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 @@ -878,7 +878,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> A partition using <literal>FOR VALUES</literal> uses same syntax for <replaceable class="parameter">partition_bound_spec</replaceable> as - <xref linkend="sql-createtable"/>. The partition bound specification + <link linkend="sql-createtable"><command>CREATE TABLE</command></link>. The partition bound specification must correspond to the partitioning strategy and partition key of the target table. The table to be attached must have all the same columns as the target table and no more; moreover, the column types must also diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index 6d4784c82f1..43a7da4f0bc 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -93,7 +93,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 + <link linkend="sql-altertable"><command>ALTER TABLE</command></link>, 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_type.sgml b/doc/src/sgml/ref/alter_type.sgml index a4f09c660be..64bf266373d 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -90,7 +90,7 @@ ALTER TYPE <replaceable class="parameter">name</replaceable> SET ( <replaceable <listitem> <para> This form adds a new attribute to a composite type, using the same syntax as - <xref linkend="sql-createtype"/>. + <link linkend="sql-createtype"><command>CREATE TYPE</command></link>. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 51527cefb4c..0ee89f54c5c 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -57,7 +57,7 @@ ALTER USER { <replaceable class="parameter">role_specification</replaceable> | A <para> <command>ALTER USER</command> is now an alias for - <xref linkend="sql-alterrole"/>. + <link linkend="sql-alterrole"><command>ALTER ROLE</command></link>. </para> </refsect1> diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 5ac3ba83219..7d816c87c60 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -174,7 +174,7 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea just after making major changes in the contents of a table. Accurate statistics will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. A common - strategy for read-mostly databases is to run <xref linkend="sql-vacuum"/> + strategy for read-mostly databases is to run <link linkend="sql-vacuum"><command>VACUUM</command></link> and <command>ANALYZE</command> once a day during a low-usage time of day. (This will not be sufficient if there is heavy update activity.) </para> @@ -205,7 +205,7 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea will change slightly each time <command>ANALYZE</command> is run, even if the actual table contents did not change. This might result in small changes in the planner's estimated costs shown by - <xref linkend="sql-explain"/>. + <link linkend="sql-explain"><command>EXPLAIN</command></link>. In rare situations, this non-determinism will cause the planner's choices of query plans to change after <command>ANALYZE</command> is run. To avoid this, raise the amount of statistics collected by @@ -216,8 +216,8 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea The extent of analysis can be controlled by adjusting the <xref linkend="guc-default-statistics-target"/> configuration variable, or on a column-by-column basis by setting the per-column statistics - target with <command>ALTER TABLE ... ALTER COLUMN ... SET - STATISTICS</command> (see <xref linkend="sql-altertable"/>). + target with <link linkend="sql-altertable"><command>ALTER TABLE ... ALTER COLUMN ... SET + STATISTICS</command></link>. The target value sets the maximum number of entries in the most-common-value list and the maximum number of bins in the histogram. The default target value @@ -246,8 +246,7 @@ ANALYZE [ VERBOSE ] [ <replaceable class="parameter">table_and_columns</replacea with the largest possible statistics target. If this inaccuracy leads to bad query plans, a more accurate value can be determined manually and then installed with - <command>ALTER TABLE ... ALTER COLUMN ... SET (n_distinct = ...)</command> - (see <xref linkend="sql-altertable"/>). + <link linkend="sql-altertable"><command>ALTER TABLE ... ALTER COLUMN ... SET (n_distinct = ...)</command></link>. </para> <para> diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index c23bbfb4e71..016b0214874 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -37,9 +37,9 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <para> <command>BEGIN</command> initiates a transaction block, that is, all statements after a <command>BEGIN</command> command will be - executed in a single transaction until an explicit <xref - linkend="sql-commit"/> or <xref - linkend="sql-rollback"/> is given. + executed in a single transaction until an explicit <link + linkend="sql-commit"><command>COMMIT</command></link> or <link + linkend="sql-rollback"><command>ROLLBACK</command></link> is given. By default (without <command>BEGIN</command>), <productname>PostgreSQL</productname> executes transactions in <quote>autocommit</quote> mode, that is, each @@ -60,7 +60,7 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <para> If the isolation level, read/write mode, or deferrable mode is specified, the new transaction has those characteristics, as if - <xref linkend="sql-set-transaction"/> + <link linkend="sql-set-transaction"><command>SET TRANSACTION</command></link> was executed. </para> </refsect1> @@ -90,13 +90,13 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <title>Notes</title> <para> - <xref linkend="sql-start-transaction"/> has the same functionality + <link linkend="sql-start-transaction"><command>START TRANSACTION</command></link> has the same functionality as <command>BEGIN</command>. </para> <para> - Use <xref linkend="sql-commit"/> or - <xref linkend="sql-rollback"/> + Use <link linkend="sql-commit"><command>COMMIT</command></link> or + <link linkend="sql-rollback"><command>ROLLBACK</command></link> to terminate a transaction block. </para> @@ -131,7 +131,7 @@ BEGIN; <para> <command>BEGIN</command> is a <productname>PostgreSQL</productname> language extension. It is equivalent to the SQL-standard command - <xref linkend="sql-start-transaction"/>, whose reference page + <link linkend="sql-start-transaction"><command>START TRANSACTION</command></link>, whose reference page contains additional compatibility information. </para> diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index e464df1965d..32d20edd6aa 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -84,7 +84,7 @@ CLOSE { <replaceable class="parameter">name</replaceable> | ALL } <productname>PostgreSQL</productname> does not have an explicit <command>OPEN</command> cursor statement; a cursor is considered open when it is declared. Use the - <xref linkend="sql-declare"/> + <link linkend="sql-declare"><command>DECLARE</command></link> statement to declare a cursor. </para> diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index 4da60d8d56a..b9450e7366a 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -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 <link linkend="sql-altertable"><command>ALTER TABLE</command></link> to set the index to be used for future cluster operations, or to clear any previous setting. </para> @@ -159,7 +159,7 @@ CLUSTER [VERBOSE] <para> Because the planner records statistics about the ordering of - tables, it is advisable to run <xref linkend="sql-analyze"/> + tables, it is advisable to run <link linkend="sql-analyze"><command>ANALYZE</command></link> on the newly clustered table. Otherwise, the planner might make poor choices of query plans. </para> diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 18189abc6c9..369342b74d5 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -112,9 +112,11 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable <term><replaceable class="parameter">query</replaceable></term> <listitem> <para> - A <xref linkend="sql-select"/>, <xref linkend="sql-values"/>, - <xref linkend="sql-insert"/>, <xref linkend="sql-update"/> or - <xref linkend="sql-delete"/> command whose results are to be + A <link linkend="sql-select"><command>SELECT</command></link>, + <link linkend="sql-values"><command>VALUES</command></link>, + <link linkend="sql-insert"><command>INSERT</command></link>, + <link linkend="sql-update"><command>UPDATE</command></link>, or + <link linkend="sql-delete"><command>DELETE</command></link> command whose results are to be copied. Note that parentheses are required around the query. </para> <para> diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index a315fff8bd3..222e0aa5c9d 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -629,7 +629,7 @@ SELECT col FROM tab ORDER BY col USING sortop LIMIT 1; <para> The meanings of <literal>PARALLEL SAFE</literal>, <literal>PARALLEL RESTRICTED</literal>, and <literal>PARALLEL UNSAFE</literal> are the same as - in <xref linkend="sql-createfunction"/>. An aggregate will not be + in <link linkend="sql-createfunction"><command>CREATE FUNCTION</command></link>. An aggregate will not be considered for parallelization if it is marked <literal>PARALLEL UNSAFE</literal> (which is the default!) or <literal>PARALLEL RESTRICTED</literal>. Note that the parallel-safety markings of the aggregate's support diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index 2b4d4d55732..bad75bc1dce 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -304,7 +304,7 @@ SELECT CAST ( 2 AS numeric ) + 4.0; <title>Notes</title> <para> - Use <xref linkend="sql-dropcast"/> to remove user-defined casts. + Use <link linkend="sql-dropcast"><command>DROP CAST</command></link> to remove user-defined casts. </para> <para> diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 420576c5e83..41cb4068ec2 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -226,7 +226,7 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable> </para> <para> - Use <xref linkend="sql-dropdatabase"/> to remove a database. + Use <link linkend="sql-dropdatabase"><command>DROP DATABASE</command></link> to remove a database. </para> <para> @@ -235,9 +235,9 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable> </para> <para> - Database-level configuration parameters (set via <xref - linkend="sql-alterdatabase"/>) and database-level permissions (set via - <xref linkend="sql-grant"/>) are not copied from the template database. + Database-level configuration parameters (set via <link + linkend="sql-alterdatabase"><command>ALTER DATABASE</command></link>) and database-level permissions (set via + <link linkend="sql-grant"><command>GRANT</command></link>) are not copied from the template database. </para> <para> diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 3ee0f2d635d..f9477efe58d 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -159,7 +159,7 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] tables from which the new foreign table automatically inherits all columns. Parent tables can be plain tables or foreign tables. See the similar form of - <xref linkend="sql-createtable"/> for more details. + <link linkend="sql-createtable"><command>CREATE TABLE</command></link> for more details. </para> </listitem> </varlistentry> @@ -171,7 +171,7 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] This form can be used to create the foreign table as partition of the given parent table with specified partition bound values. See the similar form of - <xref linkend="sql-createtable"/> for more details. + <link linkend="sql-createtable"><command>CREATE TABLE</command></link> for more details. Note that it is currently not allowed to create the foreign table as a partition of the parent table if there are <literal>UNIQUE</literal> indexes on the parent table. (See also diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 97285b75784..3c1eaea651c 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -557,7 +557,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 <link linkend="sql-load"><command>LOAD</command></link> 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 to diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 7fa79f4cbfb..847b8efcf4d 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -779,8 +779,8 @@ Indexes: </para> <para> - Setting a value for <literal>parallel_workers</literal> via <xref - linkend="sql-altertable"/> directly controls how many parallel + Setting a value for <literal>parallel_workers</literal> via <link + linkend="sql-altertable"><command>ALTER TABLE</command></link> directly controls how many parallel worker processes will be requested by a <command>CREATE INDEX</command> against the table. This bypasses the cost model completely, and prevents <varname>maintenance_work_mem</varname> @@ -808,7 +808,7 @@ Indexes: </para> <para> - Use <xref linkend="sql-dropindex"/> + Use <link linkend="sql-dropindex"><command>DROP INDEX</command></link> to remove an index. </para> diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 10d1533d6d8..102efe5a6c7 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -137,7 +137,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE <replaceable class="pa <para><replaceable class="parameter">inline_handler</replaceable> is the name of a previously registered function that will be called to execute an anonymous code block - (<xref linkend="sql-do"/> command) + (<link linkend="sql-do"><command>DO</command></link> command) in this language. If no <replaceable class="parameter">inline_handler</replaceable> function is specified, the language does not support anonymous code @@ -183,7 +183,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE <replaceable class="pa <title>Notes</title> <para> - Use <xref linkend="sql-droplanguage"/> to drop procedural languages. + Use <link linkend="sql-droplanguage"><command>DROP LANGUAGE</command></link> to drop procedural languages. </para> <para> diff --git a/doc/src/sgml/ref/create_materialized_view.sgml b/doc/src/sgml/ref/create_materialized_view.sgml index de9f17655c6..5ba851b687a 100644 --- a/doc/src/sgml/ref/create_materialized_view.sgml +++ b/doc/src/sgml/ref/create_materialized_view.sgml @@ -132,8 +132,8 @@ CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] <replaceable>table_name</replaceable> <term><replaceable>query</replaceable></term> <listitem> <para> - A <xref linkend="sql-select"/>, <link linkend="sql-table">TABLE</link>, - or <xref linkend="sql-values"/> command. This query will run within a + A <link linkend="sql-select"><command>SELECT</command></link>, <link linkend="sql-table"><command>TABLE</command></link>, + or <link linkend="sql-values"><command>VALUES</command></link> command. This query will run within a security-restricted operation; in particular, calls to functions that themselves create temporary tables will fail. </para> diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index 9462bc1e8ca..e27512ff391 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -251,8 +251,8 @@ COMMUTATOR = OPERATOR(myschema.===) , </para> <para> - Use <xref linkend="sql-dropoperator"/> to delete user-defined operators - from a database. Use <xref linkend="sql-alteroperator"/> to modify operators in a + Use <link linkend="sql-dropoperator"><command>DROP OPERATOR</command></link> to delete user-defined operators + from a database. Use <link linkend="sql-alteroperator"><command>ALTER OPERATOR</command></link> to modify operators in a database. </para> </refsect1> diff --git a/doc/src/sgml/ref/create_procedure.sgml b/doc/src/sgml/ref/create_procedure.sgml index d225695626c..36c307cadc7 100644 --- a/doc/src/sgml/ref/create_procedure.sgml +++ b/doc/src/sgml/ref/create_procedure.sgml @@ -285,7 +285,7 @@ CREATE [ OR REPLACE ] PROCEDURE the SQL procedure. The string <replaceable class="parameter">obj_file</replaceable> is the name of the shared library file containing the compiled C procedure, and is interpreted - as for the <xref linkend="sql-load"/> command. The string + as for the <link linkend="sql-load"><command>LOAD</command></link> command. The string <replaceable class="parameter">link_symbol</replaceable> is the procedure's link symbol, that is, the name of the procedure in the C language source code. If the link symbol is omitted, it is assumed diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 6e4148a17c4..d23133945db 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -162,7 +162,7 @@ in sync when changing the above synopsis! If not specified, <literal>NOLOGIN</literal> is the default, except when <command>CREATE ROLE</command> is invoked through its alternative spelling - <xref linkend="sql-createuser"/>. + <link linkend="sql-createuser"><command>CREATE USER</command></link>. </para> </listitem> </varlistentry> @@ -335,8 +335,8 @@ in sync when changing the above synopsis! <title>Notes</title> <para> - Use <xref linkend="sql-alterrole"/> to - change the attributes of a role, and <xref linkend="sql-droprole"/> + Use <link linkend="sql-alterrole"><command>ALTER ROLE</command></link> to + change the attributes of a role, and <link linkend="sql-droprole"><command>DROP ROLE</command></link> to remove a role. All the attributes specified by <command>CREATE ROLE</command> can be modified by later <command>ALTER ROLE</command> commands. @@ -345,8 +345,8 @@ in sync when changing the above synopsis! <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"/>. + <link linkend="sql-grant"><command>GRANT</command></link> and + <link linkend="sql-revoke"><command>REVOKE</command></link>. </para> <para> @@ -364,7 +364,7 @@ in sync when changing the above synopsis! 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 + <link linkend="sql-set-role"><command>SET ROLE</command></link> before creating a database. </para> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 087cad184c0..28f844071b0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1152,7 +1152,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM constraint that is not deferrable will be checked immediately after every command. Checking of constraints that are deferrable can be postponed until the end of the transaction - (using the <xref linkend="sql-set-constraints"/> command). + (using the <link linkend="sql-set-constraints"><command>SET CONSTRAINTS</command></link> command). <literal>NOT DEFERRABLE</literal> is the default. Currently, only <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, <literal>EXCLUDE</literal>, and @@ -1176,7 +1176,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM statement. This is the default. If the constraint is <literal>INITIALLY DEFERRED</literal>, it is checked only at the end of the transaction. The constraint check time can be - altered with the <xref linkend="sql-set-constraints"/> command. + altered with the <link linkend="sql-set-constraints"><command>SET CONSTRAINTS</command></link> command. </para> </listitem> </varlistentry> @@ -1244,8 +1244,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <listitem> <para> All rows in the temporary table will be deleted at the end - of each transaction block. Essentially, an automatic <xref - linkend="sql-truncate"/> is done + of each transaction block. Essentially, an automatic <link + linkend="sql-truncate"><command>TRUNCATE</command></link> is done at each commit. When used on a partitioned table, this is not cascaded to its partitions. </para> @@ -1430,7 +1430,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM Disabling index cleanup can speed up <command>VACUUM</command> very significantly, but may also lead to severely bloated indexes if table modifications are frequent. The <literal>INDEX_CLEANUP</literal> - parameter of <xref linkend="sql-vacuum"/>, if specified, overrides + parameter of <link linkend="sql-vacuum"><command>VACUUM</command></link>, if specified, overrides the value of this option. </para> </listitem> @@ -1451,7 +1451,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM the truncated pages is returned to the operating system. Note that the truncation requires <literal>ACCESS EXCLUSIVE</literal> lock on the table. The <literal>TRUNCATE</literal> parameter - of <xref linkend="sql-vacuum"/>, if specified, overrides the value + of <link linkend="sql-vacuum"><command>VACUUM</command></link>, if specified, overrides the value of this option. </para> </listitem> diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index a4640929cfb..bcbd73b2272 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -185,8 +185,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI <listitem> <para> All rows in the temporary table will be deleted at the end - of each transaction block. Essentially, an automatic <xref - linkend="sql-truncate"/> is done + of each transaction block. Essentially, an automatic <link + linkend="sql-truncate"><command>TRUNCATE</command></link> is done at each commit. </para> </listitem> @@ -222,9 +222,9 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI <term><replaceable>query</replaceable></term> <listitem> <para> - A <xref linkend="sql-select"/>, <link - linkend="sql-table">TABLE</link>, or <xref linkend="sql-values"/> - command, or an <xref linkend="sql-execute"/> command that runs a + A <link linkend="sql-select"><command>SELECT</command></link>, <link + linkend="sql-table"><command>TABLE</command></link>, or <link linkend="sql-values"><command>VALUES</command></link> + command, or an <link linkend="sql-execute"><command>EXECUTE</command></link> command that runs a prepared <command>SELECT</command>, <command>TABLE</command>, or <command>VALUES</command> query. </para> diff --git a/doc/src/sgml/ref/create_transform.sgml b/doc/src/sgml/ref/create_transform.sgml index 5b46c23196d..3f81dc6bba2 100644 --- a/doc/src/sgml/ref/create_transform.sgml +++ b/doc/src/sgml/ref/create_transform.sgml @@ -147,7 +147,7 @@ CREATE [ OR REPLACE ] TRANSFORM FOR <replaceable>type_name</replaceable> LANGUAG <title>Notes</title> <para> - Use <xref linkend="sql-droptransform"/> to remove transforms. + Use <link linkend="sql-droptransform"><command>DROP TRANSFORM</command></link> to remove transforms. </para> </refsect1> diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 289dd1d9da8..60346e1e83b 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -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"/>. + <link linkend="sql-set-constraints"><command>SET CONSTRAINTS</command></link>. 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 @@ -442,7 +442,7 @@ UPDATE OF <replaceable>column_name1</replaceable> [, <replaceable>column_name2</ </para> <para> - Use <xref linkend="sql-droptrigger"/> to remove a trigger. + Use <link linkend="sql-droptrigger"><command>DROP TRIGGER</command></link> to remove a trigger. </para> <para> diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index 111f8e65d29..970b517db9f 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -121,8 +121,8 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> must be less than <symbol>NAMEDATALEN</symbol> bytes long (64 bytes in a standard <productname>PostgreSQL</productname> build). (It is possible to create an enumerated type with zero labels, but such a type cannot be used - to hold values before at least one label is added using <xref - linkend="sql-altertype"/>.) + to hold values before at least one label is added using <link + linkend="sql-altertype"><command>ALTER TYPE</command></link>.) </para> </refsect2> diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index 198e06e7230..48d2089238c 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -49,7 +49,7 @@ CREATE USER <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac <para> <command>CREATE USER</command> is now an alias for - <xref linkend="sql-createrole"/>. + <link linkend="sql-createrole"><command>CREATE ROLE</command></link>. The only difference is that when the command is spelled <command>CREATE USER</command>, <literal>LOGIN</literal> is assumed by default, whereas <literal>NOLOGIN</literal> is assumed when diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index eb5591b63c7..4b5b1cf7953 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -137,8 +137,8 @@ CREATE VIEW [ <replaceable>schema</replaceable> . ] <replaceable>view_name</repl This parameter may be either <literal>local</literal> or <literal>cascaded</literal>, and is equivalent to specifying <literal>WITH [ CASCADED | LOCAL ] CHECK OPTION</literal> (see below). - This option can be changed on existing views using <xref - linkend="sql-alterview"/>. + This option can be changed on existing views using <link + linkend="sql-alterview"><command>ALTER VIEW</command></link>. </para> </listitem> </varlistentry> @@ -160,8 +160,8 @@ CREATE VIEW [ <replaceable>schema</replaceable> . ] <replaceable>view_name</repl <term><replaceable class="parameter">query</replaceable></term> <listitem> <para> - A <xref linkend="sql-select"/> or - <xref linkend="sql-values"/> command + A <link linkend="sql-select"><command>SELECT</command></link> or + <link linkend="sql-values"><command>VALUES</command></link> command which will provide the columns and rows of the view. </para> </listitem> @@ -245,7 +245,7 @@ CREATE VIEW [ <replaceable>schema</replaceable> . ] <replaceable>view_name</repl <title>Notes</title> <para> - Use the <xref linkend="sql-dropview"/> + Use the <link linkend="sql-dropview"><command>DROP VIEW</command></link> statement to drop views. </para> diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index d3c92943f07..95cc82dc88b 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -46,7 +46,7 @@ PostgreSQL documentation <para> <application>createdb</application> is a wrapper around the - <acronym>SQL</acronym> command <xref linkend="sql-createdatabase"/>. + <acronym>SQL</acronym> command <link linkend="sql-createdatabase"><command>CREATE DATABASE</command></link>. There is no effective difference between creating databases via this utility and via other methods for accessing the server. </para> @@ -197,7 +197,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 <link linkend="sql-createdatabase"><command>CREATE DATABASE</command></link>; see there for more information about them. </para> diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml index 9d24df8b7a8..4d60dc2cda1 100644 --- a/doc/src/sgml/ref/createuser.sgml +++ b/doc/src/sgml/ref/createuser.sgml @@ -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 <link linkend="sql-createrole"><command>CREATE ROLE</command></link>. There is no effective difference between creating users via this utility and via other methods for accessing the server. </para> diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index d6177dcd9c4..2152134635e 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -39,7 +39,7 @@ DECLARE <replaceable class="parameter">name</replaceable> [ BINARY ] [ INSENSITI can be used to retrieve a small number of rows at a time out of a larger query. After the cursor is created, rows are fetched from it using - <xref linkend="sql-fetch"/>. + <link linkend="sql-fetch"><command>FETCH</command></link>. </para> <note> @@ -124,8 +124,8 @@ DECLARE <replaceable class="parameter">name</replaceable> [ BINARY ] [ INSENSITI <term><replaceable class="parameter">query</replaceable></term> <listitem> <para> - A <xref linkend="sql-select"/> or - <xref linkend="sql-values"/> command + A <link linkend="sql-select"><command>SELECT</command></link> or + <link linkend="sql-values"><command>VALUES</command></link> command which will provide the rows to be returned by the cursor. </para> </listitem> @@ -183,9 +183,9 @@ DECLARE <replaceable class="parameter">name</replaceable> [ BINARY ] [ INSENSITI <productname>PostgreSQL</productname> reports an error if such a command is used outside a transaction block. Use - <xref linkend="sql-begin"/> and - <xref linkend="sql-commit"/> - (or <xref linkend="sql-rollback"/>) + <link linkend="sql-begin"><command>BEGIN</command></link> and + <link linkend="sql-commit"><command>COMMIT</command></link> + (or <link linkend="sql-rollback"><command>ROLLBACK</command></link>) to define a transaction block. </para> @@ -244,7 +244,7 @@ DECLARE <replaceable class="parameter">name</replaceable> [ BINARY ] [ INSENSITI If the cursor's query includes <literal>FOR UPDATE</literal> or <literal>FOR SHARE</literal>, then returned rows are locked at the time they are first fetched, in the same way as for a regular - <xref linkend="sql-select"/> command with + <link linkend="sql-select"><command>SELECT</command></link> command with these options. In addition, the returned rows will be the most up-to-date versions; therefore these options provide the equivalent of what the SQL standard diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index ec3c40df2ea..1b81b4e7d74 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -41,7 +41,7 @@ DELETE FROM [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * <tip> <para> - <xref linkend="sql-truncate"/> provides a + <link linkend="sql-truncate"><command>TRUNCATE</command></link> provides a faster mechanism to remove all rows from a table. </para> </tip> diff --git a/doc/src/sgml/ref/drop_group.sgml b/doc/src/sgml/ref/drop_group.sgml index 47d4a72121b..eb7dc182c82 100644 --- a/doc/src/sgml/ref/drop_group.sgml +++ b/doc/src/sgml/ref/drop_group.sgml @@ -30,7 +30,7 @@ DROP GROUP [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, .. <para> <command>DROP GROUP</command> is now an alias for - <xref linkend="sql-droprole"/>. + <link linkend="sql-droprole"><command>DROP ROLE</command></link>. </para> </refsect1> diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 4705836ac79..8ba6621bc4a 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -38,7 +38,7 @@ DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="parameter">name</ <para> As of <productname>PostgreSQL</productname> 9.1, most procedural languages have been made into <quote>extensions</quote>, and should - therefore be removed with <xref linkend="sql-dropextension"/> + therefore be removed with <link linkend="sql-dropextension"><command>DROP EXTENSION</command></link> not <command>DROP LANGUAGE</command>. </para> </note> diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index dcc375f33bf..8fa8c414a10 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -90,7 +90,7 @@ DROP OWNED BY { <replaceable class="parameter">name</replaceable> | CURRENT_ROLE </para> <para> - The <xref linkend="sql-reassign-owned"/> command is an alternative that + The <link linkend="sql-reassign-owned"><command>REASSIGN OWNED</command></link> command is an alternative that reassigns the ownership of all the database objects owned by one or more roles. However, <command>REASSIGN OWNED</command> does not deal with privileges for other objects. diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index 13079f3e1f4..13dc1cc6499 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -40,7 +40,9 @@ DROP ROLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ... of the cluster; an error will be raised if so. Before dropping the role, you must drop all the objects it owns (or reassign their ownership) and revoke any privileges the role has been granted on other objects. - The <xref linkend="sql-reassign-owned"/> and <xref linkend="sql-drop-owned"/> + The <link linkend="sql-reassign-owned"><command>REASSIGN + OWNED</command></link> and <link linkend="sql-drop-owned"><command>DROP + OWNED</command></link> commands can be useful for this purpose; see <xref linkend="role-removal"/> for more discussion. </para> diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index bf8996d1985..450458fd2a4 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -32,8 +32,8 @@ DROP TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, .. <command>DROP TABLE</command> removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table. To empty a table of rows - without destroying the table, use <xref linkend="sql-delete"/> - or <xref linkend="sql-truncate"/>. + without destroying the table, use <link linkend="sql-delete"><command>DELETE</command></link> + or <link linkend="sql-truncate"><command>TRUNCATE</command></link>. </para> <para> diff --git a/doc/src/sgml/ref/drop_user.sgml b/doc/src/sgml/ref/drop_user.sgml index 37ab856125d..74e736b0ebd 100644 --- a/doc/src/sgml/ref/drop_user.sgml +++ b/doc/src/sgml/ref/drop_user.sgml @@ -30,7 +30,7 @@ DROP USER [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [, ... <para> <command>DROP USER</command> is simply an alternate spelling of - <xref linkend="sql-droprole"/>. + <link linkend="sql-droprole"><command>DROP ROLE</command></link>. </para> </refsect1> diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index ded85b0e232..fe523a2ee1d 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -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 <link linkend="sql-dropdatabase"><command>DROP DATABASE</command></link>. There is no effective difference between dropping databases via this utility and via other methods for accessing the server. </para> diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index f9aab340d3b..81580507e82 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -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 <link linkend="sql-droprole"><command>DROP ROLE</command></link>. There is no effective difference between dropping users via this utility and via other methods for accessing the server. </para> diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index 8b8f4f0dbb9..498652919ad 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -33,7 +33,7 @@ END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a <productname>PostgreSQL</productname> extension - that is equivalent to <xref linkend="sql-commit"/>. + that is equivalent to <link linkend="sql-commit"><command>COMMIT</command></link>. </para> </refsect1> @@ -69,7 +69,7 @@ END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] <title>Notes</title> <para> - Use <xref linkend="sql-rollback"/> to + Use <link linkend="sql-rollback"><command>ROLLBACK</command></link> to abort a transaction. </para> @@ -94,8 +94,8 @@ END; <para> <command>END</command> is a <productname>PostgreSQL</productname> - extension that provides functionality equivalent to <xref - linkend="sql-commit"/>, which is + extension that provides functionality equivalent to <link + linkend="sql-commit"><command>COMMIT</command></link>, which is specified in the SQL standard. </para> </refsect1> diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index 906b2ccd50a..b0ccdd26e73 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -302,7 +302,7 @@ ROLLBACK; the <link linkend="autovacuum">autovacuum daemon</link> will take care of that automatically. But if a table has recently had substantial changes in its contents, you might need to do a manual - <xref linkend="sql-analyze"/> rather than wait for autovacuum to catch up + <link linkend="sql-analyze"><command>ANALYZE</command></link> rather than wait for autovacuum to catch up with the changes. </para> diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index e802be61c8c..ec843f56844 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -335,9 +335,9 @@ FETCH <replaceable class="parameter">count</replaceable> </para> <para> - <xref linkend="sql-declare"/> + <link linkend="sql-declare"><command>DECLARE</command></link> is used to define a cursor. Use - <xref linkend="sql-move"/> + <link linkend="sql-move"><command>MOVE</command></link> to change cursor position without retrieving data. </para> </refsect1> diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index fe231aa30cd..c3db393bdea 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -259,7 +259,7 @@ GRANT <replaceable class="parameter">role_name</replaceable> [, ...] TO <replace <title>Notes</title> <para> - The <xref linkend="sql-revoke"/> command is used + The <link linkend="sql-revoke"><command>REVOKE</command></link> command is used to revoke access privileges. </para> diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 0c4688603d9..4cdfae2279e 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -186,9 +186,9 @@ LOCK [ TABLE ] [ ONLY ] <replaceable class="parameter">name</replaceable> [ * ] <productname>PostgreSQL</productname> reports an error if <command>LOCK</command> is used outside a transaction block. Use - <xref linkend="sql-begin"/> and - <xref linkend="sql-commit"/> - (or <xref linkend="sql-rollback"/>) + <link linkend="sql-begin"><command>BEGIN</command></link> and + <link linkend="sql-commit"><command>COMMIT</command></link> + (or <link linkend="sql-rollback"><command>ROLLBACK</command></link>) to define a transaction block. </para> diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index 806949df42b..fda678e345c 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -143,8 +143,8 @@ PostgreSQL documentation <para> This option is meant for other programs that interact with a server instance, such as <xref linkend="app-pg-ctl"/>, to query configuration - parameter values. User-facing applications should instead use <xref - linkend="sql-show"/> or the <structname>pg_settings</structname> view. + parameter values. User-facing applications should instead use <link + linkend="sql-show"><command>SHOW</command></link> or the <structname>pg_settings</structname> view. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index 1e484f6d202..57a34ff83c7 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -66,7 +66,7 @@ PREPARE <replaceable class="parameter">name</replaceable> [ ( <replaceable class also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use. Prepared statements can be - manually cleaned up using the <xref linkend="sql-deallocate"/> command. + manually cleaned up using the <link linkend="sql-deallocate"><command>DEALLOCATE</command></link> command. </para> <para> @@ -163,7 +163,7 @@ PREPARE <replaceable class="parameter">name</replaceable> [ ( <replaceable class <para> To examine the query plan <productname>PostgreSQL</productname> is using - for a prepared statement, use <xref linkend="sql-explain"/>, for example + for a prepared statement, use <link linkend="sql-explain"><command>EXPLAIN</command></link>, for example <programlisting> EXPLAIN EXECUTE <replaceable>name</replaceable>(<replaceable>parameter_values</replaceable>); </programlisting> diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index 18051983e16..f4f6118ac31 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -39,8 +39,8 @@ PREPARE TRANSACTION <replaceable class="parameter">transaction_id</replaceable> <para> Once prepared, a transaction can later be committed or rolled back - with <xref linkend="sql-commit-prepared"/> - or <xref linkend="sql-rollback-prepared"/>, + with <link linkend="sql-commit-prepared"><command>COMMIT PREPARED</command></link> + or <link linkend="sql-rollback-prepared"><command>ROLLBACK PREPARED</command></link>, respectively. Those commands can be issued from any session, not only the one that executed the original transaction. </para> @@ -92,8 +92,8 @@ PREPARE TRANSACTION <replaceable class="parameter">transaction_id</replaceable> </para> <para> - This command must be used inside a transaction block. Use <xref - linkend="sql-begin"/> to start one. + This command must be used inside a transaction block. Use <link + linkend="sql-begin"><command>BEGIN</command></link> to start one. </para> <para> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index aed051f543c..ee3fc095779 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -756,8 +756,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"/>. + <link linkend="sql-listen"><command>LISTEN</command></link> and + <link linkend="sql-notify"><command>NOTIFY</command></link>. </para> <para> @@ -993,7 +993,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> <link linkend="sql-copy"><command>COPY</command></link> command, but instead of the server reading or writing the specified file, <application>psql</application> reads or writes the file and @@ -1030,9 +1030,9 @@ testdb=> <para> The syntax of this command is similar to that of the - <acronym>SQL</acronym> <xref linkend="sql-copy"/> + <acronym>SQL</acronym> <link linkend="sql-copy"><command>COPY</command></link> command. All options other than the data source/destination are - as specified for <xref linkend="sql-copy"/>. + as specified for <command>COPY</command>. Because of this, special parsing rules apply to the <command>\copy</command> meta-command. Unlike most other meta-commands, the entire remainder of the line is always taken to be the arguments of <command>\copy</command>, @@ -1397,8 +1397,8 @@ testdb=> </para> <para> - Descriptions for objects can be created with the <xref - linkend="sql-comment"/> + Descriptions for objects can be created with the <link + linkend="sql-comment"><command>COMMENT</command></link> <acronym>SQL</acronym> command. </para> </listitem> @@ -1435,9 +1435,9 @@ testdb=> </para> <para> - The <xref linkend="sql-alterdefaultprivileges"/> command is used to set - default access privileges. The meaning of the - privilege display is explained in + The <link linkend="sql-alterdefaultprivileges"><command>ALTER DEFAULT + PRIVILEGES</command></link> command is used to set default access + privileges. The meaning of the privilege display is explained in <xref linkend="ddl-priv"/>. </para> </listitem> @@ -1751,8 +1751,8 @@ testdb=> </para> <para> - The <xref linkend="sql-grant"/> and - <xref linkend="sql-revoke"/> + The <link linkend="sql-grant"><command>GRANT</command></link> and + <link linkend="sql-revoke"><command>REVOKE</command></link> commands are used to set access privileges. The meaning of the privilege display is explained in <xref linkend="ddl-priv"/>. @@ -1807,8 +1807,8 @@ testdb=> </para> <para> - The <xref linkend="sql-alterrole"/> and - <xref linkend="sql-alterdatabase"/> + The <link linkend="sql-alterrole"><command>ALTER ROLE</command></link> and + <link linkend="sql-alterdatabase"><command>ALTER DATABASE</command></link> commands are used to define per-role and per-database configuration settings. </para> @@ -3179,7 +3179,7 @@ lo_import 152801 <note> <para> This command is unrelated to the <acronym>SQL</acronym> - command <xref linkend="sql-set"/>. + command <link linkend="sql-set"><command>SET</command></link>. </para> </note> </listitem> diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index 783389df4e8..ab692bd0690 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -82,7 +82,7 @@ REASSIGN OWNED BY { <replaceable class="parameter">old_role</replaceable> | CURR </para> <para> - The <xref linkend="sql-drop-owned"/> command is an alternative that + The <link linkend="sql-drop-owned"><command>DROP OWNED</command></link> command is an alternative that simply drops all the database objects owned by one or more roles. </para> diff --git a/doc/src/sgml/ref/refresh_materialized_view.sgml b/doc/src/sgml/ref/refresh_materialized_view.sgml index 8ae62671ada..3bf88844478 100644 --- a/doc/src/sgml/ref/refresh_materialized_view.sgml +++ b/doc/src/sgml/ref/refresh_materialized_view.sgml @@ -94,7 +94,7 @@ REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] <replaceable class="parameter">name</ <para> While the default index for future - <xref linkend="sql-cluster"/> + <link linkend="sql-cluster"><command>CLUSTER</command></link> 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/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 0f3f12bfbfc..a6d93693c5d 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -93,7 +93,7 @@ PostgreSQL documentation <para> <application>reindexdb</application> is a wrapper around the SQL - command <xref linkend="sql-reindex"/>. + command <link linkend="sql-reindex"><command>REINDEX</command></link>. There is no effective difference between reindexing databases via this utility and via other methods for accessing the server. </para> diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index b50f99dfe71..35ff87a4f5e 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -131,7 +131,7 @@ REVOKE [ ADMIN OPTION FOR ] </para> <para> - See the description of the <xref linkend="sql-grant"/> command for + See the description of the <link linkend="sql-grant"><command>GRANT</command></link> command for the meaning of the privilege types. </para> @@ -292,7 +292,7 @@ REVOKE admins FROM joe; <title>Compatibility</title> <para> - The compatibility notes of the <xref linkend="sql-grant"/> command + The compatibility notes of the <link linkend="sql-grant"><command>GRANT</command></link> command apply analogously to <command>REVOKE</command>. The keyword <literal>RESTRICT</literal> or <literal>CASCADE</literal> is required according to the standard, but <productname>PostgreSQL</productname> diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index 1357eaa8323..142f71e7742 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -70,7 +70,7 @@ ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] <title>Notes</title> <para> - Use <xref linkend="sql-commit"/> to + Use <link linkend="sql-commit"><command>COMMIT</command></link> to successfully terminate a transaction. </para> diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml index 4d5647a302e..3d5a241e1aa 100644 --- a/doc/src/sgml/ref/rollback_to.sgml +++ b/doc/src/sgml/ref/rollback_to.sgml @@ -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 <link linkend="sql-release-savepoint"><command>RELEASE SAVEPOINT</command></link> 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 87243b1d204..b17342a1ee6 100644 --- a/doc/src/sgml/ref/savepoint.sgml +++ b/doc/src/sgml/ref/savepoint.sgml @@ -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 <link linkend="sql-rollback-to"><command>ROLLBACK TO</command></link> to + rollback to a savepoint. Use <link linkend="sql-release-savepoint"><command>RELEASE SAVEPOINT</command></link> to destroy a savepoint, keeping the effects of commands executed after it was established. </para> diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index b93e4ca208b..b4dea9b6acf 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -446,7 +446,7 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] sub-<command>SELECT</command> must be surrounded by parentheses, and an alias <emphasis>must</emphasis> be provided for it. A - <xref linkend="sql-values"/> command + <link linkend="sql-values"><command>VALUES</command></link> command can also be used here. </para> </listitem> @@ -1534,7 +1534,7 @@ KEY SHARE to the row-level lock(s) — the required <literal>ROW SHARE</literal> table-level lock is still taken in the ordinary way (see <xref linkend="mvcc"/>). You can use - <xref linkend="sql-lock"/> + <link linkend="sql-lock"><command>LOCK</command></link> with the <literal>NOWAIT</literal> option first, if you need to acquire the table-level lock without waiting. </para> diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index b1af52a4da1..6cfa706b575 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -95,7 +95,7 @@ SELECT [ ALL | DISTINCT [ ON ( <replaceable class="parameter">expression</replac <title>Notes</title> <para> - <xref linkend="sql-createtableas"/> is functionally similar to + <link linkend="sql-createtableas"><command>CREATE TABLE AS</command></link> is functionally similar to <command>SELECT INTO</command>. <command>CREATE TABLE AS</command> is the recommended syntax, since this form of <command>SELECT INTO</command> is not available in <application>ECPG</application> @@ -109,8 +109,8 @@ SELECT [ ALL | DISTINCT [ ON ( <replaceable class="parameter">expression</replac In contrast to <command>CREATE TABLE AS</command>, <command>SELECT INTO</command> does not allow to specify properties like a table's access method with <xref linkend="sql-createtable-method" /> or the table's - tablespace with <xref linkend="sql-createtable-tablespace" />. Use <xref - linkend="sql-createtableas"/> if necessary. Therefore, the default table + tablespace with <xref linkend="sql-createtable-tablespace" />. Use + <command>CREATE TABLE AS</command> if necessary. Therefore, the default table access method is chosen for the new table. See <xref linkend="guc-default-table-access-method"/> for more information. </para> diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index a4842f363c8..739f2c5cdfa 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -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 <link linkend="sql-set"><command>SET</command></link> command. </para> @@ -82,7 +82,7 @@ RESET ROLE <para> <command>SET ROLE</command> has effects comparable to - <xref linkend="sql-set-session-authorization"/>, but the privilege + <link linkend="sql-set-session-authorization"><command>SET SESSION AUTHORIZATION</command></link>, but the privilege checks involved are quite different. Also, <command>SET SESSION AUTHORIZATION</command> determines which roles are allowable for later <command>SET ROLE</command> commands, whereas changing @@ -92,7 +92,7 @@ RESET ROLE <para> <command>SET ROLE</command> does not process session variables as specified by - the role's <xref linkend="sql-alterrole"/> settings; this only happens during + the role's <link linkend="sql-alterrole"><command>ALTER ROLE</command></link> settings; this only happens during login. </para> diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index 6a838e58b76..e44e78ed8d6 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -45,7 +45,7 @@ RESET SESSION AUTHORIZATION identifier is normally equal to the session user identifier, but might change temporarily in the context of <literal>SECURITY DEFINER</literal> functions and similar mechanisms; it can also be changed by - <xref linkend="sql-set-role"/>. + <link linkend="sql-set-role"><command>SET ROLE</command></link>. The current user identifier is relevant for permission checking. </para> @@ -58,7 +58,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 <link linkend="sql-set"><command>SET</command></link> command. </para> diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index d6cd1d41779..74ccd7e3456 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -37,8 +37,8 @@ START TRANSACTION [ <replaceable class="parameter">transaction_mode</replaceable <para> This command begins a new transaction block. If the isolation level, read/write mode, or deferrable mode is specified, the new transaction has those - characteristics, as if <xref linkend="sql-set-transaction"/> was executed. This is the same - as the <xref linkend="sql-begin"/> command. + characteristics, as if <link linkend="sql-set-transaction"><command>SET TRANSACTION</command></link> was executed. This is the same + as the <link linkend="sql-begin"><command>BEGIN</command></link> command. </para> </refsect1> diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 766c6882bd4..6dcdab9cafd 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -62,7 +62,7 @@ PostgreSQL documentation <para> <application>vacuumdb</application> is a wrapper around the SQL - command <xref linkend="sql-vacuum"/>. + command <link linkend="sql-vacuum"><command>VACUUM</command></link>. There is no effective difference between vacuuming and analyzing databases via this utility and via other methods for accessing the server. |