11<!--
2- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.334 2005/07/0218:29:03 momjian Exp $
2+ $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.335 2005/07/0219:16:36 momjian Exp $
33-->
44
55<chapter Id="runtime">
@@ -929,7 +929,8 @@ SET ENABLE_SEQSCAN TO OFF;
929929 <para>
930930 Enables <acronym>SSL</> connections. Please read
931931 <xref linkend="ssl-tcp"> before using this. The default
932- is off. This parameter can only be set at server start.
932+ is <literal>off</>. This parameter can only be set at server
933+ start.
933934 </para>
934935 </listitem>
935936 </varlistentry>
@@ -946,8 +947,8 @@ SET ENABLE_SEQSCAN TO OFF;
946947 <xref linkend="sql-alteruser" endterm="sql-alteruser-title">
947948 without writing either <literal>ENCRYPTED</> or
948949 <literal>UNENCRYPTED</>, this option determines whether the
949- password is to be encrypted. The default ison (encrypt the
950- password).
950+ password is to be encrypted. The default is<literal>on</>
951+ (encrypt the password).
951952 </para>
952953 </listitem>
953954 </varlistentry>
@@ -987,8 +988,8 @@ SET ENABLE_SEQSCAN TO OFF;
987988 <listitem>
988989 <para>
989990 Sets if Kerberos usernames should be treated case-insensitive.
990- The default is off (case sensitive). This parameter can only be
991- set at server start.
991+ The default is<literal> off</> (case sensitive). This parameter
992+ can only be set at server start.
992993 </para>
993994 </listitem>
994995 </varlistentry>
@@ -1867,7 +1868,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
18671868 <listitem>
18681869 <para>
18691870 Enables or disables the query planner's use of bitmap-scan plan
1870- types. The default ison .
1871+ types. The default is<literal>on</> .
18711872 </para>
18721873 </listitem>
18731874 </varlistentry>
@@ -1880,7 +1881,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
18801881 <listitem>
18811882 <para>
18821883 Enables or disables the query planner's use of hashed
1883- aggregation plan types. The default ison .
1884+ aggregation plan types. The default is<literal>on</> .
18841885 </para>
18851886 </listitem>
18861887 </varlistentry>
@@ -1893,7 +1894,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
18931894 <listitem>
18941895 <para>
18951896 Enables or disables the query planner's use of hash-join plan
1896- types. The default ison .
1897+ types. The default is<literal>on</> .
18971898 </para>
18981899 </listitem>
18991900 </varlistentry>
@@ -1909,7 +1910,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19091910 <listitem>
19101911 <para>
19111912 Enables or disables the query planner's use of index-scan plan
1912- types. The default ison .
1913+ types. The default is<literal>on</> .
19131914 </para>
19141915 </listitem>
19151916 </varlistentry>
@@ -1922,7 +1923,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19221923 <listitem>
19231924 <para>
19241925 Enables or disables the query planner's use of merge-join plan
1925- types. The default ison .
1926+ types. The default is<literal>on</> .
19261927 </para>
19271928 </listitem>
19281929 </varlistentry>
@@ -1938,7 +1939,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19381939 plans. It's not possible to suppress nested-loop joins entirely,
19391940 but turning this variable off discourages the planner from using
19401941 one if there are other methods available. The default is
1941- on .
1942+ <literal>on</> .
19421943 </para>
19431944 </listitem>
19441945 </varlistentry>
@@ -1957,7 +1958,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19571958 plan types. It's not possible to suppress sequential scans
19581959 entirely, but turning this variable off discourages the planner
19591960 from using one if there are other methods available. The
1960- default ison .
1961+ default is<literal>on</> .
19611962 </para>
19621963 </listitem>
19631964 </varlistentry>
@@ -1973,7 +1974,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19731974 steps. It's not possible to suppress explicit sorts entirely,
19741975 but turning this variable off discourages the planner from
19751976 using one if there are other methods available. The default
1976- ison .
1977+ is<literal>on</> .
19771978 </para>
19781979 </listitem>
19791980 </varlistentry>
@@ -1986,7 +1987,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
19861987 <listitem>
19871988 <para>
19881989 Enables or disables the query planner's use of <acronym>TID</>
1989- scan plan types. The default ison .
1990+ scan plan types. The default is<literal>on</> .
19901991 </para>
19911992 </listitem>
19921993 </varlistentry>
@@ -2831,8 +2832,8 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
28312832 if you are not using <application>syslog</>, it is recommended
28322833 that you log the PID or session ID using <varname>log_line_prefix</>
28332834 so that you can link the statement to the
2834- duration using the process ID or session ID. The default is off.
2835- Only superusers can change this setting.
2835+ duration using the process ID or session ID. The default is
2836+ <literal>off</>. Only superusers can change this setting.
28362837 </para>
28372838 </listitem>
28382839 </varlistentry>
@@ -3137,8 +3138,8 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
31373138 <para>
31383139 If on, collected statistics are zeroed out whenever the server
31393140 is restarted. If off, statistics are accumulated across server
3140- restarts. The default ison . This option can onlybe set at
3141- server start.
3141+ restarts. The default is<literal>on</> . This option can only
3142+ be set at server start.
31423143 </para>
31433144 </listitem>
31443145 </varlistentry>
@@ -3258,12 +3259,12 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
32583259 </indexterm>
32593260 <listitem>
32603261 <para>
3261- This parameter is normally on. When set to off, it disables
3262- validation of the function body string during <xref
3262+ This parameter is normally on. When set to<literal> off</> , it
3263+ disables validation of the function body string during <xref
32633264 linkend="sql-createfunction"
3264- endterm="sql-createfunction-title">. Disabling validation is
3265- occasionally useful to avoid problems such as forward
3266- references when restoring function definitions from a dump.
3265+ endterm="sql-createfunction-title">. Disabling validation is
3266+ occasionally useful to avoid problems such as forward references
3267+ when restoring function definitions from a dump.
32673268 </para>
32683269 </listitem>
32693270 </varlistentry>
@@ -3307,7 +3308,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
33073308 <para>
33083309 A read-only SQL transaction cannot alter non-temporary tables.
33093310 This parameter controls the default read-only status of each new
3310- transaction. The default is off (read/write).
3311+ transaction. The default is<literal> off</> (read/write).
33113312 </para>
33123313
33133314 <para>
@@ -3389,7 +3390,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
33893390 <literal>CST</literal>, <literal>EST</literal>, and
33903391 <literal>SAT</literal> are interpreted as Australian time
33913392 zones rather than as North/South American time zones and
3392- Saturday. The default is off.
3393+ Saturday. The default is<literal> off</> .
33933394 </para>
33943395 </listitem>
33953396 </varlistentry>
@@ -3530,7 +3531,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
35303531 <para>
35313532 Determines whether <command>EXPLAIN VERBOSE</> uses the
35323533 indented or non-indented format for displaying detailed
3533- query-tree dumps. The default ison .
3534+ query-tree dumps. The default is<literal>on</> .
35343535 </para>
35353536 </listitem>
35363537 </varlistentry>
@@ -3670,15 +3671,15 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'
36703671 </indexterm>
36713672 <listitem>
36723673 <para>
3673- When<literal>on</> , tables that are referenced by a query
3674- will be automatically added to the <literal>FROM</> clause if
3675- not already present. This behavior does not comply with the
3676- SQL standard and many people dislike it because it can mask
3677- mistakes (such as referencing a table where you should have
3678- referenced its alias). The default is <literal>off</>. This
3679- variable can be enabled for compatibility with releases of
3680- <productname>PostgreSQL</> prior to 8.1, where this behavior
3681- was allowed by default.
3674+ Whenon , tables that are referenced by a query will be
3675+ automatically added to the <literal>FROM</> clause if not
3676+ already present. This behavior does not comply with the SQL
3677+ standard and many people dislike it because it can mask mistakes
3678+ (such as referencing a table where you should have referenced
3679+ its alias). The default is <literal>off</>. This variable can be
3680+ enabled for compatibility with releases of
3681+ <productname>PostgreSQL</> prior to 8.1, where this behavior was
3682+ allowed by default.
36823683 </para>
36833684
36843685 <para>
@@ -3722,10 +3723,11 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'
37223723 This controls the inheritance semantics, in particular whether
37233724 subtables are included by various commands by default. They were
37243725 not included in versions prior to 7.1. If you need the old
3725- behavior you can set this variable to off, but in the long run
3726- you are encouraged to change your applications to use the
3727- <literal>ONLY</literal> key word to exclude subtables. See
3728- <xref linkend="ddl-inherit"> for more information about inheritance.
3726+ behavior you can set this variable to <literal>off</>, but in
3727+ the long run you are encouraged to change your applications to
3728+ use the <literal>ONLY</literal> key word to exclude subtables.
3729+ See <xref linkend="ddl-inherit"> for more information about
3730+ inheritance.
37293731 </para>
37303732 </listitem>
37313733 </varlistentry>
@@ -3766,9 +3768,9 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'
37663768 </indexterm>
37673769 <listitem>
37683770 <para>
3769- When<literal>on</> , a warning is issued if a backslash
3770- (<literal>\</>) appears in an ordinary string literal
3771- (<literal>'...'</> syntax). The default is <literal>off</>.
3771+ Whenon , a warning is issued if a backslash (<literal>\</>)
3772+ appears in an ordinary string literal (<literal>'...'</>
3773+ syntax). The default is <literal>off</>.
37723774 </para>
37733775 <para>
37743776 Escape string syntax (<literal>E'...'</>) should be used for
@@ -3794,14 +3796,15 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir'
37943796 </indexterm>
37953797 <listitem>
37963798 <para>
3797- Whenturned on, expressions of the form
3798- <literal><replaceable>expr</> = NULL</literal> (or <literal>NULL
3799- = <replaceable>expr</></literal>) are treated as
3799+ When on, expressions of the form <literal><replaceable>expr</> =
3800+ NULL</literal> (or <literal>NULL =
3801+ <replaceable>expr</></literal>) are treated as
38003802 <literal><replaceable>expr</> IS NULL</literal>, that is, they
38013803 return true if <replaceable>expr</> evaluates to the null value,
38023804 and false otherwise. The correct SQL-spec-compliant behavior of
38033805 <literal><replaceable>expr</> = NULL</literal> is to always
3804- return null (unknown). Therefore this option defaults to off.
3806+ return null (unknown). Therefore this option defaults to
3807+ <literal>off</>.
38053808 </para>
38063809
38073810 <para>
@@ -4102,8 +4105,8 @@ plruby.bar = true # generates error, unknown class name
41024105 must be defined when <productname>PostgreSQL</productname> is
41034106 built (accomplished by the <command>configure</command> option
41044107 <option>--enable-cassert</option>). Note that
4105- <varname>debug_assertions</varname> defaults toon if
4106- <productname>PostgreSQL</productname> has been built with
4108+ <varname>debug_assertions</varname> defaults to<literal>on</>
4109+ if <productname>PostgreSQL</productname> has been built with
41074110 assertions enabled.
41084111 </para>
41094112 </listitem>
@@ -4190,7 +4193,8 @@ plruby.bar = true # generates error, unknown class name
41904193 corruption has occurred due to hardware or software error. You should
41914194 generally not set this on until you have given up hope of recovering
41924195 data from the damaged page(s) of a table. The
4193- default setting is off, and it can only be changed by a superuser.
4196+ default setting is <literal>off</>, and it can only be changed
4197+ by a superuser.
41944198 </para>
41954199 </listitem>
41964200 </varlistentry>