From 6dcce3985bd4239b02e48c0e530ab1c612864dfc Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 3 Apr 2010 07:23:02 +0000 Subject: Remove unnecessary xref endterm attributes and title ids The endterm attribute is mainly useful when the toolchain does not support automatic link target text generation for a particular situation. In the past, this was required by the man page tools for all reference page links, but that is no longer the case, and it now actually gets in the way of proper automatic link text generation. The only remaining use cases are currently xrefs to refsects. --- doc/src/sgml/advanced.sgml | 6 +- doc/src/sgml/arch-dev.sgml | 6 +- doc/src/sgml/auto-explain.sgml | 4 +- doc/src/sgml/backup.sgml | 14 ++-- doc/src/sgml/catalogs.sgml | 86 +++++++++++------------ doc/src/sgml/client-auth.sgml | 6 +- doc/src/sgml/config.sgml | 49 ++++++------- doc/src/sgml/datatype.sgml | 8 +-- doc/src/sgml/dblink.sgml | 8 +-- doc/src/sgml/ddl.sgml | 29 ++++---- doc/src/sgml/dfunc.sgml | 4 +- doc/src/sgml/dml.sgml | 18 ++--- doc/src/sgml/extend.sgml | 6 +- doc/src/sgml/func.sgml | 16 ++--- doc/src/sgml/geqo.sgml | 4 +- doc/src/sgml/gin.sgml | 6 +- doc/src/sgml/high-availability.sgml | 14 ++-- doc/src/sgml/indices.sgml | 14 ++-- doc/src/sgml/libpq.sgml | 21 +++--- doc/src/sgml/lobj.sgml | 8 +-- doc/src/sgml/maintenance.sgml | 26 ++++--- doc/src/sgml/manage-ag.sgml | 10 +-- doc/src/sgml/monitoring.sgml | 7 +- doc/src/sgml/mvcc.sgml | 6 +- doc/src/sgml/passwordcheck.sgml | 6 +- doc/src/sgml/perform.sgml | 19 +++-- doc/src/sgml/plhandler.sgml | 8 +-- doc/src/sgml/plperl.sgml | 6 +- doc/src/sgml/plpgsql.sgml | 16 ++--- doc/src/sgml/pltcl.sgml | 5 +- doc/src/sgml/protocol.sgml | 7 +- doc/src/sgml/queries.sgml | 7 +- doc/src/sgml/query.sgml | 5 +- doc/src/sgml/ref/abort.sgml | 14 ++-- doc/src/sgml/ref/alter_aggregate.sgml | 8 +-- doc/src/sgml/ref/alter_conversion.sgml | 8 +-- doc/src/sgml/ref/alter_database.sgml | 16 ++--- doc/src/sgml/ref/alter_default_privileges.sgml | 16 ++--- doc/src/sgml/ref/alter_domain.sgml | 10 +-- doc/src/sgml/ref/alter_foreign_data_wrapper.sgml | 8 +-- doc/src/sgml/ref/alter_function.sgml | 26 +++---- doc/src/sgml/ref/alter_group.sgml | 16 ++--- doc/src/sgml/ref/alter_index.sgml | 16 ++--- doc/src/sgml/ref/alter_language.sgml | 8 +-- doc/src/sgml/ref/alter_large_object.sgml | 6 +- doc/src/sgml/ref/alter_opclass.sgml | 10 +-- doc/src/sgml/ref/alter_operator.sgml | 8 +-- doc/src/sgml/ref/alter_opfamily.sgml | 17 +++-- doc/src/sgml/ref/alter_role.sgml | 40 +++++------ doc/src/sgml/ref/alter_schema.sgml | 8 +-- doc/src/sgml/ref/alter_sequence.sgml | 8 +-- doc/src/sgml/ref/alter_server.sgml | 8 +-- doc/src/sgml/ref/alter_table.sgml | 27 ++++--- doc/src/sgml/ref/alter_tablespace.sgml | 8 +-- doc/src/sgml/ref/alter_trigger.sgml | 8 +-- doc/src/sgml/ref/alter_tsconfig.sgml | 8 +-- doc/src/sgml/ref/alter_tsdictionary.sgml | 8 +-- doc/src/sgml/ref/alter_tsparser.sgml | 8 +-- doc/src/sgml/ref/alter_tstemplate.sgml | 8 +-- doc/src/sgml/ref/alter_type.sgml | 4 +- doc/src/sgml/ref/alter_user.sgml | 8 +-- doc/src/sgml/ref/alter_user_mapping.sgml | 8 +-- doc/src/sgml/ref/alter_view.sgml | 8 +-- doc/src/sgml/ref/analyze.sgml | 22 +++--- doc/src/sgml/ref/begin.sgml | 33 ++++----- doc/src/sgml/ref/checkpoint.sgml | 4 +- doc/src/sgml/ref/close.sgml | 12 ++-- doc/src/sgml/ref/cluster.sgml | 10 +-- doc/src/sgml/ref/clusterdb.sgml | 12 ++-- doc/src/sgml/ref/comment.sgml | 4 +- doc/src/sgml/ref/commit.sgml | 10 +-- doc/src/sgml/ref/commit_prepared.sgml | 8 +-- doc/src/sgml/ref/copy.sgml | 8 +-- doc/src/sgml/ref/create_aggregate.sgml | 8 +-- doc/src/sgml/ref/create_cast.sgml | 15 ++-- doc/src/sgml/ref/create_constraint.sgml | 20 +++--- doc/src/sgml/ref/create_conversion.sgml | 10 +-- doc/src/sgml/ref/create_database.sgml | 16 ++--- doc/src/sgml/ref/create_domain.sgml | 8 +-- doc/src/sgml/ref/create_foreign_data_wrapper.sgml | 12 ++-- doc/src/sgml/ref/create_function.sgml | 20 +++--- doc/src/sgml/ref/create_group.sgml | 8 +-- doc/src/sgml/ref/create_index.sgml | 10 +-- doc/src/sgml/ref/create_language.sgml | 22 +++--- doc/src/sgml/ref/create_opclass.sgml | 12 ++-- doc/src/sgml/ref/create_operator.sgml | 16 ++--- doc/src/sgml/ref/create_opfamily.sgml | 14 ++-- doc/src/sgml/ref/create_role.sgml | 34 ++++----- doc/src/sgml/ref/create_rule.sgml | 4 +- doc/src/sgml/ref/create_schema.sgml | 8 +-- doc/src/sgml/ref/create_sequence.sgml | 8 +-- doc/src/sgml/ref/create_server.sgml | 12 ++-- doc/src/sgml/ref/create_table.sgml | 27 ++++--- doc/src/sgml/ref/create_table_as.sgml | 33 +++++---- doc/src/sgml/ref/create_tablespace.sgml | 14 ++-- doc/src/sgml/ref/create_trigger.sgml | 13 ++-- doc/src/sgml/ref/create_tsconfig.sgml | 8 +-- doc/src/sgml/ref/create_tsdictionary.sgml | 8 +-- doc/src/sgml/ref/create_tsparser.sgml | 8 +-- doc/src/sgml/ref/create_tstemplate.sgml | 8 +-- doc/src/sgml/ref/create_type.sgml | 12 ++-- doc/src/sgml/ref/create_user.sgml | 8 +-- doc/src/sgml/ref/create_user_mapping.sgml | 12 ++-- doc/src/sgml/ref/create_view.sgml | 16 ++--- doc/src/sgml/ref/createdb.sgml | 16 ++--- doc/src/sgml/ref/createlang.sgml | 8 +-- doc/src/sgml/ref/createuser.sgml | 13 ++-- doc/src/sgml/ref/deallocate.sgml | 10 +-- doc/src/sgml/ref/declare.sgml | 26 +++---- doc/src/sgml/ref/delete.sgml | 8 +-- doc/src/sgml/ref/discard.sgml | 4 +- doc/src/sgml/ref/do.sgml | 6 +- doc/src/sgml/ref/drop_aggregate.sgml | 8 +-- doc/src/sgml/ref/drop_cast.sgml | 6 +- doc/src/sgml/ref/drop_conversion.sgml | 8 +-- doc/src/sgml/ref/drop_database.sgml | 8 +-- doc/src/sgml/ref/drop_domain.sgml | 8 +-- doc/src/sgml/ref/drop_foreign_data_wrapper.sgml | 8 +-- doc/src/sgml/ref/drop_function.sgml | 8 +-- doc/src/sgml/ref/drop_group.sgml | 8 +-- doc/src/sgml/ref/drop_index.sgml | 6 +- doc/src/sgml/ref/drop_language.sgml | 8 +-- doc/src/sgml/ref/drop_opclass.sgml | 10 +-- doc/src/sgml/ref/drop_operator.sgml | 8 +-- doc/src/sgml/ref/drop_opfamily.sgml | 14 ++-- doc/src/sgml/ref/drop_owned.sgml | 11 ++- doc/src/sgml/ref/drop_role.sgml | 16 ++--- doc/src/sgml/ref/drop_rule.sgml | 6 +- doc/src/sgml/ref/drop_schema.sgml | 8 +-- doc/src/sgml/ref/drop_sequence.sgml | 8 +-- doc/src/sgml/ref/drop_server.sgml | 8 +-- doc/src/sgml/ref/drop_table.sgml | 13 ++-- doc/src/sgml/ref/drop_tablespace.sgml | 8 +-- doc/src/sgml/ref/drop_trigger.sgml | 6 +- doc/src/sgml/ref/drop_tsconfig.sgml | 8 +-- doc/src/sgml/ref/drop_tsdictionary.sgml | 8 +-- doc/src/sgml/ref/drop_tsparser.sgml | 8 +-- doc/src/sgml/ref/drop_tstemplate.sgml | 8 +-- doc/src/sgml/ref/drop_type.sgml | 8 +-- doc/src/sgml/ref/drop_user.sgml | 8 +-- doc/src/sgml/ref/drop_user_mapping.sgml | 8 +-- doc/src/sgml/ref/drop_view.sgml | 8 +-- doc/src/sgml/ref/dropdb.sgml | 13 ++-- doc/src/sgml/ref/droplang.sgml | 8 +-- doc/src/sgml/ref/dropuser.sgml | 13 ++-- doc/src/sgml/ref/end.sgml | 17 +++-- doc/src/sgml/ref/execute.sgml | 12 ++-- doc/src/sgml/ref/explain.sgml | 8 +-- doc/src/sgml/ref/fetch.sgml | 14 ++-- doc/src/sgml/ref/grant.sgml | 32 ++++----- doc/src/sgml/ref/initdb.sgml | 4 +- doc/src/sgml/ref/insert.sgml | 8 +-- doc/src/sgml/ref/listen.sgml | 10 +-- doc/src/sgml/ref/load.sgml | 8 +-- doc/src/sgml/ref/lock.sgml | 13 ++-- doc/src/sgml/ref/move.sgml | 12 ++-- doc/src/sgml/ref/notify.sgml | 8 +-- doc/src/sgml/ref/pg_config-ref.sgml | 4 +- doc/src/sgml/ref/pg_controldata.sgml | 4 +- doc/src/sgml/ref/pg_ctl-ref.sgml | 4 +- doc/src/sgml/ref/pg_dumpall.sgml | 4 +- doc/src/sgml/ref/pg_resetxlog.sgml | 4 +- doc/src/sgml/ref/postmaster.sgml | 4 +- doc/src/sgml/ref/prepare.sgml | 18 +++-- doc/src/sgml/ref/prepare_transaction.sgml | 14 ++-- doc/src/sgml/ref/psql-ref.sgml | 35 +++++---- doc/src/sgml/ref/reassign_owned.sgml | 11 ++- doc/src/sgml/ref/reindex.sgml | 4 +- doc/src/sgml/ref/reindexdb.sgml | 10 +-- doc/src/sgml/ref/release_savepoint.sgml | 18 ++--- doc/src/sgml/ref/reset.sgml | 12 ++-- doc/src/sgml/ref/revoke.sgml | 12 ++-- doc/src/sgml/ref/rollback.sgml | 12 ++-- doc/src/sgml/ref/rollback_prepared.sgml | 8 +-- doc/src/sgml/ref/rollback_to.sgml | 16 ++--- doc/src/sgml/ref/savepoint.sgml | 20 +++--- doc/src/sgml/ref/select.sgml | 8 +-- doc/src/sgml/ref/select_into.sgml | 14 ++-- doc/src/sgml/ref/set.sgml | 10 +-- doc/src/sgml/ref/set_constraints.sgml | 4 +- doc/src/sgml/ref/set_role.sgml | 14 ++-- doc/src/sgml/ref/set_session_auth.sgml | 10 +-- doc/src/sgml/ref/set_transaction.sgml | 4 +- doc/src/sgml/ref/show.sgml | 10 +-- doc/src/sgml/ref/start_transaction.sgml | 25 +++---- doc/src/sgml/ref/truncate.sgml | 4 +- doc/src/sgml/ref/unlisten.sgml | 10 +-- doc/src/sgml/ref/update.sgml | 6 +- doc/src/sgml/ref/vacuum.sgml | 12 ++-- doc/src/sgml/ref/vacuumdb.sgml | 12 ++-- doc/src/sgml/ref/values.sgml | 10 +-- doc/src/sgml/regress.sgml | 4 +- doc/src/sgml/release-9.0.sgml | 4 +- doc/src/sgml/spi.sgml | 6 +- doc/src/sgml/syntax.sgml | 6 +- doc/src/sgml/textsearch.sgml | 4 +- doc/src/sgml/trigger.sgml | 4 +- doc/src/sgml/typeconv.sgml | 6 +- doc/src/sgml/user-manag.sgml | 22 +++--- doc/src/sgml/xaggr.sgml | 4 +- doc/src/sgml/xfunc.sgml | 7 +- doc/src/sgml/xplang.sgml | 6 +- doc/src/sgml/xtypes.sgml | 4 +- 203 files changed, 1132 insertions(+), 1195 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 5ae2f59baea..6bb6ca99d10 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -1,4 +1,4 @@ - + Advanced Features @@ -318,7 +318,7 @@ COMMIT; - Window Functions + Window Functions window function @@ -555,7 +555,7 @@ SELECT sum(salary) OVER w, avg(salary) OVER w More details about window functions can be found in , , and the - reference page. + reference page. diff --git a/doc/src/sgml/arch-dev.sgml b/doc/src/sgml/arch-dev.sgml index 0863920ab23..888f6c2a50e 100644 --- a/doc/src/sgml/arch-dev.sgml +++ b/doc/src/sgml/arch-dev.sgml @@ -1,4 +1,4 @@ - + Overview of PostgreSQL Internals @@ -346,8 +346,8 @@ space. In particular, this occurs when executing queries involving large numbers of join operations. In order to determine a reasonable (not necessarily optimal) query plan in a reasonable amount - of time, PostgreSQL uses a when the number of joins + of time, PostgreSQL uses a Genetic + Query Optimizer (see ) when the number of joins exceeds a threshold (see ). diff --git a/doc/src/sgml/auto-explain.sgml b/doc/src/sgml/auto-explain.sgml index 2612bf6dbaf..56340b11de9 100644 --- a/doc/src/sgml/auto-explain.sgml +++ b/doc/src/sgml/auto-explain.sgml @@ -1,4 +1,4 @@ - + auto_explain @@ -10,7 +10,7 @@ The auto_explain module provides a means for logging execution plans of slow statements automatically, without - having to run + having to run by hand. This is especially helpful for tracking down un-optimized queries in large applications. diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 4180306a7ce..1007fdc5f28 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -1,4 +1,4 @@ - + Backup and Restore @@ -166,10 +166,10 @@ pg_dump -h host1 dbname | psql -h h After restoring a backup, it is wise to run on each + linkend="sql-analyze"> on each database so the query optimizer has useful statistics; - see - and for more information. + see + and for more information. For more advice on how to load large amounts of data into PostgreSQL efficiently, refer to . @@ -1293,14 +1293,14 @@ archive_command = 'local_backup_script.sh' deleted rows will still retain pointers. In other words, if you modify a table with a hash index on it then you will get incorrect query results on a standby server. When recovery completes it is recommended that you - manually + manually each such index after completing a recovery operation. - If a + If a command is executed while a base backup is being taken, and then the template database that the CREATE DATABASE copied is modified while the base backup is still in progress, it is @@ -1313,7 +1313,7 @@ archive_command = 'local_backup_script.sh' - + commands are WAL-logged with the literal absolute path, and will therefore be replayed as tablespace creations with the same absolute path. This might be undesirable if the log is being diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index b104e0ef2c0..4ab833133c3 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,4 +1,4 @@ - + @@ -354,7 +354,7 @@ New aggregate functions are registered with the + linkend="sql-createaggregate"> command. See for more information about writing aggregate functions and the meaning of the transition functions, etc. @@ -886,7 +886,7 @@ attstattarget controls the level of detail of statistics accumulated for this column by - . + . A zero value indicates that no statistics should be collected. A negative value says to use the system default statistics target. The exact meaning of positive values is data type-dependent. @@ -1274,7 +1274,7 @@ The catalog pg_cast stores data type conversion paths, both built-in paths and those defined with - . + . @@ -1662,8 +1662,8 @@ Access privileges; see - and - + and + for details @@ -1962,7 +1962,7 @@ The catalog pg_conversion describes the available encoding conversion procedures. See - + for more information. @@ -2047,7 +2047,7 @@ The catalog pg_database stores information about the available databases. Databases are created with the command. + linkend="sql-createdatabase"> command. Consult for details about the meaning of some of the parameters. @@ -2185,8 +2185,8 @@ Access privileges; see - and - + and + for details @@ -2467,7 +2467,7 @@ The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated - with the command and viewed with + with the command and viewed with psql's \d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description. @@ -2643,8 +2643,8 @@ Access privileges; see - and - + and + for details @@ -2732,8 +2732,8 @@ Access privileges; see - and - + and + for details @@ -3000,7 +3000,7 @@ The catalog pg_language registers languages in which you can write functions or stored procedures. - See + See and for more information about language handlers. @@ -3076,7 +3076,7 @@ This references a function that is responsible for executing inline anonymous code blocks - ( blocks). + ( blocks). Zero if inline blocks are not supported @@ -3098,8 +3098,8 @@ Access privileges; see - and - + and + for details @@ -3231,8 +3231,8 @@ Access privileges; see - and - + and + for details @@ -3290,8 +3290,8 @@ Access privileges; see - and - + and + for details @@ -3418,7 +3418,7 @@ The catalog pg_operator stores information about operators. - See + See and for more information. @@ -3745,7 +3745,7 @@ The catalog pg_proc stores information about functions (or procedures). - See + See and for more information. @@ -4011,8 +4011,8 @@ Access privileges; see - and - + and + for details @@ -4368,8 +4368,7 @@ The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be - manipulated with the command and viewed with + manipulated with the command and viewed with psql's \d commands. @@ -4437,7 +4436,7 @@ The catalog pg_statistic stores statistical data about the contents of the database. Entries are - created by + created by and subsequently used by the query planner. Note that all the statistical data is inherently approximate, even assuming that it is up-to-date. @@ -4668,8 +4667,8 @@ Access privileges; see - and - + and + for details @@ -4697,7 +4696,7 @@ The catalog pg_trigger stores triggers on tables. - See + See for more information. @@ -5250,9 +5249,9 @@ The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with - , and + , and domains with - . + . A composite type is automatically created for each table in the database, to represent the row structure of the table. It is also possible to create composite types with CREATE TYPE AS. @@ -5917,7 +5916,7 @@ - via the + via the statement in SQL @@ -6414,8 +6413,7 @@ The pg_prepared_statements view displays all the prepared statements that are available in the current - session. See for more information about prepared + session. See for more information about prepared statements. @@ -6423,8 +6421,7 @@ pg_prepared_statements contains one row for each prepared statement. Rows are added to the view when a new prepared statement is created and removed when a prepared statement - is released (for example, via the command). + is released (for example, via the command). @@ -6504,8 +6501,7 @@ The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase - commit (see for details). + commit (see for details). @@ -6780,8 +6776,8 @@ The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative - interface to the - and commands. + interface to the + and commands. It also provides access to some facts about each parameter that are not directly available from SHOW, such as minimum and maximum values. @@ -6900,7 +6896,7 @@ The pg_settings view cannot be inserted into or deleted from, but it can be updated. An UPDATE applied to a row of pg_settings is equivalent to executing - the command on that named + the command on that named parameter. The change only affects the value used by the current session. If an UPDATE is issued within a transaction that is later aborted, the effects of the UPDATE command diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml index 59d19383fba..38b13954ea5 100644 --- a/doc/src/sgml/client-auth.sgml +++ b/doc/src/sgml/client-auth.sgml @@ -1,4 +1,4 @@ - + Client Authentication @@ -785,8 +785,8 @@ omicron bryanh guest1 separate from operating system user passwords. The password for each database user is stored in the pg_authid system catalog. Passwords can be managed with the SQL commands - and - , + and + , e.g., CREATE USER foo WITH PASSWORD 'secret'. If no password has been set up for a user, the stored password is null and password authentication will always fail for that user. diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 988775dd123..81b0ba34457 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ - + Server Configuration @@ -135,8 +135,8 @@ env PGOPTIONS='-c geqo=off' psql Furthermore, it is possible to assign a set of parameter settings to a user or a database. Whenever a session is started, the default settings for the user and database involved are loaded. The - commands - and , + commands + and , respectively, are used to configure these settings. Per-database settings override anything received from the postgres command-line or the configuration @@ -146,7 +146,7 @@ env PGOPTIONS='-c geqo=off' psql Some parameters can be changed in individual SQL - sessions with the + sessions with the command, for example: SET ENABLE_SEQSCAN TO OFF; @@ -161,7 +161,7 @@ SET ENABLE_SEQSCAN TO OFF; - The + The command allows inspection of the current values of all parameters. @@ -654,8 +654,8 @@ SET ENABLE_SEQSCAN TO OFF; When a password is specified in or - + linkend="sql-createuser"> or + without writing either ENCRYPTED or UNENCRYPTED, this parameter determines whether the password is to be encrypted. The default is on @@ -836,8 +836,7 @@ SET ENABLE_SEQSCAN TO OFF; Sets the maximum number of transactions that can be in the prepared state simultaneously (see ). + linkend="sql-prepare-transaction">). Setting this parameter to zero (which is the default) disables the prepared-transaction feature. This parameter can only be set at server start. @@ -1039,14 +1038,12 @@ SET ENABLE_SEQSCAN TO OFF; - - Cost-Based Vacuum Delay - + Cost-Based Vacuum Delay - During the execution of and commands, the system maintains an + During the execution of + and + commands, the system maintains an internal counter that keeps track of the estimated cost of the various I/O operations that are performed. When the accumulated cost reaches a limit (specified by @@ -1908,10 +1905,9 @@ archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"' # Windows of these configuration parameters to force the optimizer to choose a different plan. Better ways to improve the quality of the - plans chosen by the optimizer include adjusting the , running manually, increasing + plans chosen by the optimizer include adjusting the planer cost + constants (see ), + running manually, increasing the value of the configuration parameter, and increasing the amount of statistics collected for @@ -2058,9 +2054,7 @@ archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"' # Windows - - Planner Cost Constants - + Planner Cost Constants The cost variables described in this section are measured @@ -4182,8 +4176,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; This parameter is normally on. When set to off, it disables validation of the function body string during . Disabling validation is + linkend="sql-createfunction">. Disabling validation is occasionally useful to avoid problems such as forward references when restoring function definitions from a dump. @@ -4210,8 +4203,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; Consult and for more information. + linkend="sql-set-transaction"> for more information. @@ -4233,8 +4225,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - Consult for more information. + Consult for more information. @@ -4251,7 +4242,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; superuser privilege and results in discarding any previously cached query plans. Possible values are origin (the default), replica and local. - See for + See for more information. diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 0ad4fd7567d..59a46ad0a3a 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,7 +1,7 @@ - + - Data Types + Data Types data type @@ -16,7 +16,7 @@ PostgreSQL has a rich set of native data types available to users. Users can add new types to PostgreSQL using the command. + linkend="sql-createtype"> command. @@ -2843,7 +2843,7 @@ SELECT * FROM test1 WHERE a; Enum types are created using the command, + linkend="sql-createtype"> command, for example: diff --git a/doc/src/sgml/dblink.sgml b/doc/src/sgml/dblink.sgml index 5672c1bb630..d90ea59982b 100644 --- a/doc/src/sgml/dblink.sgml +++ b/doc/src/sgml/dblink.sgml @@ -1,4 +1,4 @@ - + dblink @@ -51,9 +51,9 @@ the corresponding foreign-data wrapper. See the example below, as well as the following: - - - + + + diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 334ad51082c..c1dc645cc8f 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ - + Data Definition @@ -78,7 +78,7 @@ To create a table, you use the aptly named command. + linkend="sql-createtable"> command. In this command you specify at least a name for the new table, the names of the columns and the data type of each column. For example: @@ -138,7 +138,7 @@ CREATE TABLE products ( If you no longer need a table, you can remove it using the command. + linkend="sql-droptable"> command. For example: DROP TABLE my_first_table; @@ -842,7 +842,7 @@ CREATE TABLE order_items ( If the foreign key references a unique constraint, there are some additional possibilities regarding how null values are matched. These are explained in the reference documentation for - . + . @@ -1126,7 +1126,7 @@ CREATE TABLE circles ( All these actions are performed using the - + command, whose reference page contains details beyond those given here. @@ -1393,7 +1393,7 @@ ALTER TABLE products RENAME TO items; object vary depending on the object's type (table, function, etc). For complete information on the different types of privileges supported by PostgreSQL, refer to the - reference + reference page. The following sections and chapters will also show you how those privileges are used. @@ -1406,7 +1406,7 @@ ALTER TABLE products RENAME TO items; To change the owner of a table, index, sequence, or view, use the - + command. There are corresponding ALTER commands for other object types. @@ -1453,9 +1453,8 @@ REVOKE ALL ON accounts FROM PUBLIC; the right to grant it in turn to others. If the grant option is subsequently revoked then all who received the privilege from that recipient (directly or through a chain of grants) will lose the - privilege. For details see the and reference pages. + privilege. For details see the and + reference pages. @@ -1536,8 +1535,8 @@ REVOKE ALL ON accounts FROM PUBLIC; - To create a schema, use the command. Give the schema a name + To create a schema, use the + command. Give the schema a name of your choice. For example: CREATE SCHEMA myschema; @@ -2109,11 +2108,11 @@ VALUES ('New York', NULL, NULL, 'NY'); Table inheritance is typically established when the child table is created, using the INHERITS clause of the - + statement. Alternatively, a table which is already defined in a compatible way can have a new parent relationship added, using the INHERIT - variant of . + variant of . To do this the new child table must already include columns with the same names and types as the columns of the parent. It must also include check constraints with the same names and check expressions as those of the @@ -2145,7 +2144,7 @@ VALUES ('New York', NULL, NULL, 'NY'); - will + will propagate any changes in column data definitions and check constraints down the inheritance hierarchy. Again, dropping columns that are depended on by other tables is only possible when using diff --git a/doc/src/sgml/dfunc.sgml b/doc/src/sgml/dfunc.sgml index d6e18591c53..310787aa128 100644 --- a/doc/src/sgml/dfunc.sgml +++ b/doc/src/sgml/dfunc.sgml @@ -1,7 +1,7 @@ - + - Compiling and Linking Dynamically-Loaded Functions + Compiling and Linking Dynamically-Loaded Functions Before you are able to use your diff --git a/doc/src/sgml/dml.sgml b/doc/src/sgml/dml.sgml index 33ed078e8c3..69d162efe79 100644 --- a/doc/src/sgml/dml.sgml +++ b/doc/src/sgml/dml.sgml @@ -1,4 +1,4 @@ - + Data Manipulation @@ -37,8 +37,8 @@ - To create a new row, use the command. The command requires the + To create a new row, use the + command. The command requires the table name and column values. For example, consider the products table from : @@ -105,9 +105,9 @@ INSERT INTO products (product_no, name, price) VALUES When inserting a lot of data at the same time, considering using - the command. - It is not as flexible as the command, but is more efficient. Refer + the command. + It is not as flexible as the + command, but is more efficient. Refer to for more information on improving bulk loading performance. @@ -133,8 +133,8 @@ INSERT INTO products (product_no, name, price) VALUES - To update existing rows, use the command. This requires + To update existing rows, use the + command. This requires three pieces of information: @@ -235,7 +235,7 @@ UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a > 0; - You use the + You use the command to remove rows; the syntax is very similar to the UPDATE command. For instance, to remove all rows from the products table that have a price of 10, use: diff --git a/doc/src/sgml/extend.sgml b/doc/src/sgml/extend.sgml index caeda7e75ca..476af79bf4d 100644 --- a/doc/src/sgml/extend.sgml +++ b/doc/src/sgml/extend.sgml @@ -1,4 +1,4 @@ - + Extending <acronym>SQL</acronym> @@ -130,7 +130,7 @@ Composite types, or row types, are created whenever the user creates a table. It is also possible to use to + linkend="sql-createtype"> to define a stand-alone composite type with no associated table. A composite type is simply a list of types with associated field names. A value of a composite type is a row or @@ -152,7 +152,7 @@ Domains can be created using the SQL command - . + . Their creation and use is not discussed in this chapter. diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 411aff0aad3..18c4e364b8d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ - + Functions and Operators @@ -8877,7 +8877,7 @@ table2-mapping functions for operating on sequence objects. Sequence objects (also called sequence generators or just sequences) are special single-row tables created with . + linkend="sql-createsequence">. A sequence object is usually used to generate unique identifiers for rows of a table. The sequence functions, listed in , provide simple, multiuser-safe @@ -9070,7 +9070,7 @@ SELECT setval('foo', 42, false); Next nextval wi If a sequence object has been created with default parameters, successive nextval calls will return successive values beginning with 1. Other behaviors can be obtained by using - special parameters in the command; + special parameters in the command; see its command reference page for more information. @@ -11657,11 +11657,11 @@ postgres=# select * from unnest2(array[[1,2],[3,4]]); The session_user is normally the user who initiated the current database connection; but superusers can change this setting - with . + with . The current_user is the user identifier that is applicable for permission checking. Normally it is equal to the session user, but it can be changed with - . + . It also changes during the execution of functions with the attribute SECURITY DEFINER. In Unix parlance, the session user is the real user and @@ -11695,7 +11695,7 @@ SET search_path TO schema , schema, .. pg_listening_channels returns a set of names of channels that the current session is listening to. See for more information. + linkend="sql-listen"> for more information. @@ -12653,8 +12653,8 @@ SELECT typlen FROM pg_type WHERE oid = pg_typeof(33); The functions shown in - extract comments previously stored with the command. A null value is returned if no + extract comments previously stored with the + command. A null value is returned if no comment could be found for the specified parameters. diff --git a/doc/src/sgml/geqo.sgml b/doc/src/sgml/geqo.sgml index 8418467acb9..75ebdaa4c9a 100644 --- a/doc/src/sgml/geqo.sgml +++ b/doc/src/sgml/geqo.sgml @@ -1,4 +1,4 @@ - + @@ -25,7 +25,7 @@ 1997-10-02 - Genetic Query Optimizer + Genetic Query Optimizer diff --git a/doc/src/sgml/gin.sgml b/doc/src/sgml/gin.sgml index adcb0455e04..2241dd5d9ac 100644 --- a/doc/src/sgml/gin.sgml +++ b/doc/src/sgml/gin.sgml @@ -1,4 +1,4 @@ - + GIN Indexes @@ -241,8 +241,8 @@ If consistent response time is more important than update speed, use of pending entries can be disabled by turning off the FASTUPDATE storage parameter for a - GIN index. See for details. + GIN index. See + for details. diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index 2e8a7a95aa4..13b783bc864 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1,4 +1,4 @@ - + High Availability, Load Balancing, and Replication @@ -201,9 +201,8 @@ protocol to make nodes agree on a serializable transactional order. must query such values from a single server and then use those values in write queries. Also, care must be taken that all transactions either commit or abort on all servers, perhaps - using two-phase commit ( and . + using two-phase commit ( + and . Pgpool-II and Sequoia are examples of this type of replication. @@ -250,9 +249,8 @@ protocol to make nodes agree on a serializable transactional order. PostgreSQL does not offer this type of replication, though PostgreSQL two-phase commit ( and ) + linkend="sql-prepare-transaction"> and ) can be used to implement this in application code or middleware. @@ -552,7 +550,7 @@ protocol to make nodes agree on a serializable transactional order. associated with tablespaces will be passed across unmodified, so both primary and standby servers must have the same mount paths for tablespaces if that feature is used. Keep in mind that if - + is executed on the primary, any new mount point needed for it must be created on the primary and all standby servers before the command is executed. Hardware need not be exactly the same, but experience shows diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 0ab3e25e80b..6f2887bd16d 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,7 +1,7 @@ - + - Indexes + Indexes index @@ -997,7 +997,7 @@ SELECT am.amname AS index_method, maintenance or tuning, it is still important to check which indexes are actually used by the real-life query workload. Examining index usage for an individual query is done with the - + command; its application for this purpose is illustrated in . It is also possible to gather overall statistics about index usage @@ -1015,7 +1015,7 @@ SELECT am.amname AS index_method, - Always run + Always run first. This command collects statistics about the distribution of the values in the table. This information is required to estimate the number of rows @@ -1025,8 +1025,8 @@ SELECT am.amname AS index_method, almost certain to be inaccurate. Examining an application's index usage without having run ANALYZE is therefore a lost cause. - See - and for more information. + See + and for more information. @@ -1093,7 +1093,7 @@ SELECT am.amname AS index_method, An inaccurate selectivity estimate is due to insufficient statistics. It might be possible to improve this by tuning the statistics-gathering parameters (see - ). + ). diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 3a22384057b..c880691438f 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -1,4 +1,4 @@ - + <application>libpq</application> - C Library @@ -1804,12 +1804,12 @@ PGresult *PQprepare(PGconn *conn, Prepared statements for use with PQexecPrepared can also - be created by executing SQL statements. (But PQprepare + be created by executing SQL + statements. (But PQprepare is more flexible since it does not require parameter types to be pre-specified.) Also, although there is no libpq function for deleting a prepared statement, the SQL statement + linkend="sql-deallocate"> statement can be used for that purpose. @@ -4279,7 +4279,7 @@ typedef struct { 0 indicates the overall copy format is textual (rows separated by newlines, columns separated by separator characters, etc). 1 indicates the overall copy format is binary. See for more information. + linkend="sql-copy"> for more information. @@ -4359,8 +4359,7 @@ typedef struct { into buffer loads of any convenient size. Buffer-load boundaries have no semantic significance when sending. The contents of the data stream must match the data format expected by the - COPY command; see for details. + COPY command; see for details. @@ -6102,8 +6101,8 @@ myEventProc(PGEventId evtId, void *evtInfo, void *passThrough) The following environment variables can be used to specify default behavior for each PostgreSQL session. (See - also the - and + also the + and commands for ways to set default behavior on a per-user or per-database basis.) @@ -6151,8 +6150,8 @@ myEventProc(PGEventId evtId, void *evtInfo, void *passThrough) - Refer to the SQL command for information on correct values for these + Refer to the SQL command + for information on correct values for these environment variables. diff --git a/doc/src/sgml/lobj.sgml b/doc/src/sgml/lobj.sgml index 0e567e7dbcd..ea7d1c8dcec 100644 --- a/doc/src/sgml/lobj.sgml +++ b/doc/src/sgml/lobj.sgml @@ -1,7 +1,7 @@ - + - Large Objects + Large Objects large object BLOBlarge object @@ -63,8 +63,8 @@ As of PostgreSQL 9.0, large objects have an owner and a set of access permissions, which can be managed using - and - . + and + . For compatibility with prior releases, see . SELECT privileges are required to read a large diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 91d05b02434..a0977c157b1 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -1,4 +1,4 @@ - + Routine Database Maintenance Tasks @@ -87,7 +87,7 @@ PostgreSQL's - command has to + command has to process each table on a regular basis for several reasons: @@ -210,7 +210,7 @@ their busiest tables as often as once every few minutes.) If you have multiple databases in a cluster, don't forget to VACUUM each one; the program might be helpful. + linkend="app-vacuumdb"> might be helpful. @@ -220,9 +220,9 @@ massive update or delete activity. If you have such a table and you need to reclaim the excess disk space it occupies, you will need to use VACUUM FULL, or alternatively - + or one of the table-rewriting variants of - . + . These commands rewrite an entire new copy of the table and build new indexes for it. All these options require exclusive lock. Note that they also temporarily use extra disk space approximately equal to the size @@ -235,7 +235,7 @@ If you have a table whose entire contents are deleted on a periodic basis, consider doing it with - rather + rather than using DELETE followed by VACUUM. TRUNCATE removes the entire content of the table immediately, without requiring a @@ -247,7 +247,7 @@ - Updating Planner Statistics + Updating Planner Statistics statistics @@ -262,7 +262,7 @@ The PostgreSQL query planner relies on statistical information about the contents of tables in order to generate good plans for queries. These statistics are gathered by - the command, + the command, which can be invoked by itself or as an optional step in VACUUM. It is important to have reasonably accurate statistics, otherwise poor choices of plans might @@ -555,7 +555,7 @@ HINT: Stop the postmaster and use a standalone backend to VACUUM in "mydb". - The Autovacuum Daemon + The Autovacuum Daemon autovacuum @@ -666,10 +666,8 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu Another two parameters, autovacuum_vacuum_cost_delay and autovacuum_vacuum_cost_limit, are used to set - table-specific values for the - - feature. + table-specific values for the cost-based vacuum delay feature + (see ). autovacuum_freeze_min_age, autovacuum_freeze_max_age and autovacuum_freeze_table_age are used to set @@ -697,7 +695,7 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu In some situations it is worthwhile to rebuild indexes periodically - with the + with the command. diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml index da27e74d4ea..e2321d125eb 100644 --- a/doc/src/sgml/manage-ag.sgml +++ b/doc/src/sgml/manage-ag.sgml @@ -1,4 +1,4 @@ - + Managing Databases @@ -86,7 +86,7 @@ SELECT datname FROM pg_database; Databases are created with the SQL command - :CREATE + :CREATE DATABASE CREATE DATABASE name; @@ -314,7 +314,7 @@ ALTER DATABASE mydb SET geqo TO off; Databases are destroyed with the command - :DROP DATABASE + :DROP DATABASE DROP DATABASE name; @@ -380,7 +380,7 @@ dropdb dbname To define a tablespace, use the + linkend="sql-createtablespace"> command, for example:CREATE TABLESPACE: CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data'; @@ -472,7 +472,7 @@ CREATE TABLE foo(i int); To remove an empty tablespace, use the + linkend="sql-droptablespace"> command. diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index ae730203df8..e9fbe9e3043 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,4 +1,4 @@ - + Monitoring Database Activity @@ -27,8 +27,7 @@ ps, top, iostat, and vmstat. Also, once one has identified a poorly-performing query, further investigation might be needed using - PostgreSQL's command. + PostgreSQL's command. discusses EXPLAIN and other methods for understanding the behavior of an individual query. @@ -159,7 +158,7 @@ postgres: user database host postgresql.conf so that they apply to all server processes, but it is possible to turn them on or off in individual sessions using the command. (To prevent + linkend="sql-set"> command. (To prevent ordinary users from hiding their activity from the administrator, only superusers are allowed to change these parameters with SET.) diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index acce32dd9a1..e3687aa34f0 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -1,4 +1,4 @@ - + Concurrency Control @@ -227,7 +227,7 @@ To set the transaction isolation level of a transaction, use the - command . + command . @@ -557,7 +557,7 @@ SELECT SUM(value) FROM mytab WHERE class = 2; which they are used automatically by PostgreSQL. You can also acquire any of these locks explicitly with the command . + linkend="sql-lock">. Remember that all of these lock modes are table-level locks, even if the name contains the word row; the names of the lock modes are historical. diff --git a/doc/src/sgml/passwordcheck.sgml b/doc/src/sgml/passwordcheck.sgml index e46e3dfa034..2da1f52650a 100644 --- a/doc/src/sgml/passwordcheck.sgml +++ b/doc/src/sgml/passwordcheck.sgml @@ -1,4 +1,4 @@ - + passwordcheck @@ -10,8 +10,8 @@ The passwordcheck module checks users' passwords whenever they are set with - or - . + or + . If a password is considered too weak, it will be rejected and the command will terminate with an error. diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 02c5071d2ae..d7c36cc4e9f 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1,4 +1,4 @@ - + Performance Tips @@ -32,7 +32,7 @@ is absolutely critical for good performance, so the system includes a complex planner that tries to choose good plans. You can use the - command + command to see what query plan the planner creates for any query. Plan-reading is an art that deserves an extensive tutorial, which this is not; but here is some basic information. @@ -801,7 +801,7 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; Use <command>COPY</command> - Use to load + Use to load all the rows in one command, instead of using a series of INSERT commands. The COPY command is optimized for loading large numbers of rows; it is less @@ -813,7 +813,7 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; If you cannot use COPY, it might help to use to create a + linkend="sql-prepare"> to create a prepared INSERT statement, and then use EXECUTE as many times as required. This avoids some of the overhead of repeatedly parsing and planning @@ -967,8 +967,7 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; Whenever you have significantly altered the distribution of data - within a table, running is strongly recommended. This + within a table, running is strongly recommended. This includes bulk loading large amounts of data into the table. Running ANALYZE (or VACUUM ANALYZE) ensures that the planner has up-to-date statistics about the @@ -977,8 +976,8 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; performance on any tables with inaccurate or nonexistent statistics. Note that if the autovacuum daemon is enabled, it might run ANALYZE automatically; see - - and for more information. + + and for more information. @@ -1062,8 +1061,8 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; maintenance_work_mem; rather, you'd do that while manually recreating indexes and foreign keys afterwards. And don't forget to ANALYZE when you're done; see - - and for more information. + + and for more information. diff --git a/doc/src/sgml/plhandler.sgml b/doc/src/sgml/plhandler.sgml index eb3c58243ee..058eefbd655 100644 --- a/doc/src/sgml/plhandler.sgml +++ b/doc/src/sgml/plhandler.sgml @@ -1,4 +1,4 @@ - + Writing A Procedural Language Handler @@ -162,10 +162,10 @@ CREATE LANGUAGE plsample are a validator and an inline handler. A validator can be provided to allow language-specific checking to be done during - . + . An inline handler can be provided to allow the language to support anonymous code blocks executed via the command. + > command. @@ -218,7 +218,7 @@ CREATE LANGUAGE plsample The procedural languages included in the standard distribution are good references when trying to write your own language handler. Look into the src/pl subdirectory of the source tree. - The + The reference page also has some useful details. diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml index 9d6c470263b..c4129510fc1 100644 --- a/doc/src/sgml/plperl.sgml +++ b/doc/src/sgml/plperl.sgml @@ -1,4 +1,4 @@ - + PL/Perl - Perl Procedural Language @@ -51,7 +51,7 @@ To create a function in the PL/Perl language, use the standard - + syntax: @@ -69,7 +69,7 @@ $$ LANGUAGE plperl; PL/Perl also supports anonymous code blocks called with the - statement: + statement: DO $$ diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index b682db80bc0..e0ecd1f3aa2 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,4 +1,4 @@ - + <application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language @@ -1124,7 +1124,7 @@ EXECUTE 'SELECT count(*) FROM ' The PL/pgSQL EXECUTE statement is not related to the - SQL + SQL statement supported by the PostgreSQL server. The server's EXECUTE statement cannot be used directly within @@ -2610,8 +2610,8 @@ FETCH direction { FROM | IN } The direction clause can be any of the - variants allowed in the SQL command except the ones that can fetch + variants allowed in the SQL + command except the ones that can fetch more than one row; namely, it can be NEXT, PRIOR, @@ -2662,8 +2662,8 @@ MOVE direction { FROM | IN } < The direction clause can be any of the - variants allowed in the SQL command, namely + variants allowed in the SQL + command, namely NEXT, PRIOR, FIRST, @@ -2705,7 +2705,7 @@ DELETE FROM table WHERE CURRENT OF curso restrictions on what the cursor's query can be (in particular, no grouping) and it's best to use FOR UPDATE in the cursor. For more information see the - + reference page. @@ -4625,7 +4625,7 @@ $$ LANGUAGE plpgsql; the function always returns the same result when given the same arguments) and strictness (whether the function returns null if any argument is null). Consult the + linkend="sql-createfunction"> reference page for details. diff --git a/doc/src/sgml/pltcl.sgml b/doc/src/sgml/pltcl.sgml index 899891bee51..c4ea226a7fe 100644 --- a/doc/src/sgml/pltcl.sgml +++ b/doc/src/sgml/pltcl.sgml @@ -1,4 +1,4 @@ - + PL/Tcl - Tcl Procedural Language @@ -79,8 +79,7 @@ To create a function in the PL/Tcl language, use - the standard syntax: + the standard syntax: CREATE FUNCTION funcname (argument-types) RETURNS return-type AS $$ diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index bb95ab71499..70762671610 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -1,4 +1,4 @@ - + Frontend/Backend Protocol @@ -2419,7 +2419,7 @@ CopyInResponse (B) characters, etc). 1 indicates the overall copy format is binary (similar to DataRow format). - See + See for more information. @@ -2493,8 +2493,7 @@ CopyOutResponse (B) is textual (rows separated by newlines, columns separated by separator characters, etc). 1 indicates the overall copy format is binary (similar to DataRow - format). See for more information. + format). See for more information. diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 479d9baf448..5e165a38f2b 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ - + Queries @@ -24,7 +24,7 @@ The process of retrieving or the command to retrieve data from a database is called a query. In SQL the - command is + command is used to specify queries. The general syntax of the SELECT command is @@ -1508,8 +1508,7 @@ SELECT select_list FROM table_expression - For more information see . + For more information see . diff --git a/doc/src/sgml/query.sgml b/doc/src/sgml/query.sgml index d9fcc23cd99..0fd711368fe 100644 --- a/doc/src/sgml/query.sgml +++ b/doc/src/sgml/query.sgml @@ -1,4 +1,4 @@ - + The <acronym>SQL</acronym> Language @@ -267,8 +267,7 @@ COPY weather FROM '/home/user/weather.txt'; where the file name for the source file must be available to the backend server machine, not the client, since the backend server reads the file directly. You can read more about the - COPY command in . + COPY command in . diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml index 527a7bbf7e7..4261cafe9b5 100644 --- a/doc/src/sgml/ref/abort.sgml +++ b/doc/src/sgml/ref/abort.sgml @@ -1,11 +1,11 @@ - ABORT + ABORT 7 SQL - Language Statements @@ -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 SQL command - , + , and is present only for historical reasons. @@ -58,7 +58,7 @@ ABORT [ WORK | TRANSACTION ] Notes - Use to + Use to successfully terminate a transaction. @@ -93,9 +93,9 @@ ABORT; See Also - - - + + + diff --git a/doc/src/sgml/ref/alter_aggregate.sgml b/doc/src/sgml/ref/alter_aggregate.sgml index 3f9f97a49ff..9c9cc464c38 100644 --- a/doc/src/sgml/ref/alter_aggregate.sgml +++ b/doc/src/sgml/ref/alter_aggregate.sgml @@ -1,11 +1,11 @@ - ALTER AGGREGATE + ALTER AGGREGATE 7 SQL - Language Statements @@ -142,8 +142,8 @@ ALTER AGGREGATE myavg(integer) SET SCHEMA myschema; See Also - - + + diff --git a/doc/src/sgml/ref/alter_conversion.sgml b/doc/src/sgml/ref/alter_conversion.sgml index 4be65d30a7a..0576fd4eda5 100644 --- a/doc/src/sgml/ref/alter_conversion.sgml +++ b/doc/src/sgml/ref/alter_conversion.sgml @@ -1,11 +1,11 @@ - ALTER CONVERSION + ALTER CONVERSION 7 SQL - Language Statements @@ -111,8 +111,8 @@ ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe; See Also - - + + diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index a30e39718ad..f150fbb7556 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -1,11 +1,11 @@ - ALTER DATABASE + ALTER DATABASE 7 SQL - Language Statements @@ -160,7 +160,7 @@ ALTER DATABASE name RESET ALL - See and + See and for more information about allowed parameter names and values. @@ -175,7 +175,7 @@ ALTER DATABASE name RESET ALL It is also possible to tie a session default to a specific role rather than to a database; see - . + . Role-specific settings override database-specific ones if there is a conflict. @@ -207,10 +207,10 @@ ALTER DATABASE test SET enable_indexscan TO off; See Also - - - - + + + + diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml index 66bf72b4e34..9c16903f8aa 100644 --- a/doc/src/sgml/ref/alter_default_privileges.sgml +++ b/doc/src/sgml/ref/alter_default_privileges.sgml @@ -1,11 +1,11 @@ - ALTER DEFAULT PRIVILEGES + ALTER DEFAULT PRIVILEGES 7 SQL - Language Statements @@ -85,7 +85,7 @@ REVOKE [ GRANT OPTION FOR ] - As explained under , + As explained under , the default privileges for any object type normally grant all grantable permissions to the object owner, and may grant some privileges to PUBLIC as well. However, this behavior can be changed by @@ -127,8 +127,8 @@ REVOKE [ GRANT OPTION FOR ] This parameter, and all the other parameters in abbreviated_grant_or_revoke, act as described under - or - , + or + , except that one is setting permissions for a whole class of objects rather than specific named objects. @@ -146,7 +146,7 @@ REVOKE [ GRANT OPTION FOR ] to obtain information about existing assignments of default privileges. The meaning of the privilege values is the same as explained for \dp under - . + . @@ -203,8 +203,8 @@ ALTER DEFAULT PRIVILEGES FOR ROLE admin REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC; See Also - - + + diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml index b265ce216f0..dd921e1dc55 100644 --- a/doc/src/sgml/ref/alter_domain.sgml +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -1,11 +1,11 @@ - ALTER DOMAIN + ALTER DOMAIN 7 SQL - Language Statements @@ -74,7 +74,7 @@ ALTER DOMAIN name This form adds a new constraint to a domain using the same syntax as - . + . This will only succeed if all columns using the domain satisfy the new constraint. @@ -260,8 +260,8 @@ ALTER DOMAIN zipcode SET SCHEMA customers; See Also - - + + diff --git a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml index 79348bda6fd..41a195db4c0 100644 --- a/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/alter_foreign_data_wrapper.sgml @@ -1,11 +1,11 @@ - ALTER FOREIGN DATA WRAPPER + ALTER FOREIGN DATA WRAPPER 7 SQL - Language Statements @@ -136,8 +136,8 @@ ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator; See Also - - + + diff --git a/doc/src/sgml/ref/alter_function.sgml b/doc/src/sgml/ref/alter_function.sgml index cce23760040..23145932f41 100644 --- a/doc/src/sgml/ref/alter_function.sgml +++ b/doc/src/sgml/ref/alter_function.sgml @@ -1,11 +1,11 @@ - ALTER FUNCTION + ALTER FUNCTION 7 SQL - Language Statements @@ -159,8 +159,8 @@ ALTER FUNCTION name ( [ [ for more information. + is assumed automatically. See + for more information. @@ -173,8 +173,7 @@ ALTER FUNCTION name ( [ [ for details. + See for details. @@ -187,8 +186,7 @@ ALTER FUNCTION name ( [ [ for more information about + conformance. See for more information about this capability. @@ -200,8 +198,7 @@ ALTER FUNCTION name ( [ [ for more information. + See for more information. @@ -212,8 +209,7 @@ ALTER FUNCTION name ( [ [ for more information. + function. See for more information. @@ -235,7 +231,7 @@ ALTER FUNCTION name ( [ [ and + See and for more information about allowed parameter names and values. @@ -317,8 +313,8 @@ ALTER FUNCTION check_password(text) RESET search_path; See Also - - + + diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml index 2d4d3e90159..64e5da8d0ff 100644 --- a/doc/src/sgml/ref/alter_group.sgml +++ b/doc/src/sgml/ref/alter_group.sgml @@ -1,11 +1,11 @@ - ALTER GROUP + ALTER GROUP 7 SQL - Language Statements @@ -44,14 +44,14 @@ ALTER GROUP group_name RENAME TO group for this purpose.) These variants are effectively equivalent to granting or revoking membership in the role named as the group; so the preferred way to do this is to use - or - . + or + . The third variant changes the name of the group. This is exactly equivalent to renaming the role with - . + . @@ -121,9 +121,9 @@ ALTER GROUP workers DROP USER beth; See Also - - - + + + diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index dd9912ec4e2..6d04b108f08 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -1,11 +1,11 @@ - ALTER INDEX + ALTER INDEX 7 SQL - Language Statements @@ -54,7 +54,7 @@ ALTER INDEX name RESET ( . + . @@ -65,11 +65,11 @@ ALTER INDEX name RESET ( This form changes one or more index-method-specific storage parameters for the index. See - + 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 - + to get the desired effects. @@ -151,7 +151,7 @@ ALTER INDEX name RESET ( These operations are also possible using - . + . ALTER INDEX is in fact just an alias for the forms of ALTER TABLE that apply to indexes. @@ -209,8 +209,8 @@ REINDEX INDEX distributors; See Also - - + + diff --git a/doc/src/sgml/ref/alter_language.sgml b/doc/src/sgml/ref/alter_language.sgml index 94c9222c1f0..362b3411fb9 100644 --- a/doc/src/sgml/ref/alter_language.sgml +++ b/doc/src/sgml/ref/alter_language.sgml @@ -1,11 +1,11 @@ - ALTER LANGUAGE + ALTER LANGUAGE 7 SQL - Language Statements @@ -83,8 +83,8 @@ ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO See Also - - + + diff --git a/doc/src/sgml/ref/alter_large_object.sgml b/doc/src/sgml/ref/alter_large_object.sgml index fb278f8e330..1e90a165a99 100755 --- a/doc/src/sgml/ref/alter_large_object.sgml +++ b/doc/src/sgml/ref/alter_large_object.sgml @@ -1,11 +1,11 @@ - ALTER LARGE OBJECT + ALTER LARGE OBJECT 7 SQL - Language Statements @@ -73,7 +73,7 @@ ALTER LARGE OBJECT large_object_oid See Also - + diff --git a/doc/src/sgml/ref/alter_opclass.sgml b/doc/src/sgml/ref/alter_opclass.sgml index fbdc051b80e..ef3078bfe43 100644 --- a/doc/src/sgml/ref/alter_opclass.sgml +++ b/doc/src/sgml/ref/alter_opclass.sgml @@ -1,11 +1,11 @@ - ALTER OPERATOR CLASS + ALTER OPERATOR CLASS 7 SQL - Language Statements @@ -101,9 +101,9 @@ ALTER OPERATOR CLASS name USING - - - + + + diff --git a/doc/src/sgml/ref/alter_operator.sgml b/doc/src/sgml/ref/alter_operator.sgml index 9e6e8aff479..d67ae302d04 100644 --- a/doc/src/sgml/ref/alter_operator.sgml +++ b/doc/src/sgml/ref/alter_operator.sgml @@ -1,11 +1,11 @@ - ALTER OPERATOR + ALTER OPERATOR 7 SQL - Language Statements @@ -112,8 +112,8 @@ ALTER OPERATOR @@ (text, text) OWNER TO joe; See Also - - + + diff --git a/doc/src/sgml/ref/alter_opfamily.sgml b/doc/src/sgml/ref/alter_opfamily.sgml index 6e28b8540a8..70f20db2b40 100644 --- a/doc/src/sgml/ref/alter_opfamily.sgml +++ b/doc/src/sgml/ref/alter_opfamily.sgml @@ -1,11 +1,11 @@ - ALTER OPERATOR FAMILY + ALTER OPERATOR FAMILY 7 SQL - Language Statements @@ -52,8 +52,7 @@ ALTER OPERATOR FAMILY name USING .) + instead; see .) PostgreSQL will allow loose members of a family to be dropped from the family at any time, but members of an operator class cannot be dropped without dropping the whole class and @@ -313,11 +312,11 @@ ALTER OPERATOR FAMILY integer_ops USING btree DROP See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index 2d09de10c4c..3a2504cd0a0 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -1,11 +1,11 @@ - ALTER ROLE + ALTER ROLE 7 SQL - Language Statements @@ -55,11 +55,11 @@ ALTER ROLE name [ IN DATABASE The first variant of this command listed in the synopsis can change many of the role attributes that can be specified in - . + . (All the possible attributes are covered, except that there are no options for adding or removing memberships; use - and - for that.) + and + 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 CREATEROLE privilege can change any of these @@ -88,7 +88,7 @@ ALTER ROLE name [ IN DATABASE postgresql.conf or has been received from the postgres command line. This only happens at login time, so configuration settings associated with a role to which you've will be ignored. Settings set to + linkend="sql-set-role"> will be ignored. Settings set to a role directly are overridden by any database specific settings attached to a role. Superusers can change anyone's session defaults. Roles having CREATEROLE privilege can change defaults for non-superuser @@ -131,8 +131,7 @@ ALTER ROLE name [ IN DATABASE These clauses alter attributes originally set by - . For more information, see the + . For more information, see the CREATE ROLE reference page. @@ -176,12 +175,12 @@ ALTER ROLE name [ IN DATABASE Role-specific variable setting take effect only at login; - + does not process role-specific variable settings. - See and and for more information about allowed parameter names and values. @@ -194,15 +193,14 @@ ALTER ROLE name [ IN DATABASE Notes - Use - to add new roles, and to remove a role. + Use + to add new roles, and to remove a role. ALTER ROLE cannot change a role's memberships. - Use and - + Use and + to do that. @@ -210,8 +208,8 @@ ALTER ROLE name [ IN DATABASE contains a command + history or the server log. + contains a command \password that can be used to safely change a role's password. @@ -219,7 +217,7 @@ ALTER ROLE name [ IN DATABASE It is also possible to tie a session default to a specific database rather than to a role; see - . + . If there is a conflict, database-role-specific settings override role-specific ones, which in turn override database-specific ones. @@ -300,9 +298,9 @@ ALTER ROLE fred IN DATABASE devel SET client_min_messages = DEBUG; See Also - - - + + + diff --git a/doc/src/sgml/ref/alter_schema.sgml b/doc/src/sgml/ref/alter_schema.sgml index 122b0746097..7f510e9ad42 100644 --- a/doc/src/sgml/ref/alter_schema.sgml +++ b/doc/src/sgml/ref/alter_schema.sgml @@ -1,11 +1,11 @@ - ALTER SCHEMA + ALTER SCHEMA 7 SQL - Language Statements @@ -92,8 +92,8 @@ ALTER SCHEMA name OWNER TO new_ownerSee Also - - + + diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index 6d6a9a62f2b..34f13d4bc07 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -1,11 +1,11 @@ - ALTER SEQUENCE + ALTER SEQUENCE 7 SQL - Language Statements @@ -302,8 +302,8 @@ ALTER SEQUENCE serial RESTART WITH 105; See Also - - + + diff --git a/doc/src/sgml/ref/alter_server.sgml b/doc/src/sgml/ref/alter_server.sgml index 1bce7fb4de8..dfd72431b2a 100644 --- a/doc/src/sgml/ref/alter_server.sgml +++ b/doc/src/sgml/ref/alter_server.sgml @@ -1,11 +1,11 @@ - ALTER SERVER + ALTER SERVER 7 SQL - Language Statements @@ -116,8 +116,8 @@ ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz'); See Also - - + + diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 222637eb12f..16007ef2734 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,11 +1,11 @@ - ALTER TABLE + ALTER TABLE 7 SQL - Language Statements @@ -78,7 +78,7 @@ ALTER TABLE name This form adds a new column to the table, using the same syntax as - . + . @@ -147,7 +147,7 @@ ALTER TABLE name This form sets the per-column statistics-gathering target for subsequent - operations. + 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 (). @@ -167,7 +167,7 @@ ALTER TABLE name define attribute-level options are n_distinct and n_distinct_inherited, which override the number-of-distinct-values estimate made by subsequent - + operations. n_distinct affects the statistics for the table itself, while n_distinct_inherited affects the statistics gathered for the table and its inheritance children. When set to a @@ -223,7 +223,7 @@ ALTER TABLE name This form adds a new constraint to a table using the same syntax as - . + . @@ -284,7 +284,7 @@ ALTER TABLE name This form selects the default index for future - + operations. It does not actually re-cluster the table. @@ -295,7 +295,7 @@ ALTER TABLE name This form removes the most recently used - + index specification from the table. This affects future cluster operations that don't specify an index. @@ -338,12 +338,12 @@ ALTER TABLE name This form changes one or more storage parameters for the table. See + 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 or one of the forms of ALTER + That can be done with + or one of the forms of ALTER TABLE that forces a table rewrite. @@ -426,7 +426,7 @@ ALTER TABLE name Indexes on the table, if any, are not moved; but they can be moved separately with additional SET TABLESPACE commands. See also - . + . @@ -774,8 +774,7 @@ ALTER TABLE table ALTER COLUMN anycol TYPE anytype; - Refer to for a further description of valid + Refer to for a further description of valid parameters. has further information on inheritance. diff --git a/doc/src/sgml/ref/alter_tablespace.sgml b/doc/src/sgml/ref/alter_tablespace.sgml index 758ee13aa69..d778992bae0 100644 --- a/doc/src/sgml/ref/alter_tablespace.sgml +++ b/doc/src/sgml/ref/alter_tablespace.sgml @@ -1,11 +1,11 @@ - ALTER TABLESPACE + ALTER TABLESPACE 7 SQL - Language Statements @@ -128,8 +128,8 @@ ALTER TABLESPACE index_space OWNER TO mary; See Also - - + + diff --git a/doc/src/sgml/ref/alter_trigger.sgml b/doc/src/sgml/ref/alter_trigger.sgml index 6406595c549..1e508d2401d 100644 --- a/doc/src/sgml/ref/alter_trigger.sgml +++ b/doc/src/sgml/ref/alter_trigger.sgml @@ -1,11 +1,11 @@ - ALTER TRIGGER + ALTER TRIGGER 7 SQL - Language Statements @@ -78,7 +78,7 @@ ALTER TRIGGER name ON The ability to temporarily enable or disable a trigger is provided by - , not by + , not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once. @@ -109,7 +109,7 @@ ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs; See Also - + diff --git a/doc/src/sgml/ref/alter_tsconfig.sgml b/doc/src/sgml/ref/alter_tsconfig.sgml index cf31eab5aca..7f70ca9e020 100644 --- a/doc/src/sgml/ref/alter_tsconfig.sgml +++ b/doc/src/sgml/ref/alter_tsconfig.sgml @@ -1,11 +1,11 @@ - ALTER TEXT SEARCH CONFIGURATION + ALTER TEXT SEARCH CONFIGURATION 7 SQL - Language Statements @@ -172,8 +172,8 @@ ALTER TEXT SEARCH CONFIGURATION my_config See Also - - + + diff --git a/doc/src/sgml/ref/alter_tsdictionary.sgml b/doc/src/sgml/ref/alter_tsdictionary.sgml index 7c55f5f993e..458e4c48f5e 100644 --- a/doc/src/sgml/ref/alter_tsdictionary.sgml +++ b/doc/src/sgml/ref/alter_tsdictionary.sgml @@ -1,11 +1,11 @@ - ALTER TEXT SEARCH DICTIONARY + ALTER TEXT SEARCH DICTIONARY 7 SQL - Language Statements @@ -153,8 +153,8 @@ ALTER TEXT SEARCH DICTIONARY my_dict ( dummy ); See Also - - + + diff --git a/doc/src/sgml/ref/alter_tsparser.sgml b/doc/src/sgml/ref/alter_tsparser.sgml index a47e893c2e0..eed1b58e8a6 100644 --- a/doc/src/sgml/ref/alter_tsparser.sgml +++ b/doc/src/sgml/ref/alter_tsparser.sgml @@ -1,11 +1,11 @@ - ALTER TEXT SEARCH PARSER + ALTER TEXT SEARCH PARSER 7 SQL - Language Statements @@ -76,8 +76,8 @@ ALTER TEXT SEARCH PARSER name RENAME TO See Also - - + + diff --git a/doc/src/sgml/ref/alter_tstemplate.sgml b/doc/src/sgml/ref/alter_tstemplate.sgml index 16c76339fd3..cb4b97b0301 100644 --- a/doc/src/sgml/ref/alter_tstemplate.sgml +++ b/doc/src/sgml/ref/alter_tstemplate.sgml @@ -1,11 +1,11 @@ - ALTER TEXT SEARCH TEMPLATE + ALTER TEXT SEARCH TEMPLATE 7 SQL - Language Statements @@ -76,8 +76,8 @@ ALTER TEXT SEARCH TEMPLATE name RENAME TO See Also - - + + diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml index 71c922a4e11..92e90a039be 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -1,11 +1,11 @@ - ALTER TYPE + ALTER TYPE 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 3d22e75050b..6046155be42 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -1,11 +1,11 @@ - ALTER USER + ALTER USER 7 SQL - Language Statements @@ -49,7 +49,7 @@ ALTER USER name RESET ALL ALTER USER is now an alias for - . + . @@ -67,7 +67,7 @@ ALTER USER name RESET ALL See Also - + diff --git a/doc/src/sgml/ref/alter_user_mapping.sgml b/doc/src/sgml/ref/alter_user_mapping.sgml index c98ea7709fa..99e489e49c4 100644 --- a/doc/src/sgml/ref/alter_user_mapping.sgml +++ b/doc/src/sgml/ref/alter_user_mapping.sgml @@ -1,11 +1,11 @@ - ALTER USER MAPPING + ALTER USER MAPPING 7 SQL - Language Statements @@ -117,8 +117,8 @@ ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public'); See Also - - + + diff --git a/doc/src/sgml/ref/alter_view.sgml b/doc/src/sgml/ref/alter_view.sgml index da5a1ea3754..6f175c97b95 100644 --- a/doc/src/sgml/ref/alter_view.sgml +++ b/doc/src/sgml/ref/alter_view.sgml @@ -1,11 +1,11 @@ - ALTER VIEW + ALTER VIEW 7 SQL - Language Statements @@ -140,8 +140,8 @@ ALTER VIEW foo RENAME TO bar; See Also - - + + diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 7564ce1448e..1f2e4c1bad7 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -1,11 +1,11 @@ - ANALYZE + ANALYZE 7 SQL - Language Statements @@ -102,7 +102,7 @@ ANALYZE [ VERBOSE ] [ table [ ( + strategy is to run and ANALYZE once a day during a low-usage time of day. @@ -132,7 +132,7 @@ ANALYZE [ VERBOSE ] [ table [ ( ANALYZE 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 - . + . In rare situations, this non-determinism will cause the planner's choices of query plans to change after ANALYZE is run. To avoid this, raise the amount of statistics collected by @@ -144,8 +144,8 @@ ANALYZE [ VERBOSE ] [ table [ ( configuration variable, or on a column-by-column basis by setting the per-column statistics target with ALTER TABLE ... ALTER COLUMN ... SET - STATISTICS (see ). The target value sets the + STATISTICS (see ). + 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 is 100, but this can be adjusted up or down to trade off accuracy of @@ -174,7 +174,7 @@ ANALYZE [ VERBOSE ] [ table [ ( ALTER TABLE ... ALTER COLUMN ... SET (n_distinct = ...) - (see ). + (see ). @@ -190,10 +190,10 @@ ANALYZE [ VERBOSE ] [ table [ ( See Also - - - - + + + + diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index 9b05454636f..67dd49cd1ba 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -1,11 +1,11 @@ - BEGIN + BEGIN 7 SQL - Language Statements @@ -37,8 +37,8 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_modeBEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an explicit or is given. + linkend="sql-commit"> or is given. By default (without BEGIN), PostgreSQL executes transactions in autocommit mode, that is, each @@ -59,7 +59,7 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_mode If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if - + was executed. @@ -80,8 +80,7 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_mode - Refer to for information on the meaning + Refer to for information on the meaning of the other parameters to this statement. @@ -90,14 +89,13 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_modeNotes - has the same functionality + has the same functionality as BEGIN. - Use or - + Use or + to terminate a transaction block. @@ -105,7 +103,7 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_modeBEGIN when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. To nest transactions within a transaction block, use savepoints - (see ). + (see ). @@ -133,8 +131,7 @@ BEGIN; BEGIN is a PostgreSQL language extension. It is equivalent to the SQL-standard command - , whose reference page + , whose reference page contains additional compatibility information. @@ -149,10 +146,10 @@ BEGIN; See Also - - - - + + + + diff --git a/doc/src/sgml/ref/checkpoint.sgml b/doc/src/sgml/ref/checkpoint.sgml index 31f1b0fe192..17252104498 100644 --- a/doc/src/sgml/ref/checkpoint.sgml +++ b/doc/src/sgml/ref/checkpoint.sgml @@ -1,8 +1,8 @@ - + - CHECKPOINT + CHECKPOINT 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/close.sgml b/doc/src/sgml/ref/close.sgml index 59b1b1b3184..a36bbf8583b 100644 --- a/doc/src/sgml/ref/close.sgml +++ b/doc/src/sgml/ref/close.sgml @@ -1,11 +1,11 @@ - CLOSE + CLOSE 7 SQL - Language Statements @@ -84,7 +84,7 @@ CLOSE { name | ALL } PostgreSQL does not have an explicit OPEN cursor statement; a cursor is considered open when it is declared. Use the - + statement to declare a cursor. @@ -125,9 +125,9 @@ CLOSE liahona; See Also - - - + + + diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index 4c690d9eda6..2f06251b292 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -1,11 +1,11 @@ - CLUSTER + CLUSTER 7 SQL - Language Statements @@ -141,8 +141,8 @@ CLUSTER [VERBOSE] Because the planner records statistics about the ordering of - tables, it is advisable to run on the newly clustered table. + tables, it is advisable to run + on the newly clustered table. Otherwise, the planner might make poor choices of query plans. @@ -226,7 +226,7 @@ CLUSTER index_name ON See Also - + diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index c805cddae69..f9b4c7a8c08 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -1,11 +1,11 @@ - clusterdb + clusterdb 1 Application @@ -48,7 +48,7 @@ PostgreSQL documentation clusterdb is a wrapper around the SQL - command . + command . There is no effective difference between clustering databases via this utility and via other methods for accessing the server. @@ -263,8 +263,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -300,7 +300,7 @@ PostgreSQL documentation See Also - + diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index 730ad7cf82c..53c6b0fcbc9 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -1,11 +1,11 @@ - COMMENT + COMMENT 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 1d676ed739b..6cc7af5e07e 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -1,11 +1,11 @@ - COMMIT + COMMIT 7 SQL - Language Statements @@ -55,7 +55,7 @@ COMMIT [ WORK | TRANSACTION ] Notes - Use to + Use to abort a transaction. @@ -90,8 +90,8 @@ COMMIT; See Also - - + + diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index 1406ed292a4..2c9b558d610 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -1,11 +1,11 @@ - COMMIT PREPARED + COMMIT PREPARED 7 SQL - Language Statements @@ -88,8 +88,8 @@ COMMIT PREPARED 'foobar'; See Also - - + + diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index d630e6a2fa6..f29a2f093bf 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -1,12 +1,12 @@ - COPY + COPY 7 SQL - Language Statements @@ -103,8 +103,8 @@ COPY { table_name [ ( query - A or - command + A or + command whose results are to be copied. Note that parentheses are required around the query. diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index 1d0599756c3..2eae2090cc6 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -1,11 +1,11 @@ - CREATE AGGREGATE + CREATE AGGREGATE 7 SQL - Language Statements @@ -304,8 +304,8 @@ SELECT col FROM tab ORDER BY col USING sortop LIMIT 1; See Also - - + + diff --git a/doc/src/sgml/ref/create_cast.sgml b/doc/src/sgml/ref/create_cast.sgml index 16a7cef40f9..317cdb64f89 100644 --- a/doc/src/sgml/ref/create_cast.sgml +++ b/doc/src/sgml/ref/create_cast.sgml @@ -1,8 +1,8 @@ - + - CREATE CAST + CREATE CAST 7 SQL - Language Statements @@ -150,7 +150,7 @@ SELECT CAST ( 2 AS numeric ) + 4.0; ambiguity that cannot be avoided as above. The parser has a fallback heuristic based on type categories and preferred types that can help to provide desired behavior in such cases. See - for + for more information. @@ -290,8 +290,7 @@ SELECT CAST ( 2 AS numeric ) + 4.0; Notes - Use to remove user-defined casts. + Use to remove user-defined casts. @@ -401,9 +400,9 @@ CREATE CAST (bigint AS int4) WITH FUNCTION int4(bigint) AS ASSIGNMENT; See Also - , - , - + , + , + diff --git a/doc/src/sgml/ref/create_constraint.sgml b/doc/src/sgml/ref/create_constraint.sgml index 7da88318568..779f427c572 100644 --- a/doc/src/sgml/ref/create_constraint.sgml +++ b/doc/src/sgml/ref/create_constraint.sgml @@ -1,11 +1,11 @@ - CREATE CONSTRAINT TRIGGER + CREATE CONSTRAINT TRIGGER 7 SQL - Language Statements @@ -39,7 +39,7 @@ CREATE CONSTRAINT TRIGGER name CREATE CONSTRAINT TRIGGER creates a constraint trigger. This is the same as a regular trigger except that the timing of the trigger firing can be adjusted using - . + . Constraint triggers must be AFTER ROW triggers. They can be fired either at the end of the statement causing the triggering event, or at the end of the containing transaction; in the latter case they are @@ -104,7 +104,7 @@ CREATE CONSTRAINT TRIGGER name The default timing of the trigger. - See the + See the documentation for details of these constraint options. @@ -116,7 +116,7 @@ CREATE CONSTRAINT TRIGGER name A Boolean expression that determines whether the trigger function will actually be executed. This acts the same as in . + linkend="SQL-CREATETRIGGER">. Note in particular that evaluation of the WHEN condition is not deferred, but occurs immediately after the row update operation is performed. If the condition does not evaluate @@ -131,7 +131,7 @@ CREATE CONSTRAINT TRIGGER name The function to call when the trigger is fired. See for + linkend="SQL-CREATETRIGGER"> for details. @@ -142,7 +142,7 @@ CREATE CONSTRAINT TRIGGER name Optional argument strings to pass to the trigger function. See for + linkend="SQL-CREATETRIGGER"> for details. @@ -163,9 +163,9 @@ CREATE CONSTRAINT TRIGGER name See Also - - - + + + diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 9a8cee7de19..108c6fb6aea 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,8 +1,8 @@ - + - CREATE CONVERSION + CREATE CONVERSION 7 SQL - Language Statements @@ -162,9 +162,9 @@ CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc; See Also - - - + + + diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index ff4c74e4732..c3e691a4ad3 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -1,11 +1,11 @@ - CREATE DATABASE + CREATE DATABASE 7 SQL - Language Statements @@ -43,7 +43,7 @@ CREATE DATABASE name To create a database, you must be a superuser or have the special CREATEDB privilege. - See . + See . @@ -147,7 +147,7 @@ CREATE DATABASE name template database's tablespace. This tablespace will be the default tablespace used for objects created in this database. See - + for more information. @@ -185,11 +185,11 @@ CREATE DATABASE name - Use to remove a database. + Use to remove a database. - The program is a + The program is a wrapper program around this command, provided for convenience. @@ -287,8 +287,8 @@ CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0; See Also - - + + diff --git a/doc/src/sgml/ref/create_domain.sgml b/doc/src/sgml/ref/create_domain.sgml index aae7a3539c3..637326b58bb 100644 --- a/doc/src/sgml/ref/create_domain.sgml +++ b/doc/src/sgml/ref/create_domain.sgml @@ -1,11 +1,11 @@ - CREATE DOMAIN + CREATE DOMAIN 7 SQL - Language Statements @@ -201,8 +201,8 @@ CREATE TABLE us_snail_addy ( See Also - - + + diff --git a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml index b9ceb7ecc17..4880588b15e 100644 --- a/doc/src/sgml/ref/create_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/create_foreign_data_wrapper.sgml @@ -1,11 +1,11 @@ - CREATE FOREIGN DATA WRAPPER + CREATE FOREIGN DATA WRAPPER 7 SQL - Language Statements @@ -167,10 +167,10 @@ CREATE FOREIGN DATA WRAPPER mywrapper See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 8e3741fa31c..06df45ab967 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,10 +1,10 @@ - CREATE FUNCTION + CREATE FUNCTION 7 SQL - Language Statements @@ -423,7 +423,7 @@ CREATE [ OR REPLACE ] FUNCTION - See and + See and for more information about allowed parameter names and values. @@ -702,7 +702,7 @@ $$ LANGUAGE plpgsql Another point to keep in mind is that by default, execute privilege is granted to PUBLIC for newly created functions - (see for more + (see for more information). Frequently you will wish to restrict use of a security definer function to only some users. To do that, you must revoke the default PUBLIC privileges and then grant execute @@ -752,12 +752,12 @@ COMMIT; See Also - - - - - - + + + + + + diff --git a/doc/src/sgml/ref/create_group.sgml b/doc/src/sgml/ref/create_group.sgml index 80ba1f49af3..996bc15042e 100644 --- a/doc/src/sgml/ref/create_group.sgml +++ b/doc/src/sgml/ref/create_group.sgml @@ -1,11 +1,11 @@ - CREATE GROUP + CREATE GROUP 7 SQL - Language Statements @@ -47,7 +47,7 @@ CREATE GROUP name [ [ WITH ] CREATE GROUP is now an alias for - . + . @@ -64,7 +64,7 @@ CREATE GROUP name [ [ WITH ] See Also - + diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index ec1807a370b..5b68cae10f2 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,11 +1,11 @@ - CREATE INDEX + CREATE INDEX 7 SQL - Language Statements @@ -488,7 +488,7 @@ Indexes: - Use + Use to remove an index. @@ -588,8 +588,8 @@ CREATE INDEX CONCURRENTLY sales_quantity_index ON sales_table (quantity); See Also - - + + diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 3f52578634e..679f8d50b15 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,11 +1,11 @@ - CREATE LANGUAGE + CREATE LANGUAGE 7 SQL - Language Statements @@ -168,7 +168,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE inline_handler is the name of a previously registered function that will be called to execute an anonymous code block - ( command) + ( command) in this language. If no inline_handler function is specified, the language does not support anonymous code @@ -227,7 +227,7 @@ CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE , or better yet the , or better yet the program, to drop procedural languages. @@ -312,13 +312,13 @@ CREATE LANGUAGE plsample See Also - - - - - - - + + + + + + + diff --git a/doc/src/sgml/ref/create_opclass.sgml b/doc/src/sgml/ref/create_opclass.sgml index 44e1f1f21fd..500a16b6588 100644 --- a/doc/src/sgml/ref/create_opclass.sgml +++ b/doc/src/sgml/ref/create_opclass.sgml @@ -1,11 +1,11 @@ - CREATE OPERATOR CLASS + CREATE OPERATOR CLASS 7 SQL - Language Statements @@ -297,10 +297,10 @@ CREATE OPERATOR CLASS gist__int_ops See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml index 7c0b545e894..a5595e6e69c 100644 --- a/doc/src/sgml/ref/create_operator.sgml +++ b/doc/src/sgml/ref/create_operator.sgml @@ -1,11 +1,11 @@ - CREATE OPERATOR + CREATE OPERATOR 7 SQL - Language Statements @@ -231,10 +231,8 @@ COMMUTATOR = OPERATOR(myschema.===) , - Use to delete user-defined operators - from a database. Use to modify operators in a + Use to delete user-defined operators + from a database. Use to modify operators in a database. @@ -274,9 +272,9 @@ CREATE OPERATOR === ( See Also - - - + + + diff --git a/doc/src/sgml/ref/create_opfamily.sgml b/doc/src/sgml/ref/create_opfamily.sgml index 958de632bb3..4b1a3ee2a72 100644 --- a/doc/src/sgml/ref/create_opfamily.sgml +++ b/doc/src/sgml/ref/create_opfamily.sgml @@ -1,11 +1,11 @@ - CREATE OPERATOR FAMILY + CREATE OPERATOR FAMILY 7 SQL - Language Statements @@ -108,11 +108,11 @@ CREATE OPERATOR FAMILY name USING < See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index 60e7d7c862d..a1c7ad61c21 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -1,11 +1,11 @@ - CREATE ROLE + CREATE ROLE 7 SQL - Language Statements @@ -307,9 +307,9 @@ CREATE ROLE name [ [ WITH ] Notes - Use to - change the attributes of a role, and to remove a role. All the attributes + Use to + change the attributes of a role, and + to remove a role. All the attributes specified by CREATE ROLE can be modified by later ALTER ROLE commands. @@ -317,8 +317,8 @@ CREATE ROLE name [ [ WITH ] The preferred way to add and remove members of roles that are being used as groups is to use - and - . + and + . @@ -336,7 +336,7 @@ CREATE ROLE name [ [ WITH ] CREATEDB privilege does not immediately grant the ability to create databases, even if INHERIT is set; it would be necessary to become that role via - before + before creating a database. @@ -363,7 +363,7 @@ CREATE ROLE name [ [ WITH ] PostgreSQL includes a program that has + linkend="APP-CREATEUSER"> that has the same functionality as CREATE ROLE (in fact, it calls this command) but can be run from the command shell. @@ -380,9 +380,9 @@ CREATE ROLE name [ [ WITH ] , however, transmits - the password encrypted. Also, contains a command + linkend="APP-CREATEUSER">, however, transmits + the password encrypted. Also, + contains a command \password that can be used to safely change the password later. @@ -459,11 +459,11 @@ CREATE ROLE name [ WITH ADMIN See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index 15eee45e4e5..afe5f82e1c6 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -1,11 +1,11 @@ - CREATE RULE + CREATE RULE 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/create_schema.sgml b/doc/src/sgml/ref/create_schema.sgml index b92fa0f93f4..0df736877f7 100644 --- a/doc/src/sgml/ref/create_schema.sgml +++ b/doc/src/sgml/ref/create_schema.sgml @@ -1,11 +1,11 @@ - CREATE SCHEMA + CREATE SCHEMA 7 SQL - Language Statements @@ -184,8 +184,8 @@ CREATE VIEW hollywood.winners AS See Also - - + + diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 20b0c008721..318718e1a89 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -1,11 +1,11 @@ - CREATE SEQUENCE + CREATE SEQUENCE 7 SQL - Language Statements @@ -356,8 +356,8 @@ END; See Also - - + + diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml index 06c20ea87fc..319f1f6fe26 100644 --- a/doc/src/sgml/ref/create_server.sgml +++ b/doc/src/sgml/ref/create_server.sgml @@ -1,11 +1,11 @@ - CREATE SERVER + CREATE SERVER 7 SQL - Language Statements @@ -152,10 +152,10 @@ CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'f See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index d905f081afd..a730e3b9306 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,11 +1,11 @@ - CREATE TABLE + CREATE TABLE 7 SQL - Language Statements @@ -484,7 +484,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE exclude_element can optionally specify an operator class and/or ordering options; these are described fully under - . + . @@ -630,7 +630,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE command). + (using the command). NOT DEFERRABLE is the default. Currently, only UNIQUE, PRIMARY KEY, EXCLUDE, and @@ -652,7 +652,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE command. + altered with the command. @@ -690,7 +690,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE . + linkend="sql-altertable">. @@ -733,7 +733,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE is done + linkend="sql-truncate"> is done at each commit. @@ -794,8 +794,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE . The storage parameters currently + indexes are documented in . The storage parameters currently available for tables are listed below. For each parameter, unless noted, there is an additional, identically named parameter, prefixed with toast. which can be used to control the behavior of the @@ -978,7 +977,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE for more information.) + linkend="sql-createindex"> for more information.) @@ -1380,10 +1379,10 @@ CREATE TABLE employees OF employee_type ( See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index b31a25704f8..1b597225865 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,11 +1,11 @@ - CREATE TABLE AS + CREATE TABLE AS 7 SQL - Language Statements @@ -63,7 +63,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name Ignored for compatibility. Refer to for + linkend="sql-createtable"> for details. @@ -76,7 +76,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name If specified, the table is created as a temporary table. - Refer to for details. + Refer to for details. @@ -115,8 +115,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name to specify that rows of the new table should have OIDs (object identifiers) assigned to them, or OIDS=FALSE to specify that the rows should not have OIDs. - See for more information. + See for more information. @@ -159,7 +158,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name All rows in the temporary table will be deleted at the end of each transaction block. Essentially, an automatic is done + linkend="sql-truncate"> is done at each commit. @@ -197,10 +196,10 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name A , TABLE, + >, TABLE, or - command, - or an command + command, + or an command that runs a prepared SELECT, TABLE, or VALUES query. @@ -225,7 +224,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name This command is functionally similar to , but it is + linkend="sql-selectinto">, but it is preferred since it is less likely to be confused with other uses of the SELECT INTO syntax. Furthermore, CREATE TABLE AS offers a superset of the functionality offered @@ -313,7 +312,7 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS PostgreSQL handles temporary tables in a way rather different from the standard; see - + for details. @@ -340,11 +339,11 @@ CREATE TEMP TABLE films_recent WITH (OIDS) ON COMMIT DROP AS See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/create_tablespace.sgml b/doc/src/sgml/ref/create_tablespace.sgml index 4e1ae9571c3..8b212361fb8 100644 --- a/doc/src/sgml/ref/create_tablespace.sgml +++ b/doc/src/sgml/ref/create_tablespace.sgml @@ -1,11 +1,11 @@ - CREATE TABLESPACE + CREATE TABLESPACE 7 SQL - Language Statements @@ -135,11 +135,11 @@ CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes'; See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index 78f5977999b..6ec2766fa49 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -1,11 +1,11 @@ - CREATE TRIGGER + CREATE TRIGGER 7 SQL - Language Statements @@ -233,8 +233,7 @@ UPDATE OF column_name1 [, column_name2 - Use to remove a trigger. + Use to remove a trigger. @@ -406,9 +405,9 @@ CREATE TRIGGER log_update See Also - - - + + + diff --git a/doc/src/sgml/ref/create_tsconfig.sgml b/doc/src/sgml/ref/create_tsconfig.sgml index b8c2b723be9..64d6eedc990 100644 --- a/doc/src/sgml/ref/create_tsconfig.sgml +++ b/doc/src/sgml/ref/create_tsconfig.sgml @@ -1,11 +1,11 @@ - CREATE TEXT SEARCH CONFIGURATION + CREATE TEXT SEARCH CONFIGURATION 7 SQL - Language Statements @@ -119,8 +119,8 @@ CREATE TEXT SEARCH CONFIGURATION nameSee Also - - + + diff --git a/doc/src/sgml/ref/create_tsdictionary.sgml b/doc/src/sgml/ref/create_tsdictionary.sgml index a75904debf6..5da02490ddb 100644 --- a/doc/src/sgml/ref/create_tsdictionary.sgml +++ b/doc/src/sgml/ref/create_tsdictionary.sgml @@ -1,11 +1,11 @@ - CREATE TEXT SEARCH DICTIONARY + CREATE TEXT SEARCH DICTIONARY 7 SQL - Language Statements @@ -134,8 +134,8 @@ CREATE TEXT SEARCH DICTIONARY my_russian ( See Also - - + + diff --git a/doc/src/sgml/ref/create_tsparser.sgml b/doc/src/sgml/ref/create_tsparser.sgml index 46a1919e7d0..c04b636993f 100644 --- a/doc/src/sgml/ref/create_tsparser.sgml +++ b/doc/src/sgml/ref/create_tsparser.sgml @@ -1,11 +1,11 @@ - CREATE TEXT SEARCH PARSER + CREATE TEXT SEARCH PARSER 7 SQL - Language Statements @@ -146,8 +146,8 @@ CREATE TEXT SEARCH PARSER name ( See Also - - + + diff --git a/doc/src/sgml/ref/create_tstemplate.sgml b/doc/src/sgml/ref/create_tstemplate.sgml index 281e25468e4..84b61c8a874 100644 --- a/doc/src/sgml/ref/create_tstemplate.sgml +++ b/doc/src/sgml/ref/create_tstemplate.sgml @@ -1,11 +1,11 @@ - CREATE TEXT SEARCH TEMPLATE + CREATE TEXT SEARCH TEMPLATE 7 SQL - Language Statements @@ -119,8 +119,8 @@ CREATE TEXT SEARCH TEMPLATE name ( See Also - - + + diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index c2a77ac88d3..319410e31cb 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -1,11 +1,11 @@ - CREATE TYPE + CREATE TYPE 7 SQL - Language Statements @@ -779,10 +779,10 @@ CREATE TABLE big_objs ( See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_user.sgml b/doc/src/sgml/ref/create_user.sgml index 5b155823ff8..a54ece612b0 100644 --- a/doc/src/sgml/ref/create_user.sgml +++ b/doc/src/sgml/ref/create_user.sgml @@ -1,11 +1,11 @@ - CREATE USER + CREATE USER 7 SQL - Language Statements @@ -48,7 +48,7 @@ CREATE USER name [ [ WITH ] CREATE USER is now an alias for - . + . The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when @@ -71,7 +71,7 @@ CREATE USER name [ [ WITH ] See Also - + diff --git a/doc/src/sgml/ref/create_user_mapping.sgml b/doc/src/sgml/ref/create_user_mapping.sgml index f1113907f4d..471a19f1c58 100644 --- a/doc/src/sgml/ref/create_user_mapping.sgml +++ b/doc/src/sgml/ref/create_user_mapping.sgml @@ -1,11 +1,11 @@ - CREATE USER MAPPING + CREATE USER MAPPING 7 SQL - Language Statements @@ -111,10 +111,10 @@ CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret'); See Also - - - - + + + + diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index f65e06c84c9..d80daa9807b 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -1,11 +1,11 @@ - CREATE VIEW + CREATE VIEW 7 SQL - Language Statements @@ -102,8 +102,8 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW n query - A or - command + A or + command which will provide the columns and rows of the view. @@ -119,11 +119,11 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW n update, or delete on a view. You can get the effect of an updatable view by creating rules that rewrite inserts, etc. on the view into appropriate actions on other tables. For more information see - . + . - Use the + Use the statement to drop views. @@ -237,8 +237,8 @@ CREATE VIEW name [ ( See Also - - + + diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index 1e7ecf4de85..3f4ee6487ad 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -1,11 +1,11 @@ - createdb + createdb 1 Application @@ -48,8 +48,7 @@ PostgreSQL documentation createdb is a wrapper around the - SQL command . + SQL command . There is no effective difference between creating databases via this utility and via other methods for accessing the server. @@ -197,8 +196,7 @@ PostgreSQL documentation The options , , , , and correspond to options of the underlying - SQL command ; see there for more information + SQL command ; see there for more information about them. @@ -323,8 +321,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -364,7 +362,7 @@ PostgreSQL documentation - + diff --git a/doc/src/sgml/ref/createlang.sgml b/doc/src/sgml/ref/createlang.sgml index 30bd5286809..eef50e2e465 100644 --- a/doc/src/sgml/ref/createlang.sgml +++ b/doc/src/sgml/ref/createlang.sgml @@ -1,11 +1,11 @@ - createlang + createlang 1 Application @@ -41,7 +41,7 @@ PostgreSQL documentation createlang is a utility for adding a new programming language to a PostgreSQL database. createlang is just a wrapper around the - + command. @@ -271,7 +271,7 @@ PostgreSQL documentation - + diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml index 41e0bafd88b..043b490f5d3 100644 --- a/doc/src/sgml/ref/createuser.sgml +++ b/doc/src/sgml/ref/createuser.sgml @@ -1,11 +1,11 @@ - createuser + createuser 1 Application @@ -49,8 +49,7 @@ PostgreSQL documentation createuser is a wrapper around the - SQL command . + SQL command . There is no effective difference between creating users via this utility and via other methods for accessing the server. @@ -384,8 +383,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -445,7 +444,7 @@ PostgreSQL documentation - + diff --git a/doc/src/sgml/ref/deallocate.sgml b/doc/src/sgml/ref/deallocate.sgml index e981eb0efca..f6b46d936f8 100644 --- a/doc/src/sgml/ref/deallocate.sgml +++ b/doc/src/sgml/ref/deallocate.sgml @@ -1,11 +1,11 @@ - DEALLOCATE + DEALLOCATE 7 SQL - Language Statements @@ -41,7 +41,7 @@ DEALLOCATE [ PREPARE ] { name | ALL For more information on prepared statements, see . + linkend="sql-prepare">. @@ -91,8 +91,8 @@ DEALLOCATE [ PREPARE ] { name | ALL See Also - - + + diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index e93b4cf594d..8ad39280eed 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -1,11 +1,11 @@ - DECLARE + DECLARE 7 SQL - Language Statements @@ -39,7 +39,7 @@ DECLARE name [ 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 - . + . @@ -126,8 +126,8 @@ DECLARE name [ BINARY ] [ INSENSITI query - A or - command + A or + command which will provide the rows to be returned by the cursor. @@ -185,9 +185,9 @@ DECLARE name [ BINARY ] [ INSENSITI PostgreSQL reports an error if such a command is used outside a transaction block. Use - and - - (or ) + and + + (or ) to define a transaction block. @@ -246,7 +246,7 @@ DECLARE name [ BINARY ] [ INSENSITI If the cursor's query includes FOR UPDATE or FOR SHARE, then returned rows are locked at the time they are first fetched, in the same way as for a regular - command with + 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 @@ -311,7 +311,7 @@ DECLARE name [ BINARY ] [ INSENSITI DECLARE liahona CURSOR FOR SELECT * FROM films; - See for more + See for more examples of cursor usage. @@ -343,9 +343,9 @@ DECLARE liahona CURSOR FOR SELECT * FROM films; See Also - - - + + + diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index 6b175b943bb..84bf6bd23f9 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -1,11 +1,11 @@ - DELETE + DELETE 7 SQL - Language Statements @@ -40,7 +40,7 @@ DELETE FROM [ ONLY ] table [ [ AS ] - is a + is a PostgreSQL extension that provides a faster mechanism to remove all rows from a table. @@ -152,7 +152,7 @@ DELETE FROM [ ONLY ] table [ [ AS ] query on the DELETE's target table. Note that WHERE CURRENT OF cannot be specified together with a Boolean condition. See - + for more information about using cursors with WHERE CURRENT OF. diff --git a/doc/src/sgml/ref/discard.sgml b/doc/src/sgml/ref/discard.sgml index 695cc78902b..d3436a303b3 100644 --- a/doc/src/sgml/ref/discard.sgml +++ b/doc/src/sgml/ref/discard.sgml @@ -1,11 +1,11 @@ - DISCARD + DISCARD 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/do.sgml b/doc/src/sgml/ref/do.sgml index 05678c4e8e7..8b77d13a81c 100644 --- a/doc/src/sgml/ref/do.sgml +++ b/doc/src/sgml/ref/do.sgml @@ -1,11 +1,11 @@ - DO + DO 7 SQL - Language Statements @@ -122,7 +122,7 @@ END$$; See Also - + diff --git a/doc/src/sgml/ref/drop_aggregate.sgml b/doc/src/sgml/ref/drop_aggregate.sgml index cefa3cec8b2..406050e142d 100644 --- a/doc/src/sgml/ref/drop_aggregate.sgml +++ b/doc/src/sgml/ref/drop_aggregate.sgml @@ -1,11 +1,11 @@ - DROP AGGREGATE + DROP AGGREGATE 7 SQL - Language Statements @@ -116,8 +116,8 @@ DROP AGGREGATE myavg(integer); See Also - - + + diff --git a/doc/src/sgml/ref/drop_cast.sgml b/doc/src/sgml/ref/drop_cast.sgml index cc99fe850c7..fde6dc3b034 100644 --- a/doc/src/sgml/ref/drop_cast.sgml +++ b/doc/src/sgml/ref/drop_cast.sgml @@ -1,8 +1,8 @@ - + - DROP CAST + DROP CAST 7 SQL - Language Statements @@ -108,7 +108,7 @@ DROP CAST (text AS int); See Also - + diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index aa8adfeeed1..b80de52f0ac 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -1,8 +1,8 @@ - + - DROP CONVERSION + DROP CONVERSION 7 SQL - Language Statements @@ -94,8 +94,8 @@ DROP CONVERSION myname; See Also - - + + diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index 350f5c026ce..2deb6996cc3 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -1,11 +1,11 @@ - DROP DATABASE + DROP DATABASE 7 SQL - Language Statements @@ -78,7 +78,7 @@ DROP DATABASE [ IF EXISTS ] name This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program - instead, + instead, which is a wrapper around this command. @@ -95,7 +95,7 @@ DROP DATABASE [ IF EXISTS ] name See Also - + diff --git a/doc/src/sgml/ref/drop_domain.sgml b/doc/src/sgml/ref/drop_domain.sgml index a03dc151120..b8e5189bbab 100644 --- a/doc/src/sgml/ref/drop_domain.sgml +++ b/doc/src/sgml/ref/drop_domain.sgml @@ -1,11 +1,11 @@ - DROP DOMAIN + DROP DOMAIN 7 SQL - Language Statements @@ -105,8 +105,8 @@ DROP DOMAIN box; See Also - - + + diff --git a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml index 77da6d39625..f3e8334316b 100644 --- a/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml +++ b/doc/src/sgml/ref/drop_foreign_data_wrapper.sgml @@ -1,11 +1,11 @@ - DROP FOREIGN DATA WRAPPER + DROP FOREIGN DATA WRAPPER 7 SQL - Language Statements @@ -105,8 +105,8 @@ DROP FOREIGN DATA WRAPPER dbi; See Also - - + + diff --git a/doc/src/sgml/ref/drop_function.sgml b/doc/src/sgml/ref/drop_function.sgml index b68858a2a1b..78fe3f7d782 100644 --- a/doc/src/sgml/ref/drop_function.sgml +++ b/doc/src/sgml/ref/drop_function.sgml @@ -1,11 +1,11 @@ - DROP FUNCTION + DROP FUNCTION 7 SQL - Language Statements @@ -149,8 +149,8 @@ DROP FUNCTION sqrt(integer); See Also - - + + diff --git a/doc/src/sgml/ref/drop_group.sgml b/doc/src/sgml/ref/drop_group.sgml index e660eea9817..8899a942970 100644 --- a/doc/src/sgml/ref/drop_group.sgml +++ b/doc/src/sgml/ref/drop_group.sgml @@ -1,11 +1,11 @@ - DROP GROUP + DROP GROUP 7 SQL - Language Statements @@ -30,7 +30,7 @@ DROP GROUP [ IF EXISTS ] name [, .. DROP GROUP is now an alias for - . + . @@ -46,7 +46,7 @@ DROP GROUP [ IF EXISTS ] name [, .. See Also - + diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index e7b9787793f..3e831d3c9ba 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -1,11 +1,11 @@ - DROP INDEX + DROP INDEX 7 SQL - Language Statements @@ -105,7 +105,7 @@ DROP INDEX title_idx; See Also - + diff --git a/doc/src/sgml/ref/drop_language.sgml b/doc/src/sgml/ref/drop_language.sgml index 8b5cd4a4772..5564e00972a 100644 --- a/doc/src/sgml/ref/drop_language.sgml +++ b/doc/src/sgml/ref/drop_language.sgml @@ -1,11 +1,11 @@ - DROP LANGUAGE + DROP LANGUAGE 7 SQL - Language Statements @@ -108,8 +108,8 @@ DROP LANGUAGE plsample; See Also - - + + diff --git a/doc/src/sgml/ref/drop_opclass.sgml b/doc/src/sgml/ref/drop_opclass.sgml index efceb7c5cc1..f1c89cd698a 100644 --- a/doc/src/sgml/ref/drop_opclass.sgml +++ b/doc/src/sgml/ref/drop_opclass.sgml @@ -1,11 +1,11 @@ - DROP OPERATOR CLASS + DROP OPERATOR CLASS 7 SQL - Language Statements @@ -138,9 +138,9 @@ DROP OPERATOR CLASS widget_ops USING btree; See Also - - - + + + diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index 8007d8820d8..0b82cf442b3 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -1,11 +1,11 @@ - DROP OPERATOR + DROP OPERATOR 7 SQL - Language Statements @@ -139,8 +139,8 @@ DROP OPERATOR ! (bigint, none); See Also - - + + diff --git a/doc/src/sgml/ref/drop_opfamily.sgml b/doc/src/sgml/ref/drop_opfamily.sgml index 4ba7a9773c9..5f377b2af2c 100644 --- a/doc/src/sgml/ref/drop_opfamily.sgml +++ b/doc/src/sgml/ref/drop_opfamily.sgml @@ -1,11 +1,11 @@ - DROP OPERATOR FAMILY + DROP OPERATOR FAMILY 7 SQL - Language Statements @@ -125,11 +125,11 @@ DROP OPERATOR FAMILY float_ops USING btree; See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index ced8876b0fc..4d7355925a8 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -1,11 +1,11 @@ - DROP OWNED + DROP OWNED 7 SQL - Language Statements @@ -87,8 +87,7 @@ DROP OWNED BY name [, ...] [ CASCAD - The command is an alternative that + The command is an alternative that reassigns the ownership of all the database objects owned by one or more roles. @@ -111,8 +110,8 @@ DROP OWNED BY name [, ...] [ CASCAD See Also - - + + diff --git a/doc/src/sgml/ref/drop_role.sgml b/doc/src/sgml/ref/drop_role.sgml index d7a5692a732..ffe37b317ef 100644 --- a/doc/src/sgml/ref/drop_role.sgml +++ b/doc/src/sgml/ref/drop_role.sgml @@ -1,11 +1,11 @@ - DROP ROLE + DROP ROLE 7 SQL - Language Statements @@ -40,8 +40,8 @@ DROP ROLE [ IF EXISTS ] name [, ... 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. The - and + linkend="sql-reassign-owned"> + and commands can be useful for this purpose. @@ -83,7 +83,7 @@ DROP ROLE [ IF EXISTS ] name [, ... PostgreSQL includes a program 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. @@ -114,9 +114,9 @@ DROP ROLE jonathan; See Also - - - + + + diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index a902e866361..7a2bb346647 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -1,11 +1,11 @@ - DROP RULE + DROP RULE 7 SQL - Language Statements @@ -112,7 +112,7 @@ DROP RULE newrule ON mytable; See Also - + diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml index e5edf556522..ac108014777 100644 --- a/doc/src/sgml/ref/drop_schema.sgml +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -1,11 +1,11 @@ - DROP SCHEMA + DROP SCHEMA 7 SQL - Language Statements @@ -113,8 +113,8 @@ DROP SCHEMA mystuff CASCADE; See Also - - + + diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index aca302e2931..d6011bd4e76 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -1,11 +1,11 @@ - DROP SEQUENCE + DROP SEQUENCE 7 SQL - Language Statements @@ -106,8 +106,8 @@ DROP SEQUENCE serial; See Also - - + + diff --git a/doc/src/sgml/ref/drop_server.sgml b/doc/src/sgml/ref/drop_server.sgml index 2e79391b11b..d6a939dccf5 100644 --- a/doc/src/sgml/ref/drop_server.sgml +++ b/doc/src/sgml/ref/drop_server.sgml @@ -1,11 +1,11 @@ - DROP SERVER + DROP SERVER 7 SQL - Language Statements @@ -105,8 +105,8 @@ DROP SERVER IF EXISTS foo; See Also - - + + diff --git a/doc/src/sgml/ref/drop_table.sgml b/doc/src/sgml/ref/drop_table.sgml index aead8cd78a7..d75868bdcf1 100644 --- a/doc/src/sgml/ref/drop_table.sgml +++ b/doc/src/sgml/ref/drop_table.sgml @@ -1,11 +1,11 @@ - DROP TABLE + DROP TABLE 7 SQL - Language Statements @@ -31,9 +31,8 @@ DROP TABLE [ IF EXISTS ] name [, .. DROP TABLE removes tables from the database. Only its owner can drop a table. To empty a table of rows - without destroying the table, use or . + without destroying the table, use + or . @@ -120,8 +119,8 @@ DROP TABLE films, distributors; See Also - - + + diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index 0d0f2ea981f..505894506d8 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -1,11 +1,11 @@ - DROP TABLESPACE + DROP TABLESPACE 7 SQL - Language Statements @@ -103,8 +103,8 @@ DROP TABLESPACE mystuff; See Also - - + + diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml index 081e74bf2fd..692c49ace49 100644 --- a/doc/src/sgml/ref/drop_trigger.sgml +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -1,11 +1,11 @@ - DROP TRIGGER + DROP TRIGGER 7 SQL - Language Statements @@ -119,7 +119,7 @@ DROP TRIGGER if_dist_exists ON films; See Also - + diff --git a/doc/src/sgml/ref/drop_tsconfig.sgml b/doc/src/sgml/ref/drop_tsconfig.sgml index e96cecf2f4a..087698c7603 100644 --- a/doc/src/sgml/ref/drop_tsconfig.sgml +++ b/doc/src/sgml/ref/drop_tsconfig.sgml @@ -1,11 +1,11 @@ - DROP TEXT SEARCH CONFIGURATION + DROP TEXT SEARCH CONFIGURATION 7 SQL - Language Statements @@ -111,8 +111,8 @@ DROP TEXT SEARCH CONFIGURATION my_english; See Also - - + + diff --git a/doc/src/sgml/ref/drop_tsdictionary.sgml b/doc/src/sgml/ref/drop_tsdictionary.sgml index c3c8bf40e82..9f8a54e3e3c 100644 --- a/doc/src/sgml/ref/drop_tsdictionary.sgml +++ b/doc/src/sgml/ref/drop_tsdictionary.sgml @@ -1,11 +1,11 @@ - DROP TEXT SEARCH DICTIONARY + DROP TEXT SEARCH DICTIONARY 7 SQL - Language Statements @@ -110,8 +110,8 @@ DROP TEXT SEARCH DICTIONARY english; See Also - - + + diff --git a/doc/src/sgml/ref/drop_tsparser.sgml b/doc/src/sgml/ref/drop_tsparser.sgml index 2936d678dd1..5384a103d56 100644 --- a/doc/src/sgml/ref/drop_tsparser.sgml +++ b/doc/src/sgml/ref/drop_tsparser.sgml @@ -1,11 +1,11 @@ - DROP TEXT SEARCH PARSER + DROP TEXT SEARCH PARSER 7 SQL - Language Statements @@ -108,8 +108,8 @@ DROP TEXT SEARCH PARSER my_parser; See Also - - + + diff --git a/doc/src/sgml/ref/drop_tstemplate.sgml b/doc/src/sgml/ref/drop_tstemplate.sgml index 48b19a6849b..f0876a72c92 100644 --- a/doc/src/sgml/ref/drop_tstemplate.sgml +++ b/doc/src/sgml/ref/drop_tstemplate.sgml @@ -1,11 +1,11 @@ - DROP TEXT SEARCH TEMPLATE + DROP TEXT SEARCH TEMPLATE 7 SQL - Language Statements @@ -109,8 +109,8 @@ DROP TEXT SEARCH TEMPLATE thesaurus; See Also - - + + diff --git a/doc/src/sgml/ref/drop_type.sgml b/doc/src/sgml/ref/drop_type.sgml index ea26507423b..5b320360c14 100644 --- a/doc/src/sgml/ref/drop_type.sgml +++ b/doc/src/sgml/ref/drop_type.sgml @@ -1,11 +1,11 @@ - DROP TYPE + DROP TYPE 7 SQL - Language Statements @@ -107,8 +107,8 @@ DROP TYPE box; See Also - - + + diff --git a/doc/src/sgml/ref/drop_user.sgml b/doc/src/sgml/ref/drop_user.sgml index e523a48a208..bcd410a4b07 100644 --- a/doc/src/sgml/ref/drop_user.sgml +++ b/doc/src/sgml/ref/drop_user.sgml @@ -1,11 +1,11 @@ - DROP USER + DROP USER 7 SQL - Language Statements @@ -30,7 +30,7 @@ DROP USER [ IF EXISTS ] name [, ... DROP USER is now an alias for - . + . @@ -48,7 +48,7 @@ DROP USER [ IF EXISTS ] name [, ... See Also - + diff --git a/doc/src/sgml/ref/drop_user_mapping.sgml b/doc/src/sgml/ref/drop_user_mapping.sgml index 8e8ed1d1035..41dbd7b49d5 100644 --- a/doc/src/sgml/ref/drop_user_mapping.sgml +++ b/doc/src/sgml/ref/drop_user_mapping.sgml @@ -1,11 +1,11 @@ - DROP USER MAPPING + DROP USER MAPPING 7 SQL - Language Statements @@ -103,8 +103,8 @@ DROP USER MAPPING IF EXISTS FOR bob SERVER foo; See Also - - + + diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index ac03f059b52..9718ee5d9cf 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -1,11 +1,11 @@ - DROP VIEW + DROP VIEW 7 SQL - Language Statements @@ -105,8 +105,8 @@ DROP VIEW kinds; See Also - - + + diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml index 76e0190238f..40b0864338b 100644 --- a/doc/src/sgml/ref/dropdb.sgml +++ b/doc/src/sgml/ref/dropdb.sgml @@ -1,11 +1,11 @@ - dropdb + dropdb 1 Application @@ -41,8 +41,7 @@ PostgreSQL documentation dropdb is a wrapper around the - SQL command . + SQL command . There is no effective difference between dropping databases via this utility and via other methods for accessing the server. @@ -222,8 +221,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -264,7 +263,7 @@ Are you sure? (y/n) y - + diff --git a/doc/src/sgml/ref/droplang.sgml b/doc/src/sgml/ref/droplang.sgml index 6dd5847b86e..f455b564319 100644 --- a/doc/src/sgml/ref/droplang.sgml +++ b/doc/src/sgml/ref/droplang.sgml @@ -1,11 +1,11 @@ - droplang + droplang 1 Application @@ -50,7 +50,7 @@ PostgreSQL documentation several SQL commands, it is recommended to use droplang because it performs a number of checks and is much easier to use. See - + for more. @@ -275,7 +275,7 @@ PostgreSQL documentation - + diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index 31a6f0009c1..4dc5e43b7d6 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -1,11 +1,11 @@ - dropuser + dropuser 1 Application @@ -42,8 +42,7 @@ PostgreSQL documentation dropuser is a wrapper around the - SQL command . + SQL command . There is no effective difference between dropping users via this utility and via other methods for accessing the server. @@ -223,8 +222,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -265,7 +264,7 @@ Are you sure? (y/n) y - + diff --git a/doc/src/sgml/ref/end.sgml b/doc/src/sgml/ref/end.sgml index a436fb47c55..267f9b9f0ce 100644 --- a/doc/src/sgml/ref/end.sgml +++ b/doc/src/sgml/ref/end.sgml @@ -1,11 +1,11 @@ - END + END 7 SQL - Language Statements @@ -33,8 +33,7 @@ END [ WORK | TRANSACTION ] made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension - that is equivalent to . + that is equivalent to . @@ -58,7 +57,7 @@ END [ WORK | TRANSACTION ] Notes - Use to + Use to abort a transaction. @@ -85,7 +84,7 @@ END; END is a PostgreSQL extension that provides functionality equivalent to , which is + linkend="sql-commit">, which is specified in the SQL standard. @@ -94,9 +93,9 @@ END; See Also - - - + + + diff --git a/doc/src/sgml/ref/execute.sgml b/doc/src/sgml/ref/execute.sgml index 640763a7435..8d8989c9ca9 100644 --- a/doc/src/sgml/ref/execute.sgml +++ b/doc/src/sgml/ref/execute.sgml @@ -1,11 +1,11 @@ - EXECUTE + EXECUTE 7 SQL - Language Statements @@ -52,7 +52,7 @@ EXECUTE name [ ( For more information on the creation and usage of prepared statements, - see . + see . @@ -96,7 +96,7 @@ EXECUTE name [ ( Examples are given in the section of the documentation. + linkend="sql-prepare"> documentation. @@ -115,8 +115,8 @@ EXECUTE name [ ( See Also - - + + diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index c28c5174000..cf4aa8f7622 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -1,11 +1,11 @@ - EXPLAIN + EXPLAIN 7 SQL - Language Statements @@ -209,7 +209,7 @@ ROLLBACK; In order to allow the PostgreSQL query planner to make reasonably informed decisions when optimizing - queries, the + queries, the statement should be run to record statistics about the distribution of data within the table. If you have not done this (or if the statistical distribution of the data in the table has changed @@ -339,7 +339,7 @@ EXPLAIN ANALYZE EXECUTE query(100, 200); See Also - + diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index 13cdcff37f2..46a9d4de8ec 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -1,11 +1,11 @@ - FETCH + FETCH 7 SQL - Language Statements @@ -337,9 +337,9 @@ FETCH count - + is used to define a cursor. Use - + to change cursor position without retrieving data. @@ -413,9 +413,9 @@ COMMIT WORK; See Also - - - + + + diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index 856005b0257..b0ac447700b 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -1,11 +1,11 @@ - GRANT + GRANT 7 SQL - Language Statements @@ -152,7 +152,7 @@ GRANT role_name [, ...] TO + command. @@ -164,14 +164,14 @@ GRANT role_name [, ...] TO SELECT - Allows from + Allows from any column, or the specific columns listed, of the specified table, view, or sequence. Also allows the use of - TO. + TO. This privilege is also needed to reference existing column values in - or - . + or + . For sequences, this privilege also allows the use of the currval function. For large objects, this privilege allows the object to be read. @@ -183,11 +183,11 @@ GRANT role_name [, ...] TO INSERT - Allows of a new + Allows of a new row into the specified table. If specific columns are listed, only those columns may be assigned to in the INSERT command (other columns will therefore receive default values). - Also allows FROM. + Also allows FROM. @@ -196,7 +196,7 @@ GRANT role_name [, ...] TO UPDATE - Allows of any + Allows of any column, or the specific columns listed, of the specified table. (In practice, any nontrivial UPDATE command will require SELECT privilege as well, since it must reference table @@ -218,7 +218,7 @@ GRANT role_name [, ...] TO DELETE - Allows of a row + Allows of a row from the specified table. (In practice, any nontrivial DELETE command will require SELECT privilege as well, since it must reference table @@ -231,7 +231,7 @@ GRANT role_name [, ...] TO TRUNCATE - Allows on + Allows on the specified table. @@ -254,7 +254,7 @@ GRANT role_name [, ...] TO Allows the creation of a trigger on the specified table. (See the - statement.) + statement.) @@ -396,7 +396,7 @@ GRANT role_name [, ...] TO Notes - The command is used + The command is used to revoke access privileges. @@ -628,8 +628,8 @@ GRANT admins TO joe; See Also - - + + diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index e9353da777e..153eceb2939 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -1,11 +1,11 @@ - initdb + initdb 1 Application diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index a2a52d8ba42..a17577b0e55 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -1,11 +1,11 @@ - INSERT + INSERT 7 SQL - Language Statements @@ -140,7 +140,7 @@ INSERT INTO table [ ( A query (SELECT statement) that supplies the rows to be inserted. Refer to the - + statement for a description of the syntax. @@ -296,7 +296,7 @@ INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets') Possible limitations of the query clause are documented under - . + . diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 57577c1f6ac..4f8b603bd29 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -1,11 +1,11 @@ - LISTEN + LISTEN 7 SQL - Language Statements @@ -65,7 +65,7 @@ LISTEN channel - + contains a more extensive discussion of the use of LISTEN and NOTIFY. @@ -130,8 +130,8 @@ Asynchronous notification "virtual" received from server process with PID 8448. See Also - - + + diff --git a/doc/src/sgml/ref/load.sgml b/doc/src/sgml/ref/load.sgml index 64237b09f5a..ef74a0fbd4d 100644 --- a/doc/src/sgml/ref/load.sgml +++ b/doc/src/sgml/ref/load.sgml @@ -1,10 +1,10 @@ - LOAD + LOAD 7 SQL - Language Statements @@ -39,7 +39,7 @@ LOAD 'filename' The file name is specified in the same way as for shared library - names in ; in particular, one + names in ; in particular, one can rely on a search path and automatic addition of the system's standard shared library file name extension. See for more information on this topic. @@ -73,7 +73,7 @@ LOAD 'filename' See Also - + diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 4df32bff450..a61cb98c7a3 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -1,11 +1,11 @@ - LOCK + LOCK 7 SQL - Language Statements @@ -168,9 +168,9 @@ LOCK [ TABLE ] [ ONLY ] name [, ... PostgreSQL reports an error if LOCK is used outside a transaction block. Use - and - - (or ) + and + + (or ) to define a transaction block. @@ -231,8 +231,7 @@ COMMIT WORK; There is no LOCK TABLE in the SQL standard, which instead uses SET TRANSACTION to specify concurrency levels on transactions. PostgreSQL supports that too; - see for details. + see for details. diff --git a/doc/src/sgml/ref/move.sgml b/doc/src/sgml/ref/move.sgml index beeb1349a19..09083d834be 100644 --- a/doc/src/sgml/ref/move.sgml +++ b/doc/src/sgml/ref/move.sgml @@ -1,11 +1,11 @@ - MOVE + MOVE 7 SQL - Language Statements @@ -42,7 +42,7 @@ MOVE [ direction [ FROM | IN ] ] The parameters for the MOVE command are identical to those of the FETCH command; refer to - + for details on syntax and usage. @@ -98,9 +98,9 @@ COMMIT WORK; See Also - - - + + + diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index dca5a1d1cbf..33b491e1e7c 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -1,11 +1,11 @@ - NOTIFY + NOTIFY 7 SQL - Language Statements @@ -216,8 +216,8 @@ Asynchronous notification "foo" with payload "payload" received from server proc See Also - - + + diff --git a/doc/src/sgml/ref/pg_config-ref.sgml b/doc/src/sgml/ref/pg_config-ref.sgml index 884ccea7afb..5c63942542e 100644 --- a/doc/src/sgml/ref/pg_config-ref.sgml +++ b/doc/src/sgml/ref/pg_config-ref.sgml @@ -1,8 +1,8 @@ - + - pg_config + pg_config 1 Application diff --git a/doc/src/sgml/ref/pg_controldata.sgml b/doc/src/sgml/ref/pg_controldata.sgml index fcf01873b38..79f74d70507 100644 --- a/doc/src/sgml/ref/pg_controldata.sgml +++ b/doc/src/sgml/ref/pg_controldata.sgml @@ -1,11 +1,11 @@ - pg_controldata + pg_controldata 1 Application diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/sgml/ref/pg_ctl-ref.sgml index a85d0ef02cb..e11e59a3fa1 100644 --- a/doc/src/sgml/ref/pg_ctl-ref.sgml +++ b/doc/src/sgml/ref/pg_ctl-ref.sgml @@ -1,11 +1,11 @@ - pg_ctl + pg_ctl 1 Application diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index ce4b9f49bf1..95a37512ee1 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -1,11 +1,11 @@ - pg_dumpall + pg_dumpall 1 Application diff --git a/doc/src/sgml/ref/pg_resetxlog.sgml b/doc/src/sgml/ref/pg_resetxlog.sgml index ab8c664a2b4..ba7de65ff41 100644 --- a/doc/src/sgml/ref/pg_resetxlog.sgml +++ b/doc/src/sgml/ref/pg_resetxlog.sgml @@ -1,11 +1,11 @@ - pg_resetxlog + pg_resetxlog 1 Application diff --git a/doc/src/sgml/ref/postmaster.sgml b/doc/src/sgml/ref/postmaster.sgml index 49a5278fb33..43de7a09944 100644 --- a/doc/src/sgml/ref/postmaster.sgml +++ b/doc/src/sgml/ref/postmaster.sgml @@ -1,11 +1,11 @@ - postmaster + postmaster 1 Application diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index 3061da5e6d2..4f961cde659 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -1,11 +1,11 @@ - PREPARE + PREPARE 7 SQL - Language Statements @@ -55,7 +55,7 @@ PREPARE name [ ( EXECUTE statement. Refer to for more + linkend="sql-execute"> for more information about that. @@ -66,8 +66,7 @@ PREPARE name [ ( command. + manually cleaned up using the command. @@ -141,14 +140,13 @@ PREPARE name [ ( PostgreSQL has chosen for a prepared - statement, use . + statement, use . For more information on query planning and the statistics collected by PostgreSQL for that purpose, see - the + the documentation. @@ -200,8 +198,8 @@ EXECUTE usrrptplan(1, current_date); See Also - - + + diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index da304c72550..9792bedcb5d 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -1,11 +1,11 @@ - PREPARE TRANSACTION + PREPARE TRANSACTION 7 SQL - Language Statements @@ -39,8 +39,8 @@ PREPARE TRANSACTION transaction_id Once prepared, a transaction can later be committed or rolled back - with - or , + with + or , respectively. Those commands can be issued from any session, not only the one that executed the original transaction. @@ -93,7 +93,7 @@ PREPARE TRANSACTION transaction_id This command must be used inside a transaction block. Use to start one. + linkend="sql-begin"> to start one. @@ -161,8 +161,8 @@ PREPARE TRANSACTION 'foobar'; See Also - - + + diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 33c7488d64f..782d91411e0 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,11 +1,11 @@ - psql + psql 1 Application @@ -622,8 +622,8 @@ testdb=> Whenever a command is executed, psql also polls for asynchronous notification events generated by - and - . + and + . @@ -798,8 +798,8 @@ testdb=> Performs a frontend (client) copy. This is an operation that - runs an SQL command, but instead of the server + runs an SQL + command, but instead of the server reading or writing the specified file, psql reads or writes the file and routes the data between the server and the local file system. @@ -810,8 +810,8 @@ testdb=> The syntax of the command is similar to that of the - SQL command. Note that, because of this, + SQL + command. Note that, because of this, special parsing rules apply to the \copy command. In particular, the variable substitution rules and backslash escapes do not apply. @@ -979,7 +979,7 @@ testdb=> Descriptions for objects can be created with the + linkend="sql-comment"> SQL command. @@ -999,11 +999,10 @@ testdb=> - The command is used to set + The command is used to set default access privileges. The meaning of the privilege display is explained under - . + . @@ -1264,11 +1263,11 @@ testdb=> - The and - + The and + commands are used to set access privileges. The meaning of the privilege display is explained under - . + . @@ -1287,8 +1286,8 @@ testdb=> - The and - + The and + commands are used to define per-role and per-database configuration settings. @@ -2097,7 +2096,7 @@ lo_import 152801 This command is totally separate from the SQL - command . + command . diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index f9636479cb5..069b99491f2 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -1,11 +1,11 @@ - REASSIGN OWNED + REASSIGN OWNED 7 SQL - Language Statements @@ -79,8 +79,7 @@ REASSIGN OWNED BY old_role [, ...] - The command is an alternative that + The command is an alternative that drops all the database objects owned by one or more roles. Note also that DROP OWNED requires privileges only on the source role(s). @@ -108,8 +107,8 @@ REASSIGN OWNED BY old_role [, ...] See Also - - + + diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index dc75d6e6b2a..e54253106a7 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,11 +1,11 @@ - REINDEX + REINDEX 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 1e98e07842c..dcc34fb61a9 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -5,7 +5,7 @@ PostgreSQL documentation - reindexdb + reindexdb 1 Application @@ -49,7 +49,7 @@ PostgreSQL documentation reindexdb is a wrapper around the SQL - command . + command . There is no effective difference between reindexing databases via this utility and via other methods for accessing the server. @@ -275,8 +275,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -324,7 +324,7 @@ PostgreSQL documentation See Also - + diff --git a/doc/src/sgml/ref/release_savepoint.sgml b/doc/src/sgml/ref/release_savepoint.sgml index 50986280134..c0f9d51885f 100644 --- a/doc/src/sgml/ref/release_savepoint.sgml +++ b/doc/src/sgml/ref/release_savepoint.sgml @@ -1,11 +1,11 @@ - RELEASE SAVEPOINT + RELEASE SAVEPOINT 7 SQL - Language Statements @@ -42,8 +42,8 @@ RELEASE [ SAVEPOINT ] savepoint_name Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of commands executed after the savepoint was established. - (To do that, see .) Destroying a savepoint when + (To do that, see .) + Destroying a savepoint when it is no longer needed allows the system to reclaim some resources earlier than transaction end. @@ -120,11 +120,11 @@ COMMIT; See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/reset.sgml b/doc/src/sgml/ref/reset.sgml index c864fde180c..c7900f71134 100644 --- a/doc/src/sgml/ref/reset.sgml +++ b/doc/src/sgml/ref/reset.sgml @@ -1,11 +1,11 @@ - RESET + RESET 7 SQL - Language Statements @@ -36,7 +36,7 @@ RESET ALL SET configuration_parameter TO DEFAULT - Refer to for + Refer to for details. @@ -68,7 +68,7 @@ SET configuration_parameter TO DEFA Name of a settable run-time parameter. Available parameters are documented in and on the - reference page. + reference page. @@ -107,8 +107,8 @@ RESET timezone; See Also - - + + diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index b81cd72d3fc..af93b90bb22 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,11 +1,11 @@ - REVOKE + REVOKE 7 SQL - Language Statements @@ -110,7 +110,7 @@ REVOKE [ ADMIN OPTION FOR ] - See the description of the command for + See the description of the command for the meaning of the privilege types. @@ -166,7 +166,7 @@ REVOKE [ ADMIN OPTION FOR ] Use 's \dp command to display the privileges granted on existing tables and columns. See for information about the + linkend="sql-grant"> for information about the format. For non-table objects there are other \d commands that can display their privileges. @@ -269,7 +269,7 @@ REVOKE admins FROM joe; Compatibility - The compatibility notes of the command + The compatibility notes of the command apply analogously to REVOKE. The keyword RESTRICT or CASCADE is required according to the standard, but PostgreSQL @@ -281,7 +281,7 @@ REVOKE admins FROM joe; See Also - + diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml index 01dddbf8d02..721ee690330 100644 --- a/doc/src/sgml/ref/rollback.sgml +++ b/doc/src/sgml/ref/rollback.sgml @@ -1,11 +1,11 @@ - ROLLBACK + ROLLBACK 7 SQL - Language Statements @@ -54,7 +54,7 @@ ROLLBACK [ WORK | TRANSACTION ] Notes - Use to + Use to successfully terminate a transaction. @@ -89,9 +89,9 @@ ROLLBACK; See Also - - - + + + diff --git a/doc/src/sgml/ref/rollback_prepared.sgml b/doc/src/sgml/ref/rollback_prepared.sgml index 4a4a1f4e0ce..d6d01d2f065 100644 --- a/doc/src/sgml/ref/rollback_prepared.sgml +++ b/doc/src/sgml/ref/rollback_prepared.sgml @@ -1,11 +1,11 @@ - ROLLBACK PREPARED + ROLLBACK PREPARED 7 SQL - Language Statements @@ -88,8 +88,8 @@ ROLLBACK PREPARED 'foobar'; See Also - - + + diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml index 414f450a41d..488378b0c33 100644 --- a/doc/src/sgml/ref/rollback_to.sgml +++ b/doc/src/sgml/ref/rollback_to.sgml @@ -1,11 +1,11 @@ - ROLLBACK TO SAVEPOINT + ROLLBACK TO SAVEPOINT 7 SQL - Language Statements @@ -65,7 +65,7 @@ ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name Use to destroy a savepoint without + > to destroy a savepoint without discarding the effects of commands executed after it was established. @@ -149,11 +149,11 @@ COMMIT; See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/savepoint.sgml b/doc/src/sgml/ref/savepoint.sgml index d465463f7c9..72b718fcf65 100644 --- a/doc/src/sgml/ref/savepoint.sgml +++ b/doc/src/sgml/ref/savepoint.sgml @@ -1,11 +1,11 @@ - SAVEPOINT + SAVEPOINT 7 SQL - Language Statements @@ -64,9 +64,9 @@ SAVEPOINT savepoint_name Notes - Use to - rollback to a savepoint. Use to destroy a savepoint, keeping + Use to + rollback to a savepoint. Use + to destroy a savepoint, keeping the effects of commands executed after it was established. @@ -126,11 +126,11 @@ COMMIT; See Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 395ca79604c..372116be3fc 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1,11 +1,11 @@ - SELECT + SELECT 7 SQL - Language Statements @@ -305,7 +305,7 @@ TABLE { [ ONLY ] table_name [ * ] | sub-SELECT must be surrounded by parentheses, and an alias must be provided for it. A - command + command can also be used here. @@ -1154,7 +1154,7 @@ FOR SHARE [ OF table_name [, ...] ] to the row-level lock(s) — the required ROW SHARE table-level lock is still taken in the ordinary way (see ). You can use - + with the NOWAIT option first, if you need to acquire the table-level lock without waiting. diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index 057bfb2a9d7..fc726c66843 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -1,11 +1,11 @@ - SELECT INTO + SELECT INTO 7 SQL - Language Statements @@ -60,8 +60,7 @@ SELECT [ ALL | DISTINCT [ ON ( expression If specified, the table is created as a temporary table. Refer - to for details. + to for details. @@ -78,7 +77,7 @@ SELECT [ ALL | DISTINCT [ ON ( expression All other parameters are described in detail under . + linkend="sql-select">. @@ -86,8 +85,7 @@ SELECT [ ALL | DISTINCT [ ON ( expressionNotes - is functionally similar to + is functionally similar to SELECT INTO. CREATE TABLE AS is the recommended syntax, since this form of SELECT INTO is not available in ECPG @@ -141,7 +139,7 @@ SELECT * INTO films_recent FROM films WHERE date_prod >= '2002-01-01'; See Also - + diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 621bd641396..7c60d7ae5d2 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,11 +1,11 @@ - SET + SET 7 SQL - Language Statements @@ -67,7 +67,7 @@ SET [ SESSION | LOCAL ] TIME ZONE { timezone If SET LOCAL is used within a function that has a SET option for the same variable (see - ), + ), the effects of the SET LOCAL command disappear at function exit; that is, the value in effect when the function was called is restored anyway. This allows SET LOCAL to be used for @@ -322,8 +322,8 @@ SET TIME ZONE 'Europe/Rome'; See Also - - + + diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 94c2ecabc72..ffadfd74757 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -1,7 +1,7 @@ - + - SET CONSTRAINTS + SET CONSTRAINTS 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index 1079de91130..c7a4b0d68e9 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -1,11 +1,11 @@ - SET ROLE + SET ROLE 7 SQL - Language Statements @@ -48,7 +48,7 @@ RESET ROLE The SESSION and LOCAL modifiers act the same - as for the regular + as for the regular command. @@ -82,8 +82,7 @@ RESET ROLE SET ROLE has effects comparable to - , but the privilege + , but the privilege checks involved are quite different. Also, SET SESSION AUTHORIZATION determines which roles are allowable for later SET ROLE commands, whereas changing @@ -93,8 +92,7 @@ RESET ROLE SET ROLE does not process session variables as specified by - the role's settings; this only happens during + the role's settings; this only happens during login. @@ -144,7 +142,7 @@ SELECT SESSION_USER, CURRENT_USER; See Also - + diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index 736baf90117..35d93c23e6e 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -1,7 +1,7 @@ - + - SET SESSION AUTHORIZATION + SET SESSION AUTHORIZATION 7 SQL - Language Statements @@ -41,7 +41,7 @@ RESET SESSION AUTHORIZATION identifier is normally equal to the session user identifier, but might change temporarily in the context of SECURITY DEFINER functions and similar mechanisms; it can also be changed by - . + . The current user identifier is relevant for permission checking. @@ -54,7 +54,7 @@ RESET SESSION AUTHORIZATION The SESSION and LOCAL modifiers act the same - as for the regular + as for the regular command. @@ -120,7 +120,7 @@ SELECT SESSION_USER, CURRENT_USER; See Also - + diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index 80cf691182f..ecf24eac63d 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -1,7 +1,7 @@ - + - SET TRANSACTION + SET TRANSACTION 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml index a949c43b7e4..5684916d490 100644 --- a/doc/src/sgml/ref/show.sgml +++ b/doc/src/sgml/ref/show.sgml @@ -1,11 +1,11 @@ - SHOW + SHOW 7 SQL - Language Statements @@ -52,7 +52,7 @@ SHOW ALL The name of a run-time parameter. Available parameters are documented in and on the reference page. In + linkend="SQL-SET"> reference page. In addition, there are a few parameters that can be shown but not set: @@ -194,8 +194,8 @@ SHOW ALL; See Also - - + + diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index 15ba39af919..c87a1c0b6a8 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -1,11 +1,11 @@ - START TRANSACTION + START TRANSACTION 7 SQL - Language Statements @@ -36,9 +36,8 @@ START TRANSACTION [ transaction_mode This command begins a new transaction block. If the isolation level or read/write mode is specified, the new transaction has those - characteristics, as if was executed. This is the same - as the command. + characteristics, as if was executed. This is the same + as the command. @@ -46,8 +45,7 @@ START TRANSACTION [ transaction_modeParameters - Refer to for information on the meaning + Refer to for information on the meaning of the parameters to this statement. @@ -74,8 +72,7 @@ START TRANSACTION [ transaction_mode - See also the compatibility section of . + See also the compatibility section of . @@ -83,11 +80,11 @@ START TRANSACTION [ transaction_modeSee Also - - - - - + + + + + diff --git a/doc/src/sgml/ref/truncate.sgml b/doc/src/sgml/ref/truncate.sgml index bec47fdbab0..08dc670843a 100644 --- a/doc/src/sgml/ref/truncate.sgml +++ b/doc/src/sgml/ref/truncate.sgml @@ -1,11 +1,11 @@ - TRUNCATE + TRUNCATE 7 SQL - Language Statements diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index 9e22ea4edc4..774858063a1 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -1,11 +1,11 @@ - UNLISTEN + UNLISTEN 7 SQL - Language Statements @@ -40,7 +40,7 @@ UNLISTEN { channel | * } - + contains a more extensive discussion of the use of LISTEN and NOTIFY. @@ -127,8 +127,8 @@ NOTIFY virtual; See Also - - + + diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index 4ed6458f654..8673df18ff4 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -1,11 +1,11 @@ - UPDATE + UPDATE 7 SQL - Language Statements @@ -172,7 +172,7 @@ UPDATE [ ONLY ] table [ [ AS ] UPDATE's target table. Note that WHERE CURRENT OF cannot be specified together with a Boolean condition. See - + for more information about using cursors with WHERE CURRENT OF. diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index bd2b6726c44..aece3e02d1c 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -1,11 +1,11 @@ - VACUUM + VACUUM 7 SQL - Language Statements @@ -49,7 +49,7 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ VACUUM ANALYZE performs a VACUUM and then an ANALYZE for each selected table. This is a handy combination form for routine maintenance scripts. See - + for more details about its processing. @@ -271,9 +271,9 @@ VACUUM See Also - - - + + + diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 3644eb97fa9..c6f576772e5 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -1,11 +1,11 @@ - vacuumdb + vacuumdb 1 Application @@ -56,7 +56,7 @@ PostgreSQL documentation vacuumdb is a wrapper around the SQL - command . + command . There is no effective difference between vacuuming and analyzing databases via this utility and via other methods for accessing the server. @@ -318,8 +318,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see + and 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 @@ -376,7 +376,7 @@ PostgreSQL documentation See Also - + diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 3a70f1bfe4b..d6d2c0cf607 100644 --- a/doc/src/sgml/ref/values.sgml +++ b/doc/src/sgml/ref/values.sgml @@ -1,11 +1,11 @@ - VALUES + VALUES 7 SQL - Language Statements @@ -234,7 +234,7 @@ WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1. VALUES conforms to the SQL standard. LIMIT and OFFSET are PostgreSQL extensions; see also - under . + under . @@ -242,8 +242,8 @@ WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1. See Also - - + + diff --git a/doc/src/sgml/regress.sgml b/doc/src/sgml/regress.sgml index 1668a0615eb..c5c1e14f1e3 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -1,7 +1,7 @@ - + - Regression Tests + Regression Tests regression tests diff --git a/doc/src/sgml/release-9.0.sgml b/doc/src/sgml/release-9.0.sgml index ebc592e9622..70d9822450f 100644 --- a/doc/src/sgml/release-9.0.sgml +++ b/doc/src/sgml/release-9.0.sgml @@ -1,4 +1,4 @@ - + @@ -539,7 +539,7 @@ Allow setting of configuration variables based on database/role + linkend="sql-alterrole">database/role combinations (Alvaro Herrera) diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml index 8d40c60c8e7..dd50665e10b 100644 --- a/doc/src/sgml/spi.sgml +++ b/doc/src/sgml/spi.sgml @@ -1,4 +1,4 @@ - + Server Programming Interface @@ -2341,7 +2341,7 @@ void SPI_scroll_cursor_fetch(Portal portal, FetchDirectio Notes - See the SQL command + See the SQL command for details of the interpretation of the direction and count parameters. @@ -2442,7 +2442,7 @@ void SPI_scroll_cursor_move(Portal portal, FetchDirection Notes - See the SQL command + See the SQL command for details of the interpretation of the direction and count parameters. diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 83ecb8653c6..7259a47bbf5 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ - + SQL Syntax @@ -1698,7 +1698,7 @@ UNBOUNDED FOLLOWING window must lack these clauses, if they are supplied here). This latter syntax follows the same rules as modifying an existing window name within the WINDOW clause; see the - reference + reference page for details. @@ -1840,7 +1840,7 @@ CAST ( expression AS type syntax is nothing more than a direct invocation of the underlying conversion function. Obviously, this is not something that a portable application should rely on. For further details see - . + . diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index ab601e3ce36..fd4dd1d1452 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -1,7 +1,7 @@ - + - Full Text Search + Full Text Search full text search diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index 5418f314a31..a40963fd5b2 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -1,4 +1,4 @@ - + Triggers @@ -57,7 +57,7 @@ Once a suitable trigger function has been created, the trigger is established with - . + . The same trigger function can be used for multiple triggers. diff --git a/doc/src/sgml/typeconv.sgml b/doc/src/sgml/typeconv.sgml index a1b04ce417f..fffd2aa9858 100644 --- a/doc/src/sgml/typeconv.sgml +++ b/doc/src/sgml/typeconv.sgml @@ -1,4 +1,4 @@ - + Type Conversion @@ -139,7 +139,7 @@ and for the GREATEST and LEAST functions. The system catalogs store information about which conversions, or casts, exist between which data types, and how to perform those conversions. Additional casts can be added by the user -with the +with the command. (This is usually done in conjunction with defining new data types. The set of casts between built-in types has been carefully crafted and is best not @@ -543,7 +543,7 @@ the function call is treated as a form of CAST specification. in cases where there is not an actual cast function. If there is a cast function, it is conventionally named after its output type, and so there is no need to have a special case. See - + for additional commentary. diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml index 01c1ba94808..16130b6191c 100644 --- a/doc/src/sgml/user-manag.sgml +++ b/doc/src/sgml/user-manag.sgml @@ -1,4 +1,4 @@ - + Database Roles and Privileges @@ -53,7 +53,7 @@ maintain a correspondence, but this is not required. Database roles are global across a database cluster installation (and not per individual database). To create a role use the SQL command: + linkend="sql-createrole"> SQL command: CREATE ROLE name; @@ -62,7 +62,7 @@ CREATE ROLE name; double-quoted. (In practice, you will usually want to add additional options, such as LOGIN, to the command. More details appear below.) To remove an existing role, use the analogous - command: + command: DROP ROLE name; @@ -228,8 +228,8 @@ CREATE USER name; A role's attributes can be modified after creation with ALTER ROLE.ALTER ROLE See the reference pages for the and commands for details. + > and commands for details. @@ -297,7 +297,7 @@ ALTER ROLE myname SET statement_timeout = '5min'; EXECUTE, and USAGE. For more information on the different types of privileges supported by PostgreSQL, see the - reference page. + reference page. @@ -316,7 +316,7 @@ GRANT UPDATE ON accounts TO joe; To revoke a privilege, use the fittingly named - command: + command: REVOKE ALL ON accounts FROM PUBLIC; @@ -366,8 +366,8 @@ CREATE ROLE name; Once the group role exists, you can add and remove members using the - and - commands: + and + commands: GRANT group_role TO role1, ... ; REVOKE group_role FROM role1, ... ; @@ -382,7 +382,7 @@ REVOKE group_role FROM role1 The members of a group role can use the privileges of the role in two ways. First, every member of a group can explicitly do - to + to temporarily become the group role. In this state, the database session has access to the privileges of the group role rather than the original login role, and any database objects created are @@ -466,7 +466,7 @@ RESET ROLE; To destroy a group role, use : + linkend="sql-droprole">: DROP ROLE name; diff --git a/doc/src/sgml/xaggr.sgml b/doc/src/sgml/xaggr.sgml index 1c34957a166..b78a336c19c 100644 --- a/doc/src/sgml/xaggr.sgml +++ b/doc/src/sgml/xaggr.sgml @@ -1,4 +1,4 @@ - + User-Defined Aggregates @@ -184,7 +184,7 @@ SELECT attrelid::regclass, array_accum(atttypid::regtype) For further details see the - + command. diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 93f880cc63e..fcf9e3b1d49 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -1,4 +1,4 @@ - + User-Defined Functions @@ -63,8 +63,7 @@ Throughout this chapter, it can be useful to look at the reference - page of the command to + page of the command to understand the examples better. Some examples from this chapter can be found in funcs.sql and funcs.c in the src/tutorial @@ -1179,7 +1178,7 @@ CREATE FUNCTION test(int, int) RETURNS int Every function has a volatility classification, with the possibilities being VOLATILE, STABLE, or IMMUTABLE. VOLATILE is the default if the - + command does not specify a category. The volatility category is a promise to the optimizer about the behavior of the function: diff --git a/doc/src/sgml/xplang.sgml b/doc/src/sgml/xplang.sgml index 59d3050ee6a..87de1971bc4 100644 --- a/doc/src/sgml/xplang.sgml +++ b/doc/src/sgml/xplang.sgml @@ -1,7 +1,7 @@ - + - Procedural Languages + Procedural Languages procedural language @@ -113,7 +113,7 @@ CREATE FUNCTION handler_function_name() Optionally, the language handler can provide an inline handler function that executes anonymous code blocks - ( commands) + ( commands) written in this language. If an inline handler function is provided by the language, declare it with a command like diff --git a/doc/src/sgml/xtypes.sgml b/doc/src/sgml/xtypes.sgml index 14eb83a8e13..af4c57e6aff 100644 --- a/doc/src/sgml/xtypes.sgml +++ b/doc/src/sgml/xtypes.sgml @@ -1,4 +1,4 @@ - + User-Defined Types @@ -290,6 +290,6 @@ CREATE TYPE complex ( For further details see the description of the - command. + command. -- cgit v1.2.3