From 3a9d430af515e9dd8a9d34a4011367e667a66521 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 6 May 2014 21:28:58 -0400 Subject: [PATCH] doc: Fix DocBook XML validity The main problem is that DocBook SGML allows indexterm elements just about everywhere, but DocBook XML is stricter. For example, this common pattern ... ... ... needs to be changed to something like ...... ... See also bb4eefe7bf518e42c73797ea37b033a5d8a8e70a. There is currently nothing in the build system that enforces that things stay valid, because that requires additional tools and will receive separate consideration. --- doc/src/sgml/auth-delay.sgml | 6 +- doc/src/sgml/auto-explain.sgml | 48 +- doc/src/sgml/config.sgml | 733 ++++++++++++++++++--------- doc/src/sgml/dfunc.sgml | 56 +- doc/src/sgml/installation.sgml | 7 +- doc/src/sgml/libpq.sgml | 4 +- doc/src/sgml/logicaldecoding.sgml | 2 +- doc/src/sgml/pageinspect.sgml | 42 +- doc/src/sgml/pgfreespacemap.sgml | 6 +- doc/src/sgml/pgstatstatements.sgml | 16 +- doc/src/sgml/pgstattuple.sgml | 7 +- doc/src/sgml/plperl.sgml | 278 +++++----- doc/src/sgml/pltcl.sgml | 23 +- doc/src/sgml/protocol.sgml | 3 +- doc/src/sgml/queries.sgml | 16 +- doc/src/sgml/recovery-config.sgml | 55 +- doc/src/sgml/ref/alter_table.sgml | 13 +- doc/src/sgml/ref/pg_recvlogical.sgml | 8 +- doc/src/sgml/ref/psql-ref.sgml | 24 +- doc/src/sgml/rules.sgml | 4 +- doc/src/sgml/runtime.sgml | 30 +- doc/src/sgml/sepgsql.sgml | 20 +- doc/src/sgml/sslinfo.sgml | 54 +- doc/src/sgml/textsearch.sgml | 26 +- 24 files changed, 903 insertions(+), 578 deletions(-) diff --git a/doc/src/sgml/auth-delay.sgml b/doc/src/sgml/auth-delay.sgml index 91549ffe4f..9a6e3e9bb4 100644 --- a/doc/src/sgml/auth-delay.sgml +++ b/doc/src/sgml/auth-delay.sgml @@ -28,10 +28,10 @@ auth_delay.milliseconds (int) + + auth_delay.milliseconds configuration parameter + - - auth_delay.milliseconds configuration parameter - The number of milliseconds to wait before reporting an authentication diff --git a/doc/src/sgml/auto-explain.sgml b/doc/src/sgml/auto-explain.sgml index 1037f1f2e2..334996b0e6 100644 --- a/doc/src/sgml/auto-explain.sgml +++ b/doc/src/sgml/auto-explain.sgml @@ -46,10 +46,10 @@ LOAD 'auto_explain'; auto_explain.log_min_duration (integer) + + auto_explain.log_min_duration configuration parameter + - - auto_explain.log_min_duration configuration parameter - auto_explain.log_min_duration is the minimum statement @@ -65,10 +65,10 @@ LOAD 'auto_explain'; auto_explain.log_analyze (boolean) + + auto_explain.log_analyze configuration parameter + - - auto_explain.log_analyze configuration parameter - auto_explain.log_analyze causes EXPLAIN ANALYZE @@ -89,10 +89,10 @@ LOAD 'auto_explain'; auto_explain.log_verbose (boolean) + + auto_explain.log_verbose configuration parameter + - - auto_explain.log_verbose configuration parameter - auto_explain.log_verbose causes EXPLAIN VERBOSE @@ -106,10 +106,10 @@ LOAD 'auto_explain'; auto_explain.log_buffers (boolean) + + auto_explain.log_buffers configuration parameter + - - auto_explain.log_buffers configuration parameter - auto_explain.log_buffers causes EXPLAIN @@ -125,10 +125,10 @@ LOAD 'auto_explain'; auto_explain.log_triggers (boolean) + + auto_explain.log_triggers configuration parameter + - - auto_explain.log_triggers configuration parameter - auto_explain.log_triggers causes trigger @@ -143,10 +143,10 @@ LOAD 'auto_explain'; auto_explain.log_format (enum) + + auto_explain.log_format configuration parameter + - - auto_explain.log_format configuration parameter - auto_explain.log_format selects the @@ -161,10 +161,10 @@ LOAD 'auto_explain'; auto_explain.log_timing (boolean) + + auto_explain.log_timing configuration parameter + - - auto_explain.log_timing configuration parameter - auto_explain.log_timing causes EXPLAIN @@ -182,10 +182,10 @@ LOAD 'auto_explain'; auto_explain.log_nested_statements (boolean) + + auto_explain.log_nested_statements configuration parameter + - - auto_explain.log_nested_statements configuration parameter - auto_explain.log_nested_statements causes nested diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 4a33f87491..9ff230aa6d 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -331,10 +331,11 @@ include 'filename' - data_directory (string) + data_directory (string) data_directory configuration parameter + Specifies the directory to use for data storage. @@ -344,10 +345,11 @@ include 'filename' - config_file (string) + config_file (string) config_file configuration parameter + Specifies the main server configuration file @@ -358,10 +360,11 @@ include 'filename' - hba_file (string) + hba_file (string) hba_file configuration parameter + Specifies the configuration file for host-based authentication @@ -372,10 +375,11 @@ include 'filename' - ident_file (string) + ident_file (string) ident_file configuration parameter + Specifies the configuration file for @@ -387,10 +391,11 @@ include 'filename' - external_pid_file (string) + external_pid_file (string) external_pid_file configuration parameter + Specifies the name of an additional process-ID (PID) file that the @@ -450,10 +455,11 @@ include 'filename' - listen_addresses (string) + listen_addresses (string) listen_addresses configuration parameter + Specifies the TCP/IP address(es) on which the server is @@ -480,10 +486,11 @@ include 'filename' - port (integer) + port (integer) port configuration parameter + The TCP port the server listens on; 5432 by default. Note that the @@ -494,10 +501,11 @@ include 'filename' - max_connections (integer) + max_connections (integer) max_connections configuration parameter + Determines the maximum number of concurrent connections to the @@ -518,10 +526,11 @@ include 'filename' superuser_reserved_connections - (integer) + (integer) superuser_reserved_connections configuration parameter + Determines the number of connection slots that @@ -544,10 +553,11 @@ include 'filename' - unix_socket_directories (string) + unix_socket_directories (string) unix_socket_directories configuration parameter + Specifies the directory of the Unix-domain socket(s) on which the @@ -581,10 +591,11 @@ include 'filename' - unix_socket_group (string) + unix_socket_group (string) unix_socket_group configuration parameter + Sets the owning group of the Unix-domain socket(s). (The owning @@ -605,10 +616,11 @@ include 'filename' - unix_socket_permissions (integer) + unix_socket_permissions (integer) unix_socket_permissions configuration parameter + Sets the access permissions of the Unix-domain socket(s). Unix-domain @@ -651,10 +663,11 @@ include 'filename' - bonjour (boolean) + bonjour (boolean) bonjour configuration parameter + Enables advertising the server's existence via @@ -665,10 +678,11 @@ include 'filename' - bonjour_name (string) + bonjour_name (string) bonjour_name configuration parameter + Specifies the Bonjour service @@ -682,10 +696,11 @@ include 'filename' - tcp_keepalives_idle (integer) + tcp_keepalives_idle (integer) tcp_keepalives_idle configuration parameter + Specifies the number of seconds of inactivity after which TCP @@ -707,10 +722,11 @@ include 'filename' - tcp_keepalives_interval (integer) + tcp_keepalives_interval (integer) tcp_keepalives_interval configuration parameter + Specifies the number of seconds after which a TCP keepalive message @@ -732,10 +748,11 @@ include 'filename' - tcp_keepalives_count (integer) + tcp_keepalives_count (integer) tcp_keepalives_count configuration parameter + Specifies the number of TCP keepalives that can be lost before @@ -761,12 +778,13 @@ include 'filename' - authentication_timeout (integer) + authentication_timeout (integer) timeoutclient authentication client authenticationtimeout during authentication_timeout configuration parameter + @@ -782,10 +800,11 @@ include 'filename' - ssl (boolean) + ssl (boolean) ssl configuration parameter + Enables SSL connections. Please read @@ -798,10 +817,11 @@ include 'filename' - ssl_ca_file (string) + ssl_ca_file (string) ssl_ca_file configuration parameter + Specifies the name of the file containing the SSL server certificate @@ -815,10 +835,11 @@ include 'filename' - ssl_cert_file (string) + ssl_cert_file (string) ssl_cert_file configuration parameter + Specifies the name of the file containing the SSL server certificate. @@ -830,10 +851,11 @@ include 'filename' - ssl_crl_file (string) + ssl_crl_file (string) ssl_crl_file configuration parameter + Specifies the name of the file containing the SSL server certificate @@ -847,10 +869,11 @@ include 'filename' - ssl_key_file (string) + ssl_key_file (string) ssl_key_file configuration parameter + Specifies the name of the file containing the SSL server private key. @@ -862,10 +885,11 @@ include 'filename' - ssl_renegotiation_limit (integer) + ssl_renegotiation_limit (integer) ssl_renegotiation_limit configuration parameter + Specifies how much data can flow over an SSL-encrypted @@ -890,10 +914,11 @@ include 'filename' - ssl_ciphers (string) + ssl_ciphers (string) ssl_ciphers configuration parameter + Specifies a list of SSL cipher suites that are allowed to be @@ -966,10 +991,11 @@ include 'filename' - ssl_prefer_server_ciphers (bool) + ssl_prefer_server_ciphers (bool) ssl_prefer_server_ciphers configuration parameter + Specifies whether to use the server's SSL cipher preferences, rather @@ -987,10 +1013,11 @@ include 'filename' - ssl_ecdh_curve (string) + ssl_ecdh_curve (string) ssl_ecdh_curve configuration parameter + Specifies the name of the curve to use in ECDH key exchanges. The @@ -1005,10 +1032,11 @@ include 'filename' - password_encryption (boolean) + password_encryption (boolean) password_encryption configuration parameter + When a password is specified in - krb_server_keyfile (string) + krb_server_keyfile (string) krb_server_keyfile configuration parameter + Sets the location of the Kerberos server key file. See @@ -1038,10 +1067,11 @@ include 'filename' - krb_caseins_users (boolean) + krb_caseins_users (boolean) krb_caseins_users configuration parameter + Sets whether GSSAPI user names should be treated @@ -1053,10 +1083,11 @@ include 'filename' - db_user_namespace (boolean) + db_user_namespace (boolean) db_user_namespace configuration parameter + This parameter enables per-database user names. It is off by default. @@ -1115,10 +1146,11 @@ include 'filename' - shared_buffers (integer) + shared_buffers (integer) shared_buffers configuration parameter + Sets the amount of memory the database server uses for shared @@ -1160,10 +1192,11 @@ include 'filename' - huge_pages (enum) + huge_pages (enum) huge_pages configuration parameter + Enables/disables the use of huge memory pages. Valid values are @@ -1193,10 +1226,11 @@ include 'filename' - temp_buffers (integer) + temp_buffers (integer) temp_buffers configuration parameter + Sets the maximum number of temporary buffers used by each database @@ -1221,10 +1255,11 @@ include 'filename' - max_prepared_transactions (integer) + max_prepared_transactions (integer) max_prepared_transactions configuration parameter + Sets the maximum number of transactions that can be in the @@ -1253,10 +1288,11 @@ include 'filename' - work_mem (integer) + work_mem (integer) work_mem configuration parameter + Specifies the amount of memory to be used by internal sort operations @@ -1278,10 +1314,11 @@ include 'filename' - maintenance_work_mem (integer) + maintenance_work_mem (integer) maintenance_work_mem configuration parameter + Specifies the maximum amount of memory to be used by maintenance @@ -1305,10 +1342,11 @@ include 'filename' - autovacuum_work_mem (integer) + autovacuum_work_mem (integer) autovacuum_work_mem configuration parameter + Specifies the maximum amount of memory to be used by each @@ -1321,10 +1359,11 @@ include 'filename' - max_stack_depth (integer) + max_stack_depth (integer) max_stack_depth configuration parameter + Specifies the maximum safe depth of the server's execution stack. @@ -1353,10 +1392,11 @@ include 'filename' - dynamic_shared_memory_type (enum) + dynamic_shared_memory_type (enum) dynamic_shared_memory_type configuration parameter + Specifies the dynamic shared memory implementation that the server @@ -1386,10 +1426,11 @@ include 'filename' - temp_file_limit (integer) + temp_file_limit (integer) temp_file_limit configuration parameter + Specifies the maximum amount of disk space that a session can use @@ -1418,10 +1459,11 @@ include 'filename' - max_files_per_process (integer) + max_files_per_process (integer) max_files_per_process configuration parameter + Sets the maximum number of simultaneously open files allowed to each @@ -1476,10 +1518,11 @@ include 'filename' - vacuum_cost_delay (integer) + vacuum_cost_delay (integer) vacuum_cost_delay configuration parameter + The length of time, in milliseconds, that the process will sleep @@ -1503,10 +1546,11 @@ include 'filename' - vacuum_cost_page_hit (integer) + vacuum_cost_page_hit (integer) vacuum_cost_page_hit configuration parameter + The estimated cost for vacuuming a buffer found in the shared buffer @@ -1518,10 +1562,11 @@ include 'filename' - vacuum_cost_page_miss (integer) + vacuum_cost_page_miss (integer) vacuum_cost_page_miss configuration parameter + The estimated cost for vacuuming a buffer that has to be read from @@ -1533,10 +1578,11 @@ include 'filename' - vacuum_cost_page_dirty (integer) + vacuum_cost_page_dirty (integer) vacuum_cost_page_dirty configuration parameter + The estimated cost charged when vacuum modifies a block that was @@ -1548,10 +1594,11 @@ include 'filename' - vacuum_cost_limit (integer) + vacuum_cost_limit (integer) vacuum_cost_limit configuration parameter + The accumulated cost that will cause the vacuuming process to sleep. @@ -1595,10 +1642,11 @@ include 'filename' - bgwriter_delay (integer) + bgwriter_delay (integer) bgwriter_delay configuration parameter + Specifies the delay between activity rounds for the @@ -1619,10 +1667,11 @@ include 'filename' - bgwriter_lru_maxpages (integer) + bgwriter_lru_maxpages (integer) bgwriter_lru_maxpages configuration parameter + In each round, no more than this many buffers will be written @@ -1637,10 +1686,11 @@ include 'filename' - bgwriter_lru_multiplier (floating point) + bgwriter_lru_multiplier (floating point) bgwriter_lru_multiplier configuration parameter + The number of dirty buffers written in each round is based on the @@ -1678,10 +1728,11 @@ include 'filename' - effective_io_concurrency (integer) + effective_io_concurrency (integer) effective_io_concurrency configuration parameter + Sets the number of concurrent disk I/O operations that @@ -1721,10 +1772,11 @@ include 'filename' - max_worker_processes (integer) + max_worker_processes (integer) max_worker_processes configuration parameter + Sets the maximum number of background processes that the system @@ -1755,10 +1807,11 @@ include 'filename' - wal_level (enum) + wal_level (enum) wal_level configuration parameter + wal_level determines how much information is written @@ -1812,10 +1865,11 @@ include 'filename' - fsync (boolean) + fsync (boolean) fsync configuration parameter + If this parameter is on, the PostgreSQL server @@ -1873,10 +1927,11 @@ include 'filename' - synchronous_commit (enum) + synchronous_commit (enum) synchronous_commit configuration parameter + Specifies whether transaction commit will wait for WAL records @@ -1942,10 +1997,11 @@ include 'filename' - wal_sync_method (enum) + wal_sync_method (enum) wal_sync_method configuration parameter + Method used for forcing WAL updates out to disk. @@ -1997,10 +2053,11 @@ include 'filename' - full_page_writes (boolean) + full_page_writes (boolean) full_page_writes configuration parameter + When this parameter is on, the PostgreSQL server @@ -2043,10 +2100,11 @@ include 'filename' - wal_log_hints (boolean) + wal_log_hints (boolean) wal_log_hints configuration parameter + When this parameter is on, the PostgreSQL @@ -2069,10 +2127,11 @@ include 'filename' - wal_buffers (integer) + wal_buffers (integer) wal_buffers configuration parameter + The amount of shared memory used for WAL data that has not yet been @@ -2100,10 +2159,11 @@ include 'filename' - wal_writer_delay (integer) + wal_writer_delay (integer) wal_writer_delay configuration parameter + Specifies the delay between activity rounds for the WAL writer. @@ -2120,10 +2180,11 @@ include 'filename' - commit_delay (integer) + commit_delay (integer) commit_delay configuration parameter + commit_delay adds a time delay, measured in @@ -2155,10 +2216,11 @@ include 'filename' - commit_siblings (integer) + commit_siblings (integer) commit_siblings configuration parameter + Minimum number of concurrent open transactions to require @@ -2177,10 +2239,11 @@ include 'filename' - checkpoint_segments (integer) + checkpoint_segments (integer) checkpoint_segments configuration parameter + Maximum number of log file segments between automatic WAL @@ -2194,10 +2257,11 @@ include 'filename' - checkpoint_timeout (integer) + checkpoint_timeout (integer) checkpoint_timeout configuration parameter + Maximum time between automatic WAL checkpoints, in @@ -2211,10 +2275,11 @@ include 'filename' - checkpoint_completion_target (floating point) + checkpoint_completion_target (floating point) checkpoint_completion_target configuration parameter + Specifies the target of checkpoint completion, as a fraction of @@ -2227,10 +2292,11 @@ include 'filename' - checkpoint_warning (integer) + checkpoint_warning (integer) checkpoint_warning configuration parameter + Write a message to the server log if checkpoints caused by @@ -2253,10 +2319,11 @@ include 'filename' - archive_mode (boolean) + archive_mode (boolean) archive_mode configuration parameter + When archive_mode is enabled, completed WAL segments @@ -2273,10 +2340,11 @@ include 'filename' - archive_command (string) + archive_command (string) archive_command configuration parameter + The local shell command to execute to archive a completed WAL file @@ -2308,10 +2376,11 @@ include 'filename' - archive_timeout (integer) + archive_timeout (integer) archive_timeout configuration parameter + The is only invoked for @@ -2376,10 +2445,11 @@ include 'filename' - max_wal_senders (integer) + max_wal_senders (integer) max_wal_senders configuration parameter + Specifies the maximum number of concurrent connections from @@ -2401,10 +2471,11 @@ include 'filename' - max_replication_slots (integer) + max_replication_slots (integer) max_replication_slots configuration parameter + Specifies the maximum number of replication slots @@ -2420,10 +2491,11 @@ include 'filename' - wal_keep_segments (integer) + wal_keep_segments (integer) wal_keep_segments configuration parameter + Specifies the minimum number of past log file segments kept in the @@ -2455,10 +2527,11 @@ include 'filename' - wal_sender_timeout (integer) + wal_sender_timeout (integer) wal_sender_timeout configuration parameter + Terminate replication connections that are inactive longer @@ -2493,10 +2566,11 @@ include 'filename' - synchronous_standby_names (string) + synchronous_standby_names (string) synchronous_standby_names configuration parameter + Specifies a comma-separated list of standby names that can support @@ -2544,10 +2618,11 @@ include 'filename' - vacuum_defer_cleanup_age (integer) + vacuum_defer_cleanup_age (integer) vacuum_defer_cleanup_age configuration parameter + Specifies the number of transactions by which VACUUM and @@ -2587,10 +2662,11 @@ include 'filename' - hot_standby (boolean) + hot_standby (boolean) hot_standby configuration parameter + Specifies whether or not you can connect and run queries during @@ -2603,10 +2679,11 @@ include 'filename' - max_standby_archive_delay (integer) + max_standby_archive_delay (integer) max_standby_archive_delay configuration parameter + When Hot Standby is active, this parameter determines how long the @@ -2633,10 +2710,11 @@ include 'filename' - max_standby_streaming_delay (integer) + max_standby_streaming_delay (integer) max_standby_streaming_delay configuration parameter + When Hot Standby is active, this parameter determines how long the @@ -2664,10 +2742,11 @@ include 'filename' - wal_receiver_status_interval (integer) + wal_receiver_status_interval (integer) wal_receiver_status_interval configuration parameter + Specifies the minimum frequency for the WAL receiver @@ -2690,10 +2769,11 @@ include 'filename' - hot_standby_feedback (boolean) + hot_standby_feedback (boolean) hot_standby_feedback configuration parameter + Specifies whether or not a hot standby will send feedback to the primary @@ -2715,10 +2795,11 @@ include 'filename' - wal_receiver_timeout (integer) + wal_receiver_timeout (integer) wal_receiver_timeout configuration parameter + Terminate replication connections that are inactive longer @@ -2763,13 +2844,14 @@ include 'filename' - enable_bitmapscan (boolean) + enable_bitmapscan (boolean) bitmap scan enable_bitmapscan configuration parameter + Enables or disables the query planner's use of bitmap-scan plan @@ -2779,10 +2861,11 @@ include 'filename' - enable_hashagg (boolean) + enable_hashagg (boolean) enable_hashagg configuration parameter + Enables or disables the query planner's use of hashed @@ -2792,10 +2875,11 @@ include 'filename' - enable_hashjoin (boolean) + enable_hashjoin (boolean) enable_hashjoin configuration parameter + Enables or disables the query planner's use of hash-join plan @@ -2805,13 +2889,14 @@ include 'filename' - enable_indexscan (boolean) + enable_indexscan (boolean) index scan enable_indexscan configuration parameter + Enables or disables the query planner's use of index-scan plan @@ -2821,13 +2906,14 @@ include 'filename' - enable_indexonlyscan (boolean) + enable_indexonlyscan (boolean) index-only scan enable_indexonlyscan configuration parameter + Enables or disables the query planner's use of index-only-scan plan @@ -2837,10 +2923,11 @@ include 'filename' - enable_material (boolean) + enable_material (boolean) enable_material configuration parameter + Enables or disables the query planner's use of materialization. @@ -2853,10 +2940,11 @@ include 'filename' - enable_mergejoin (boolean) + enable_mergejoin (boolean) enable_mergejoin configuration parameter + Enables or disables the query planner's use of merge-join plan @@ -2866,10 +2954,11 @@ include 'filename' - enable_nestloop (boolean) + enable_nestloop (boolean) enable_nestloop configuration parameter + Enables or disables the query planner's use of nested-loop join @@ -2882,13 +2971,14 @@ include 'filename' - enable_seqscan (boolean) + enable_seqscan (boolean) sequential scan enable_seqscan configuration parameter + Enables or disables the query planner's use of sequential scan @@ -2901,10 +2991,11 @@ include 'filename' - enable_sort (boolean) + enable_sort (boolean) enable_sort configuration parameter + Enables or disables the query planner's use of explicit sort @@ -2917,10 +3008,11 @@ include 'filename' - enable_tidscan (boolean) + enable_tidscan (boolean) enable_tidscan configuration parameter + Enables or disables the query planner's use of TID @@ -2959,10 +3051,11 @@ include 'filename' - seq_page_cost (floating point) + seq_page_cost (floating point) seq_page_cost configuration parameter + Sets the planner's estimate of the cost of a disk page fetch @@ -2975,10 +3068,11 @@ include 'filename' - random_page_cost (floating point) + random_page_cost (floating point) random_page_cost configuration parameter + Sets the planner's estimate of the cost of a @@ -3033,10 +3127,11 @@ include 'filename' - cpu_tuple_cost (floating point) + cpu_tuple_cost (floating point) cpu_tuple_cost configuration parameter + Sets the planner's estimate of the cost of processing @@ -3047,10 +3142,11 @@ include 'filename' - cpu_index_tuple_cost (floating point) + cpu_index_tuple_cost (floating point) cpu_index_tuple_cost configuration parameter + Sets the planner's estimate of the cost of processing @@ -3061,10 +3157,11 @@ include 'filename' - cpu_operator_cost (floating point) + cpu_operator_cost (floating point) cpu_operator_cost configuration parameter + Sets the planner's estimate of the cost of processing each @@ -3075,10 +3172,11 @@ include 'filename' - effective_cache_size (integer) + effective_cache_size (integer) effective_cache_size configuration parameter + Sets the planner's assumption about the effective size of the @@ -3128,7 +3226,7 @@ include 'filename' - geqo (boolean) + geqo (boolean) genetic query optimization @@ -3139,6 +3237,7 @@ include 'filename' geqo configuration parameter + Enables or disables genetic query optimization. @@ -3150,10 +3249,11 @@ include 'filename' - geqo_threshold (integer) + geqo_threshold (integer) geqo_threshold configuration parameter + Use genetic query optimization to plan queries with at least @@ -3170,11 +3270,11 @@ include 'filename' - geqo_effort - (integer) + geqo_effort (integer) geqo_effort configuration parameter + Controls the trade-off between planning time and query plan @@ -3196,10 +3296,11 @@ include 'filename' - geqo_pool_size (integer) + geqo_pool_size (integer) geqo_pool_size configuration parameter + Controls the pool size used by GEQO, that is the @@ -3213,10 +3314,11 @@ include 'filename' - geqo_generations (integer) + geqo_generations (integer) geqo_generations configuration parameter + Controls the number of generations used by GEQO, that is @@ -3230,10 +3332,11 @@ include 'filename' - geqo_selection_bias (floating point) + geqo_selection_bias (floating point) geqo_selection_bias configuration parameter + Controls the selection bias used by GEQO. The selection bias @@ -3244,10 +3347,11 @@ include 'filename' - geqo_seed (floating point) + geqo_seed (floating point) geqo_seed configuration parameter + Controls the initial value of the random number generator used @@ -3267,10 +3371,11 @@ include 'filename' - default_statistics_target (integer) + default_statistics_target (integer) default_statistics_target configuration parameter + Sets the default statistics target for table columns without @@ -3285,13 +3390,14 @@ include 'filename' - constraint_exclusion (enum) + constraint_exclusion (enum) constraint exclusion constraint_exclusion configuration parameter + Controls the query planner's use of table constraints to @@ -3341,10 +3447,11 @@ SELECT * FROM parent WHERE key = 2400; - cursor_tuple_fraction (floating point) + cursor_tuple_fraction (floating point) cursor_tuple_fraction configuration parameter + Sets the planner's estimate of the fraction of a cursor's rows that @@ -3361,10 +3468,11 @@ SELECT * FROM parent WHERE key = 2400; - from_collapse_limit (integer) + from_collapse_limit (integer) from_collapse_limit configuration parameter + The planner will merge sub-queries into upper queries if the @@ -3383,10 +3491,11 @@ SELECT * FROM parent WHERE key = 2400; - join_collapse_limit (integer) + join_collapse_limit (integer) join_collapse_limit configuration parameter + The planner will rewrite explicit JOIN @@ -3438,10 +3547,11 @@ SELECT * FROM parent WHERE key = 2400; - log_destination (string) + log_destination (string) log_destination configuration parameter + PostgreSQL supports several methods @@ -3495,10 +3605,11 @@ local0.* /var/log/postgresql - logging_collector (boolean) + logging_collector (boolean) logging_collector configuration parameter + This parameter enables the logging collector, which @@ -3541,10 +3652,11 @@ local0.* /var/log/postgresql - log_directory (string) + log_directory (string) log_directory configuration parameter + When logging_collector is enabled, @@ -3558,10 +3670,11 @@ local0.* /var/log/postgresql - log_filename (string) + log_filename (string) log_filename configuration parameter + When logging_collector is enabled, @@ -3605,10 +3718,11 @@ local0.* /var/log/postgresql - log_file_mode (integer) + log_file_mode (integer) log_file_mode configuration parameter + On Unix systems this parameter sets the permissions for log files @@ -3638,10 +3752,11 @@ local0.* /var/log/postgresql - log_rotation_age (integer) + log_rotation_age (integer) log_rotation_age configuration parameter + When logging_collector is enabled, @@ -3656,10 +3771,11 @@ local0.* /var/log/postgresql - log_rotation_size (integer) + log_rotation_size (integer) log_rotation_size configuration parameter + When logging_collector is enabled, @@ -3674,10 +3790,11 @@ local0.* /var/log/postgresql - log_truncate_on_rotation (boolean) + log_truncate_on_rotation (boolean) log_truncate_on_rotation configuration parameter + When logging_collector is enabled, @@ -3716,10 +3833,11 @@ local0.* /var/log/postgresql - syslog_facility (enum) + syslog_facility (enum) syslog_facility configuration parameter + When logging to syslog is enabled, this parameter @@ -3738,10 +3856,11 @@ local0.* /var/log/postgresql - syslog_ident (string) + syslog_ident (string) syslog_ident configuration parameter + When logging to syslog is enabled, this parameter @@ -3756,10 +3875,11 @@ local0.* /var/log/postgresql - event_source (string) + event_source (string) event_source configuration parameter + When logging to event log is enabled, this parameter @@ -3780,10 +3900,11 @@ local0.* /var/log/postgresql - client_min_messages (enum) + client_min_messages (enum) client_min_messages configuration parameter + Controls which message levels are sent to the client. @@ -3801,10 +3922,11 @@ local0.* /var/log/postgresql - log_min_messages (enum) + log_min_messages (enum) log_min_messages configuration parameter + Controls which message levels are written to the server log. @@ -3823,10 +3945,11 @@ local0.* /var/log/postgresql - log_min_error_statement (enum) + log_min_error_statement (enum) log_min_error_statement configuration parameter + Controls which SQL statements that cause an error @@ -3850,10 +3973,11 @@ local0.* /var/log/postgresql - log_min_duration_statement (integer) + log_min_duration_statement (integer) log_min_duration_statement configuration parameter + Causes the duration of each completed statement to be logged @@ -3985,10 +4109,11 @@ local0.* /var/log/postgresql - application_name (string) + application_name (string) application_name configuration parameter + The application_name can be any string of less than @@ -4005,18 +4130,21 @@ local0.* /var/log/postgresql - debug_print_parse (boolean) - debug_print_rewritten (boolean) - debug_print_plan (boolean) + debug_print_parse (boolean) debug_print_parse configuration parameter + + debug_print_rewritten (boolean) debug_print_rewritten configuration parameter + + debug_print_plan (boolean) debug_print_plan configuration parameter + These parameters enable various debugging output to be emitted. @@ -4033,10 +4161,11 @@ local0.* /var/log/postgresql - debug_pretty_print (boolean) + debug_pretty_print (boolean) debug_pretty_print configuration parameter + When set, debug_pretty_print indents the messages @@ -4050,10 +4179,11 @@ local0.* /var/log/postgresql - log_checkpoints (boolean) + log_checkpoints (boolean) log_checkpoints configuration parameter + Causes checkpoints and restartpoints to be logged in the server log. @@ -4066,10 +4196,11 @@ local0.* /var/log/postgresql - log_connections (boolean) + log_connections (boolean) log_connections configuration parameter + Causes each attempted connection to the server to be logged, @@ -4090,10 +4221,11 @@ local0.* /var/log/postgresql - log_disconnections (boolean) + log_disconnections (boolean) log_disconnections configuration parameter + This outputs a line in the server log similar to @@ -4107,10 +4239,11 @@ local0.* /var/log/postgresql - log_duration (boolean) + log_duration (boolean) log_duration configuration parameter + Causes the duration of every completed statement to be logged. @@ -4140,10 +4273,11 @@ local0.* /var/log/postgresql - log_error_verbosity (enum) + log_error_verbosity (enum) log_error_verbosity configuration parameter + Controls the amount of detail written in the server log for each @@ -4161,10 +4295,11 @@ local0.* /var/log/postgresql - log_hostname (boolean) + log_hostname (boolean) log_hostname configuration parameter + By default, connection log messages only show the IP address of the @@ -4178,10 +4313,11 @@ local0.* /var/log/postgresql - log_line_prefix (string) + log_line_prefix (string) log_line_prefix configuration parameter + This is a printf-style string that is output at the @@ -4336,10 +4472,11 @@ FROM pg_stat_activity; - log_lock_waits (boolean) + log_lock_waits (boolean) log_lock_waits configuration parameter + Controls whether a log message is produced when a session waits @@ -4351,10 +4488,11 @@ FROM pg_stat_activity; - log_statement (enum) + log_statement (enum) log_statement configuration parameter + Controls which SQL statements are logged. Valid values are @@ -4395,10 +4533,11 @@ FROM pg_stat_activity; - log_temp_files (integer) + log_temp_files (integer) log_temp_files configuration parameter + Controls logging of temporary file names and sizes. @@ -4415,10 +4554,11 @@ FROM pg_stat_activity; - log_timezone (string) + log_timezone (string) log_timezone configuration parameter + Sets the time zone used for timestamps written in the server log. @@ -4579,10 +4719,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_activities (boolean) + track_activities (boolean) track_activities configuration parameter + Enables the collection of information on the currently @@ -4598,10 +4739,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_activity_query_size (integer) + track_activity_query_size (integer) track_activity_query_size configuration parameter + Specifies the number of bytes reserved to track the currently @@ -4614,10 +4756,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_counts (boolean) + track_counts (boolean) track_counts configuration parameter + Enables collection of statistics on database activity. @@ -4629,10 +4772,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_io_timing (boolean) + track_io_timing (boolean) track_io_timing configuration parameter + Enables timing of database I/O calls. This parameter is off by @@ -4650,10 +4794,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_functions (enum) + track_functions (enum) track_functions configuration parameter + Enables tracking of function call counts and time used. Specify @@ -4674,10 +4819,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - update_process_title (boolean) + update_process_title (boolean) update_process_title configuration parameter + Enables updating of the process title every time a new SQL command @@ -4690,10 +4836,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - stats_temp_directory (string) + stats_temp_directory (string) stats_temp_directory configuration parameter + Sets the directory to store temporary statistics data in. This can be @@ -4715,22 +4862,26 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - log_statement_stats (boolean) - log_parser_stats (boolean) - log_planner_stats (boolean) - log_executor_stats (boolean) + log_statement_stats (boolean) log_statement_stats configuration parameter + + log_parser_stats (boolean) log_parser_stats configuration parameter + + log_planner_stats (boolean) log_planner_stats configuration parameter + + log_executor_stats (boolean) log_executor_stats configuration parameter + For each query, output performance statistics of the respective @@ -4767,10 +4918,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum (boolean) + autovacuum (boolean) autovacuum configuration parameter + Controls whether the server should run the @@ -4790,10 +4942,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - log_autovacuum_min_duration (integer) + log_autovacuum_min_duration (integer) log_autovacuum_min_duration configuration parameter + Causes each action executed by autovacuum to be logged if it ran for at @@ -4812,10 +4965,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_max_workers (integer) + autovacuum_max_workers (integer) autovacuum_max_workers configuration parameter + Specifies the maximum number of autovacuum processes (other than the @@ -4826,10 +4980,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_naptime (integer) + autovacuum_naptime (integer) autovacuum_naptime configuration parameter + Specifies the minimum delay between autovacuum runs on any given @@ -4844,10 +4999,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_threshold (integer) + autovacuum_vacuum_threshold (integer) autovacuum_vacuum_threshold configuration parameter + Specifies the minimum number of updated or deleted tuples needed @@ -4862,10 +5018,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_analyze_threshold (integer) + autovacuum_analyze_threshold (integer) autovacuum_analyze_threshold configuration parameter + Specifies the minimum number of inserted, updated or deleted tuples @@ -4880,10 +5037,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_scale_factor (floating point) + autovacuum_vacuum_scale_factor (floating point) autovacuum_vacuum_scale_factor configuration parameter + Specifies a fraction of the table size to add to @@ -4899,10 +5057,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_analyze_scale_factor (floating point) + autovacuum_analyze_scale_factor (floating point) autovacuum_analyze_scale_factor configuration parameter + Specifies a fraction of the table size to add to @@ -4918,10 +5077,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_freeze_max_age (integer) + autovacuum_freeze_max_age (integer) autovacuum_freeze_max_age configuration parameter + Specifies the maximum age (in transactions) that a table's @@ -4945,10 +5105,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_multixact_freeze_max_age (integer) + autovacuum_multixact_freeze_max_age (integer) autovacuum_multixact_freeze_max_age configuration parameter + Specifies the maximum age (in multixacts) that a table's @@ -4972,10 +5133,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_cost_delay (integer) + autovacuum_vacuum_cost_delay (integer) autovacuum_vacuum_cost_delay configuration parameter + Specifies the cost delay value that will be used in automatic @@ -4991,10 +5153,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_cost_limit (integer) + autovacuum_vacuum_cost_limit (integer) autovacuum_vacuum_cost_limit configuration parameter + Specifies the cost limit value that will be used in automatic @@ -5023,11 +5186,12 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - search_path (string) + search_path (string) search_path configuration parameter pathfor schemas + This variable specifies the order in which schemas are searched @@ -5108,11 +5272,12 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - default_tablespace (string) + default_tablespace (string) default_tablespace configuration parameter tablespacedefault + This variable specifies the default tablespace in which to create @@ -5149,11 +5314,12 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - temp_tablespaces (string) + temp_tablespaces (string) temp_tablespaces configuration parameter tablespacetemporary + This variable specifies tablespaces in which to create temporary @@ -5197,10 +5363,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - check_function_bodies (boolean) + check_function_bodies (boolean) check_function_bodies configuration parameter + This parameter is normally on. When set to off, it @@ -5215,7 +5382,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - default_transaction_isolation (enum) + default_transaction_isolation (enum) transaction isolation level setting default @@ -5223,6 +5390,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; default_transaction_isolation configuration parameter + Each SQL transaction has an isolation level, which can be @@ -5241,7 +5409,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - default_transaction_read_only (boolean) + default_transaction_read_only (boolean) read-only transaction setting default @@ -5249,6 +5417,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; default_transaction_read_only configuration parameter + A read-only SQL transaction cannot alter non-temporary tables. @@ -5263,7 +5432,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - default_transaction_deferrable (boolean) + default_transaction_deferrable (boolean) deferrable transaction setting default @@ -5271,6 +5440,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; default_transaction_deferrable configuration parameter + When running at the serializable isolation level, @@ -5297,10 +5467,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - session_replication_role (enum) + session_replication_role (enum) session_replication_role configuration parameter + Controls firing of replication-related triggers and rules for the @@ -5315,10 +5486,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - statement_timeout (integer) + statement_timeout (integer) statement_timeout configuration parameter + Abort any statement that takes more than the specified number of @@ -5337,10 +5509,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - lock_timeout (integer) + lock_timeout (integer) lock_timeout configuration parameter + Abort any statement that waits longer than the specified number of @@ -5371,10 +5544,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_freeze_table_age (integer) + vacuum_freeze_table_age (integer) vacuum_freeze_table_age configuration parameter + VACUUM performs a whole-table scan if the table's @@ -5392,10 +5566,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_freeze_min_age (integer) + vacuum_freeze_min_age (integer) vacuum_freeze_min_age configuration parameter + Specifies the cutoff age (in transactions) that VACUUM @@ -5413,10 +5588,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_multixact_freeze_table_age (integer) + vacuum_multixact_freeze_table_age (integer) vacuum_multixact_freeze_table_age configuration parameter + VACUUM performs a whole-table scan if the table's @@ -5433,10 +5609,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_multixact_freeze_min_age (integer) + vacuum_multixact_freeze_min_age (integer) vacuum_multixact_freeze_min_age configuration parameter + Specifies the cutoff age (in multixacts) that VACUUM @@ -5454,10 +5631,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - bytea_output (enum) + bytea_output (enum) bytea_output configuration parameter + Sets the output format for values of type bytea. @@ -5471,10 +5649,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - xmlbinary (enum) + xmlbinary (enum) xmlbinary configuration parameter + Sets how binary values are to be encoded in XML. This applies @@ -5498,7 +5677,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - xmloption (enum) + xmloption (enum) xmloption configuration parameter @@ -5508,6 +5687,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; XML option + Sets whether DOCUMENT or @@ -5537,10 +5717,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - DateStyle (string) + DateStyle (string) DateStyle configuration parameter + Sets the display format for date and time values, as well as the @@ -5564,10 +5745,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - IntervalStyle (enum) + IntervalStyle (enum) IntervalStyle configuration parameter + Sets the display format for interval values. @@ -5594,11 +5776,12 @@ SET XML OPTION { DOCUMENT | CONTENT }; - TimeZone (string) + TimeZone (string) TimeZone configuration parameter time zone + Sets the time zone for displaying and interpreting time stamps. @@ -5611,11 +5794,12 @@ SET XML OPTION { DOCUMENT | CONTENT }; - timezone_abbreviations (string) + timezone_abbreviations (string) timezone_abbreviations configuration parameter time zone names + Sets the collection of time zone abbreviations that will be accepted @@ -5629,7 +5813,7 @@ SET XML OPTION { DOCUMENT | CONTENT }; - extra_float_digits (integer) + extra_float_digits (integer) significant digits @@ -5640,6 +5824,7 @@ SET XML OPTION { DOCUMENT | CONTENT }; extra_float_digits configuration parameter + This parameter adjusts the number of digits displayed for @@ -5656,11 +5841,12 @@ SET XML OPTION { DOCUMENT | CONTENT }; - client_encoding (string) + client_encoding (string) client_encoding configuration parameter character set + Sets the client-side encoding (character set). @@ -5672,10 +5858,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - lc_messages (string) + lc_messages (string) lc_messages configuration parameter + Sets the language in which messages are displayed. Acceptable @@ -5703,10 +5890,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - lc_monetary (string) + lc_monetary (string) lc_monetary configuration parameter + Sets the locale to use for formatting monetary amounts, for @@ -5721,10 +5909,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - lc_numeric (string) + lc_numeric (string) lc_numeric configuration parameter + Sets the locale to use for formatting numbers, for example @@ -5739,10 +5928,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - lc_time (string) + lc_time (string) lc_time configuration parameter + Sets the locale to use for formatting dates and times, for example @@ -5757,10 +5947,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - default_text_search_config (string) + default_text_search_config (string) default_text_search_config configuration parameter + Selects the text search configuration that is used by those variants @@ -5824,13 +6015,14 @@ SET XML OPTION { DOCUMENT | CONTENT }; - local_preload_libraries (string) + local_preload_libraries (string) local_preload_libraries configuration parameter $libdir/plugins + This variable specifies one or more shared libraries that are to be @@ -5862,10 +6054,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - session_preload_libraries (string) + session_preload_libraries (string) session_preload_libraries configuration parameter + This variable specifies one or more shared libraries that are to be @@ -5898,10 +6091,11 @@ SET XML OPTION { DOCUMENT | CONTENT }; - shared_preload_libraries (string) + shared_preload_libraries (string) shared_preload_libraries configuration parameter + This variable specifies one or more shared libraries to be preloaded at @@ -5950,11 +6144,12 @@ SET XML OPTION { DOCUMENT | CONTENT }; - dynamic_library_path (string) + dynamic_library_path (string) dynamic_library_path configuration parameter dynamic loading + If a dynamically loadable module needs to be opened and the @@ -6003,10 +6198,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - gin_fuzzy_search_limit (integer) + gin_fuzzy_search_limit (integer) gin_fuzzy_search_limit configuration parameter + Soft upper limit of the size of the set returned by GIN index scans. For more @@ -6025,7 +6221,7 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - deadlock_timeout (integer) + deadlock_timeout (integer) deadlock timeout during @@ -6037,6 +6233,7 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' deadlock_timeout configuration parameter + This is the amount of time, in milliseconds, to wait on a lock @@ -6067,10 +6264,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - max_locks_per_transaction (integer) + max_locks_per_transaction (integer) max_locks_per_transaction configuration parameter + The shared lock table tracks locks on @@ -6098,10 +6296,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - max_pred_locks_per_transaction (integer) + max_pred_locks_per_transaction (integer) max_pred_locks_per_transaction configuration parameter + The shared predicate lock table tracks locks on @@ -6135,10 +6334,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - array_nulls (boolean) + array_nulls (boolean) array_nulls configuration parameter + This controls whether the array input parser recognizes @@ -6160,11 +6360,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - backslash_quote (enum) + backslash_quote (enum) stringsbackslash quotes backslash_quote configuration parameter + This controls whether a quote mark can be represented by @@ -6196,10 +6397,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - default_with_oids (boolean) + default_with_oids (boolean) default_with_oids configuration parameter + This controls whether CREATE TABLE and @@ -6224,11 +6426,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - escape_string_warning (boolean) + escape_string_warning (boolean) stringsescape warning escape_string_warning configuration parameter + When on, a warning is issued if a backslash (\) @@ -6247,10 +6450,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - lo_compat_privileges (boolean) + lo_compat_privileges (boolean) lo_compat_privileges configuration parameter + In PostgreSQL releases prior to 9.0, large objects @@ -6272,10 +6476,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - quote_all_identifiers (boolean) + quote_all_identifiers (boolean) quote_all_identifiers configuration parameter + When the database generates SQL, force all identifiers to be quoted, @@ -6289,11 +6494,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - sql_inheritance (boolean) + sql_inheritance (boolean) sql_inheritance configuration parameter inheritance + This setting controls whether undecorated table references are @@ -6318,11 +6524,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - standard_conforming_strings (boolean) + standard_conforming_strings (boolean) stringsstandard conforming standard_conforming_strings configuration parameter + This controls whether ordinary string literals @@ -6342,10 +6549,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - synchronize_seqscans (boolean) + synchronize_seqscans (boolean) synchronize_seqscans configuration parameter + This allows sequential scans of large tables to synchronize with each @@ -6371,11 +6579,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - transform_null_equals (boolean) + transform_null_equals (boolean) IS NULL transform_null_equals configuration parameter + When on, expressions of the form expr = @@ -6427,10 +6636,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - exit_on_error (boolean) + exit_on_error (boolean) exit_on_error configuration parameter + If true, any error will terminate the current session. By default, @@ -6441,10 +6651,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - restart_after_crash (boolean) + restart_after_crash (boolean) restart_after_crash configuration parameter + When set to true, which is the default, PostgreSQL @@ -6478,10 +6689,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - block_size (integer) + block_size (integer) block_size configuration parameter + Reports the size of a disk block. It is determined by the value @@ -6495,10 +6707,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - data_checksums (boolean) + data_checksums (boolean) data_checksums configuration parameter + Reports whether data checksums are enabled for this cluster. @@ -6508,10 +6721,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - integer_datetimes (boolean) + integer_datetimes (boolean) integer_datetimes configuration parameter + Reports whether PostgreSQL was built with @@ -6524,10 +6738,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - lc_collate (string) + lc_collate (string) lc_collate configuration parameter + Reports the locale in which sorting of textual data is done. @@ -6538,10 +6753,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - lc_ctype (string) + lc_ctype (string) lc_ctype configuration parameter + Reports the locale that determines character classifications. @@ -6554,10 +6770,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - max_function_args (integer) + max_function_args (integer) max_function_args configuration parameter + Reports the maximum number of function arguments. It is determined by @@ -6568,10 +6785,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - max_identifier_length (integer) + max_identifier_length (integer) max_identifier_length configuration parameter + Reports the maximum identifier length. It is determined as one @@ -6585,10 +6803,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - max_index_keys (integer) + max_index_keys (integer) max_index_keys configuration parameter + Reports the maximum number of index keys. It is determined by @@ -6599,10 +6818,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - segment_size (integer) + segment_size (integer) segment_size configuration parameter + Reports the number of blocks (pages) that can be stored within a file @@ -6615,11 +6835,12 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - server_encoding (string) + server_encoding (string) server_encoding configuration parameter character set + Reports the database encoding (character set). @@ -6631,10 +6852,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - server_version (string) + server_version (string) server_version configuration parameter + Reports the version number of the server. It is determined by the @@ -6644,10 +6866,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - server_version_num (integer) + server_version_num (integer) server_version_num configuration parameter + Reports the version number of the server as an integer. It is determined @@ -6657,10 +6880,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - wal_block_size (integer) + wal_block_size (integer) wal_block_size configuration parameter + Reports the size of a WAL disk block. It is determined by the value @@ -6671,10 +6895,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - wal_segment_size (integer) + wal_segment_size (integer) wal_segment_size configuration parameter + Reports the number of blocks (pages) in a WAL segment file. @@ -6732,10 +6957,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - allow_system_table_mods (boolean) + allow_system_table_mods (boolean) allow_system_table_mods configuration parameter + Allows modification of the structure of system tables. @@ -6746,10 +6972,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - debug_assertions (boolean) + debug_assertions (boolean) debug_assertions configuration parameter + Turns on various assertion checks. This is a debugging aid. If @@ -6767,10 +6994,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - ignore_system_indexes (boolean) + ignore_system_indexes (boolean) ignore_system_indexes configuration parameter + Ignore system indexes when reading system tables (but still @@ -6782,10 +7010,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - post_auth_delay (integer) + post_auth_delay (integer) post_auth_delay configuration parameter + If nonzero, a delay of this many seconds occurs when a new @@ -6798,10 +7027,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - pre_auth_delay (integer) + pre_auth_delay (integer) pre_auth_delay configuration parameter + If nonzero, a delay of this many seconds occurs just after a @@ -6816,10 +7046,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - trace_notify (boolean) + trace_notify (boolean) trace_notify configuration parameter + Generates a great amount of debugging output for the @@ -6833,10 +7064,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - trace_recovery_messages (enum) + trace_recovery_messages (enum) trace_recovery_messages configuration parameter + Enables logging of recovery-related debugging output that otherwise @@ -6858,10 +7090,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - trace_sort (boolean) + trace_sort (boolean) trace_sort configuration parameter + If on, emit information about resource usage during sort operations. @@ -6873,10 +7106,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - trace_locks (boolean) + trace_locks (boolean) trace_locks configuration parameter + If on, emit information about lock usage. Information dumped @@ -6913,10 +7147,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - trace_lwlocks (boolean) + trace_lwlocks (boolean) trace_lwlocks configuration parameter + If on, emit information about lightweight lock usage. Lightweight @@ -6932,10 +7167,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - trace_userlocks (boolean) + trace_userlocks (boolean) trace_userlocks configuration parameter + If on, emit information about user lock usage. Output is the same @@ -6950,10 +7186,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - trace_lock_oidmin (integer) + trace_lock_oidmin (integer) trace_lock_oidmin configuration parameter + If set, do not trace locks for tables below this OID. (use to avoid @@ -6968,10 +7205,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - trace_lock_table (integer) + trace_lock_table (integer) trace_lock_table configuration parameter + Unconditionally trace locks on this table (OID). @@ -6985,10 +7223,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - debug_deadlocks (boolean) + debug_deadlocks (boolean) debug_deadlocks configuration parameter + If set, dumps information about all current locks when a @@ -7003,10 +7242,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - log_btree_build_stats (boolean) + log_btree_build_stats (boolean) log_btree_build_stats configuration parameter + If set, logs system resource usage statistics (memory and CPU) on @@ -7021,10 +7261,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - wal_debug (boolean) + wal_debug (boolean) wal_debug configuration parameter + If on, emit WAL-related debugging output. This parameter is @@ -7036,10 +7277,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - ignore_checksum_failure (boolean) + ignore_checksum_failure (boolean) ignore_checksum_failure configuration parameter + Only has effect if are enabled. @@ -7060,10 +7302,11 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1) - zero_damaged_pages (boolean) + zero_damaged_pages (boolean) zero_damaged_pages configuration parameter + Detection of a damaged page header normally causes diff --git a/doc/src/sgml/dfunc.sgml b/doc/src/sgml/dfunc.sgml index c24ed37421..3d90a36e52 100644 --- a/doc/src/sgml/dfunc.sgml +++ b/doc/src/sgml/dfunc.sgml @@ -56,8 +56,10 @@ - FreeBSD - FreeBSDshared library + + FreeBSD + FreeBSDshared library + The compiler flag to create PIC is @@ -74,8 +76,10 @@ gcc -shared -o foo.so foo.o - HP-UX - HP-UXshared library + + HP-UX + HP-UXshared library + The compiler flag of the system compiler to create @@ -101,8 +105,10 @@ ld -b -o foo.sl foo.o - Linux - Linuxshared library + + Linux + Linuxshared library + The compiler flag to create PIC is @@ -120,8 +126,10 @@ cc -shared -o foo.so foo.o - Mac OS X - Mac OS Xshared library + + Mac OS X + Mac OS Xshared library + Here is an example. It assumes the developer tools are installed. @@ -134,8 +142,10 @@ cc -bundle -flat_namespace -undefined suppress -o foo.so foo.o - NetBSD - NetBSDshared library + + NetBSD + NetBSDshared library + The compiler flag to create PIC is @@ -152,8 +162,10 @@ gcc -shared -o foo.so foo.o - OpenBSD - OpenBSDshared library + + OpenBSD + OpenBSDshared library + The compiler flag to create PIC is @@ -168,8 +180,10 @@ ld -Bshareable -o foo.so foo.o - Solaris - Solarisshared library + + Solaris + Solarisshared library + The compiler flag to create PIC is @@ -192,9 +206,11 @@ gcc -G -o foo.so foo.o - Tru64 UNIX - Tru64 UNIXshared library - Digital UNIXTru64 UNIX + + Tru64 UNIX + Tru64 UNIXshared library + Digital UNIXTru64 UNIX + PIC is the default, so the compilation command @@ -211,8 +227,10 @@ ld -shared -expect_unresolved '*' -o foo.so foo.o - UnixWare - UnixWareshared library + + UnixWare + UnixWareshared library + The compiler flag to create PIC is + OpenSSL SSL - - + Build with support for SSL (encrypted) @@ -1070,10 +1070,11 @@ su - postgres - + time zone data + PostgreSQL includes its own time zone database, diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 1f0975ada6..e10ccec9f1 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -2609,11 +2609,13 @@ char *PQresultErrorField(const PGresult *res, int fieldcode); - PG_DIAG_SQLSTATE + + PG_DIAG_SQLSTATE error codes libpq + The SQLSTATE code for the error. The SQLSTATE code identifies diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 9cbd12c416..549f2bc9f5 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -164,10 +164,10 @@ CTRL-C Logical Decoding Concepts + Logical Decoding Logical Decoding - Logical Decoding Logical decoding is the process of extracting all persistent changes to a database's tables into a coherent, easy to understand format which diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index f4138558b2..9232183896 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -18,11 +18,11 @@ - - get_raw_page - get_raw_page(relname text, fork text, blkno int) returns bytea + + get_raw_page + @@ -52,11 +52,11 @@ - - page_header - page_header(page bytea) returns record + + page_header + @@ -82,11 +82,11 @@ test=# SELECT * FROM page_header(get_raw_page('pg_class', 0)); - - heap_page_items - heap_page_items(page bytea) returns setof record + + heap_page_items + @@ -110,11 +110,11 @@ test=# SELECT * FROM heap_page_items(get_raw_page('pg_class', 0)); - - bt_metap - bt_metap(relname text) returns record + + bt_metap + @@ -136,11 +136,11 @@ fastlevel | 0 - - bt_page_stats - bt_page_stats(relname text, blkno int) returns record + + bt_page_stats + @@ -167,11 +167,11 @@ btpo_flags | 3 - - bt_page_items - bt_page_items(relname text, blkno int) returns setof record + + bt_page_items + @@ -196,11 +196,11 @@ test=# SELECT * FROM bt_page_items('pg_cast_oid_index', 1); - - fsm_page_contents - fsm_page_contents(page bytea) returns text + + fsm_page_contents + diff --git a/doc/src/sgml/pgfreespacemap.sgml b/doc/src/sgml/pgfreespacemap.sgml index 7e070f1500..f2f99d571e 100644 --- a/doc/src/sgml/pgfreespacemap.sgml +++ b/doc/src/sgml/pgfreespacemap.sgml @@ -25,11 +25,11 @@ - - pg_freespace - pg_freespace(rel regclass IN, blkno bigint IN) returns int2 + + pg_freespace + diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index d39f5a03ca..db6b10abc4 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -279,12 +279,11 @@ - - pg_stat_statements_reset - - pg_stat_statements_reset() returns void + + pg_stat_statements_reset + @@ -297,13 +296,12 @@ - - pg_stat_statements - function - - pg_stat_statements(showtext boolean) returns setof record + + pg_stat_statements + function + diff --git a/doc/src/sgml/pgstattuple.sgml b/doc/src/sgml/pgstattuple.sgml index 81eeef302e..9cabd71166 100644 --- a/doc/src/sgml/pgstattuple.sgml +++ b/doc/src/sgml/pgstattuple.sgml @@ -17,11 +17,10 @@ - - pgstattuple - - + + pgstattuple + pgstattuple(regclass) returns record diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml index 34663e475f..9117769125 100644 --- a/doc/src/sgml/plperl.sgml +++ b/doc/src/sgml/plperl.sgml @@ -380,40 +380,13 @@ use strict; - - spi_exec_query - in PL/Perl - - - spi_query - in PL/Perl - - - spi_fetchrow - in PL/Perl - - - spi_prepare - in PL/Perl - - - spi_exec_prepared - in PL/Perl - - - spi_query_prepared - in PL/Perl - - - spi_cursor_close - in PL/Perl - - - spi_freeplan - in PL/Perl - - - spi_exec_query(query [, max-rows]) + + spi_exec_query(query [, max-rows]) + + spi_exec_query + in PL/Perl + + spi_exec_query executes an SQL command and @@ -490,9 +463,27 @@ SELECT * FROM test_munge(); - spi_query(command) - spi_fetchrow(cursor) - spi_cursor_close(cursor) + + spi_query(command) + + spi_query + in PL/Perl + + + + spi_fetchrow(cursor) + + spi_fetchrow + in PL/Perl + + + + spi_cursor_close(cursor) + + spi_cursor_close + in PL/Perl + + @@ -548,10 +539,34 @@ SELECT * from lotsa_md5(500); - spi_prepare(command, argument types) - spi_query_prepared(plan, arguments) - spi_exec_prepared(plan [, attributes], arguments) - spi_freeplan(plan) + + spi_prepare(command, argument types) + + spi_prepare + in PL/Perl + + + + spi_query_prepared(plan, arguments) + + spi_query_prepared + in PL/Perl + + + + spi_exec_prepared(plan [, attributes], arguments) + + spi_exec_prepared + in PL/Perl + + + + spi_freeplan(plan) + + spi_freeplan + in PL/Perl + + @@ -651,12 +666,13 @@ SELECT release_hosts_query(); - - elog - in PL/Perl - - - elog(level, msg) + + elog(level, msg) + + elog + in PL/Perl + + Emit a log or error message. Possible levels are @@ -680,12 +696,13 @@ SELECT release_hosts_query(); - - quote_literal - in PL/Perl - - - quote_literal(string) + + quote_literal(string) + + quote_literal + in PL/Perl + + Return the given string suitably quoted to be used as a string literal in an SQL @@ -697,12 +714,13 @@ SELECT release_hosts_query(); - - quote_nullable - in PL/Perl - - - quote_nullable(string) + + quote_nullable(string) + + quote_nullable + in PL/Perl + + Return the given string suitably quoted to be used as a string literal in an SQL @@ -713,12 +731,13 @@ SELECT release_hosts_query(); - - quote_ident - in PL/Perl - - - quote_ident(string) + + quote_ident(string) + + quote_ident + in PL/Perl + + Return the given string suitably quoted to be used as an identifier in @@ -730,12 +749,13 @@ SELECT release_hosts_query(); - - decode_bytea - in PL/Perl - - - decode_bytea(string) + + decode_bytea(string) + + decode_bytea + in PL/Perl + + Return the unescaped binary data represented by the contents of the given string, @@ -745,12 +765,13 @@ SELECT release_hosts_query(); - - encode_bytea - in PL/Perl - - - encode_bytea(string) + + encode_bytea(string) + + encode_bytea + in PL/Perl + + Return the bytea encoded form of the binary data contents of the given string. @@ -759,13 +780,16 @@ SELECT release_hosts_query(); - - encode_array_literal - in PL/Perl - - - encode_array_literal(array) - encode_array_literal(array, delimiter) + + encode_array_literal(array) + + encode_array_literal + in PL/Perl + + + + encode_array_literal(array, delimiter) + Returns the contents of the referenced array as a string in array literal format @@ -778,12 +802,13 @@ SELECT release_hosts_query(); - - encode_typed_literal - in PL/Perl - - - encode_typed_literal(value, typename) + + encode_typed_literal(value, typename) + + encode_typed_literal + in PL/Perl + + Converts a Perl variable to the value of the data type passed as a @@ -794,12 +819,13 @@ SELECT release_hosts_query(); - - encode_array_constructor - in PL/Perl - - - encode_array_constructor(array) + + encode_array_constructor(array) + + encode_array_constructor + in PL/Perl + + Returns the contents of the referenced array as a string in array constructor format @@ -812,12 +838,13 @@ SELECT release_hosts_query(); - - looks_like_number - in PL/Perl - - - looks_like_number(string) + + looks_like_number(string) + + looks_like_number + in PL/Perl + + Returns a true value if the content of the given string looks like a @@ -829,12 +856,13 @@ SELECT release_hosts_query(); - - is_array_ref - in PL/Perl - - - is_array_ref(argument) + + is_array_ref(argument) + + is_array_ref + in PL/Perl + + Returns a true value if the given argument may be treated as an @@ -1274,10 +1302,12 @@ CREATE EVENT TRIGGER perl_a_snitch - plperl.on_init (string) + + plperl.on_init (string) plperl.on_init configuration parameter + Specifies Perl code to be executed when a Perl interpreter is first @@ -1329,14 +1359,18 @@ DO 'elog(WARNING, join ", ", sort keys %INC)' LANGUAGE plperl; - plperl.on_plperl_init (string) - plperl.on_plperlu_init (string) - - plperl.on_plperl_init configuration parameter - - - plperl.on_plperlu_init configuration parameter - + + plperl.on_plperl_init (string) + + plperl.on_plperl_init configuration parameter + + + + plperl.on_plperlu_init (string) + + plperl.on_plperlu_init configuration parameter + + These parameters specify Perl code to be executed when a Perl @@ -1368,10 +1402,12 @@ DO 'elog(WARNING, join ", ", sort keys %INC)' LANGUAGE plperl; - plperl.use_strict (boolean) - - plperl.use_strict configuration parameter - + + plperl.use_strict (boolean) + + plperl.use_strict configuration parameter + + When set true subsequent compilations of PL/Perl functions will have diff --git a/doc/src/sgml/pltcl.sgml b/doc/src/sgml/pltcl.sgml index 80400fad7b..e47ad96de1 100644 --- a/doc/src/sgml/pltcl.sgml +++ b/doc/src/sgml/pltcl.sgml @@ -418,10 +418,13 @@ $$ LANGUAGE pltcl; - - spi_lastoid - - spi_lastoid + + spi_lastoid + + spi_lastoid + in PL/Tcl + + Returns the OID of the row inserted by the last @@ -478,11 +481,13 @@ SELECT 'doesn''t' AS ret - - elog - in PL/Tcl - - elog level msg + + elog level msg + + elog + in PL/Tcl + + Emits a log or error message. Possible levels are diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 36d16a557c..c37113cb35 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -1428,8 +1428,7 @@ The commands accepted in walsender mode are: - CREATE_REPLICATION_SLOT slotname PHYSICAL - CREATE_REPLICATION_SLOT + CREATE_REPLICATION_SLOT slotname PHYSICALCREATE_REPLICATION_SLOT Create a physical replication diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index daba74bd63..18faace5a1 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -167,8 +167,7 @@ FROM table_reference , table_r Join Types - Cross join - + Cross join join cross @@ -177,6 +176,7 @@ FROM table_reference , table_r cross join + @@ -206,8 +206,7 @@ FROM table_reference , table_r - Qualified joins - + Qualified joins join outer @@ -216,6 +215,7 @@ FROM table_reference , table_r outer join + @@ -297,8 +297,7 @@ FROM table_reference , table_r - LEFT OUTER JOIN - + LEFT OUTER JOIN join left @@ -307,6 +306,7 @@ FROM table_reference , table_r left join + @@ -320,8 +320,7 @@ FROM table_reference , table_r - RIGHT OUTER JOIN - + RIGHT OUTER JOIN join right @@ -330,6 +329,7 @@ FROM table_reference , table_r right join + diff --git a/doc/src/sgml/recovery-config.sgml b/doc/src/sgml/recovery-config.sgml index c9ed2dffb2..0e78d909b5 100644 --- a/doc/src/sgml/recovery-config.sgml +++ b/doc/src/sgml/recovery-config.sgml @@ -36,10 +36,11 @@ - restore_command (string) + restore_command (string) restore_command recovery parameter + The local shell command to execute to retrieve an archived segment of @@ -79,10 +80,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - archive_cleanup_command (string) + archive_cleanup_command (string) archive_cleanup_command recovery parameter + This optional parameter specifies a shell command that will be executed @@ -119,10 +121,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_end_command (string) + recovery_end_command (string) recovery_end_command recovery parameter + This parameter specifies a shell command that will be executed once only @@ -159,10 +162,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target = 'immediate' + recovery_target = 'immediate' recovery_target recovery parameter + This parameter specifies that recovery should end as soon as a @@ -178,12 +182,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_name - (string) - + recovery_target_name (string) recovery_target_name recovery parameter + This parameter specifies the named restore point, created with @@ -193,12 +196,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_time - (timestamp) - + recovery_target_time (timestamp) recovery_target_time recovery parameter + This parameter specifies the time stamp up to which recovery @@ -210,10 +212,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_xid (string) + recovery_target_xid (string) recovery_target_xid recovery parameter + This parameter specifies the transaction ID up to which recovery @@ -237,12 +240,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_inclusive - (boolean) - + recovery_target_inclusive (boolean) recovery_target_inclusive recovery parameter + Specifies whether we stop just after the specified recovery target @@ -259,12 +261,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_timeline - (string) - + recovery_target_timeline (string) recovery_target_timeline recovery parameter + Specifies recovering into a particular timeline. The default is @@ -281,12 +282,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - pause_at_recovery_target - (boolean) - + pause_at_recovery_target (boolean) pause_at_recovery_target recovery parameter + Specifies whether recovery should pause when the recovery target @@ -317,10 +317,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - standby_mode (boolean) + standby_mode (boolean) standby_mode recovery parameter + Specifies whether to start the PostgreSQL server as @@ -334,10 +335,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - primary_conninfo (string) + primary_conninfo (string) primary_conninfo recovery parameter + Specifies a connection string to be used for the standby server @@ -369,10 +371,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - primary_slotname (string) + primary_slotname (string) primary_slotname recovery parameter + Optionally specifies an existing replication slot to be used when @@ -385,10 +388,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - trigger_file (string) + trigger_file (string) trigger_file recovery parameter + Specifies a trigger file whose presence ends recovery in the @@ -400,10 +404,11 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - min_recovery_apply_delay (integer) + min_recovery_apply_delay (integer) min_recovery_apply_delay recovery parameter + By default, a standby server keeps restoring WAL records from the diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 43154da06c..69a1e14bce 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -227,12 +227,13 @@ ALTER TABLE [ IF EXISTS ] name - - TOAST - per-column storage settings - - - SET STORAGE + + SET STORAGE + + TOAST + per-column storage settings + + This form sets the storage mode for a column. This controls whether this diff --git a/doc/src/sgml/ref/pg_recvlogical.sgml b/doc/src/sgml/ref/pg_recvlogical.sgml index 41e5e838ad..4170c8ef9f 100644 --- a/doc/src/sgml/ref/pg_recvlogical.sgml +++ b/doc/src/sgml/ref/pg_recvlogical.sgml @@ -4,6 +4,10 @@ PostgreSQL documentation --> + + pg_recvlogical + + pg_recvlogical 1 @@ -16,10 +20,6 @@ PostgreSQL documentation streams over a walsender connection. - - pg_recvlogical - - pg_recvlogical diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index da79d7a90e..ee6ec3a811 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -2731,11 +2731,13 @@ bar - - autocommit - psql - - AUTOCOMMIT + + AUTOCOMMIT + + autocommit + psql + + When on (the default), each SQL command is automatically @@ -2971,11 +2973,13 @@ bar - - rollback - psql - - ON_ERROR_ROLLBACK + + ON_ERROR_ROLLBACK + + rollback + psql + + When on, if a statement in a transaction block diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml index a2a3baebd7..8e34fb0bf2 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -99,8 +99,8 @@ the range table - range table + The range table is a list of relations that are used in the query. @@ -150,8 +150,8 @@ the target list - target list + The target list is a list of expressions that define the diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 7f4a2358c4..9fadef5c9d 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -712,8 +712,9 @@ psql: could not connect to server: No such file or directory - AIX + AIX AIXIPC configuration + At least as of version 5.1, it should not be necessary to do @@ -734,8 +735,9 @@ psql: could not connect to server: No such file or directory - FreeBSD + FreeBSD FreeBSDIPC configuration + The default settings can be changed using @@ -791,8 +793,9 @@ kern.ipc.semmnu=256 - NetBSD + NetBSD NetBSDIPC configuration + In NetBSD 5.0 and later, @@ -822,8 +825,9 @@ kern.ipc.semmnu=256 - OpenBSD + OpenBSD OpenBSDIPC configuration + The options SYSVSHM and SYSVSEM need @@ -854,8 +858,9 @@ option SEMMAP=256 - HP-UX + HP-UX HP-UXIPC configuration + The default settings tend to suffice for normal installations. @@ -875,8 +880,9 @@ option SEMMAP=256 - Linux + Linux LinuxIPC configuration + The default maximum segment size is 32 MB, and the @@ -917,8 +923,9 @@ option SEMMAP=256 - Mac OS X + Mac OS X Mac OS XIPC configuration + The recommended method for configuring shared memory in OS X @@ -980,8 +987,9 @@ sysctl -w kern.sysv.shmall - SCO OpenServer + SCO OpenServer SCO OpenServerIPC configuration + In the default configuration, only 512 kB of shared memory per @@ -1008,8 +1016,9 @@ sysctl -w kern.sysv.shmall Solaris 2.6 to 2.9 (Solaris - 6 to Solaris 9) + 6 to Solaris 9) SolarisIPC configuration + The relevant settings can be changed in @@ -1082,8 +1091,9 @@ project.max-msg-ids=(priv,4096,deny) - UnixWare + UnixWare UnixWareIPC configuration + On UnixWare 7, the maximum size for shared diff --git a/doc/src/sgml/sepgsql.sgml b/doc/src/sgml/sepgsql.sgml index 9a9b5906ba..6889e428a4 100644 --- a/doc/src/sgml/sepgsql.sgml +++ b/doc/src/sgml/sepgsql.sgml @@ -256,10 +256,12 @@ $ sudo semodule -r sepgsql-regtest - sepgsql.permissive (boolean) - - sepgsql.permissive configuration parameter - + + sepgsql.permissive (boolean) + + sepgsql.permissive configuration parameter + + This parameter enables sepgsql to function @@ -278,10 +280,12 @@ $ sudo semodule -r sepgsql-regtest - sepgsql.debug_audit (boolean) - - sepgsql.debug_audit configuration parameter - + + sepgsql.debug_audit (boolean) + + sepgsql.debug_audit configuration parameter + + This parameter enables the printing of audit messages regardless of diff --git a/doc/src/sgml/sslinfo.sgml b/doc/src/sgml/sslinfo.sgml index 783e03f0ad..22ef4396ab 100644 --- a/doc/src/sgml/sslinfo.sgml +++ b/doc/src/sgml/sslinfo.sgml @@ -24,11 +24,11 @@ - - ssl_is_used - ssl_is_used() returns boolean + + ssl_is_used + @@ -39,11 +39,11 @@ - - ssl_version - ssl_version() returns text + + ssl_version + @@ -54,11 +54,11 @@ - - ssl_cipher - ssl_cipher() returns text + + ssl_cipher + @@ -69,11 +69,11 @@ - - ssl_client_cert_present - ssl_client_cert_present() returns boolean + + ssl_client_cert_present + @@ -85,11 +85,11 @@ - - ssl_client_serial - ssl_client_serial() returns numeric + + ssl_client_serial + @@ -109,11 +109,11 @@ - - ssl_client_dn - ssl_client_dn() returns text + + ssl_client_dn + @@ -132,11 +132,11 @@ - - ssl_issuer_dn - ssl_issuer_dn() returns text + + ssl_issuer_dn + @@ -157,11 +157,11 @@ - - ssl_client_dn_field - ssl_client_dn_field(fieldname text) returns text + + ssl_client_dn_field + @@ -206,11 +206,11 @@ emailAddress - - ssl_issuer_field - ssl_issuer_field(fieldname text) returns text + + ssl_issuer_field + diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index fd54c4425d..891e7fabac 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -854,11 +854,11 @@ SELECT plainto_tsquery('english', 'The Fat & Rats:C'); - - ts_rank - - + + ts_rank + + ts_rank( weights float4[], vector tsvector, query tsquery , normalization integer ) returns float4 @@ -871,11 +871,11 @@ SELECT plainto_tsquery('english', 'The Fat & Rats:C'); + ts_rank_cd - ts_rank_cd( weights float4[], vector tsvector, query tsquery , normalization integer ) returns float4 @@ -1221,11 +1221,11 @@ FROM (SELECT id, body, q, ts_rank_cd(ti, q) AS rank + tsvector concatenation - tsvector || tsvector @@ -1260,11 +1260,11 @@ FROM (SELECT id, body, q, ts_rank_cd(ti, q) AS rank + setweight - setweight(vector tsvector, weight "char") returns tsvector @@ -1288,11 +1288,11 @@ FROM (SELECT id, body, q, ts_rank_cd(ti, q) AS rank + length(tsvector) - length(vector tsvector) returns integer @@ -1305,11 +1305,11 @@ FROM (SELECT id, body, q, ts_rank_cd(ti, q) AS rank + strip - strip(vector tsvector) returns tsvector @@ -1385,11 +1385,11 @@ FROM (SELECT id, body, q, ts_rank_cd(ti, q) AS rank + numnode - numnode(query tsquery) returns integer @@ -1419,11 +1419,11 @@ SELECT numnode('foo & bar'::tsquery); + querytree - querytree(query tsquery) returns text @@ -3210,13 +3210,13 @@ SELECT plainto_tsquery('supernovae stars'); + index GiST text search - CREATE INDEX name ON table USING gist(column); @@ -3231,13 +3231,13 @@ SELECT plainto_tsquery('supernovae stars'); + index GIN text search - CREATE INDEX name ON table USING gin(column); -- 2.40.0