diff options
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/ref/alter_system.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 24 |
2 files changed, 31 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/alter_system.sgml b/doc/src/sgml/ref/alter_system.sgml index 1bde66d6ad2..b28919d1b26 100644 --- a/doc/src/sgml/ref/alter_system.sgml +++ b/doc/src/sgml/ref/alter_system.sgml @@ -84,6 +84,8 @@ ALTER SYSTEM RESET ALL constants, identifiers, numbers, or comma-separated lists of these, as appropriate for the particular parameter. Values that are neither numbers nor valid identifiers must be quoted. + If the parameter accepts a list of values, <literal>NULL</literal> + can be written to specify an empty list. <literal>DEFAULT</literal> can be written to specify removing the parameter and its value from <filename>postgresql.auto.conf</filename>. </para> @@ -136,7 +138,15 @@ ALTER SYSTEM SET wal_level = replica; in <filename>postgresql.conf</filename>: <programlisting> ALTER SYSTEM RESET wal_level; -</programlisting></para> +</programlisting> + </para> + + <para> + Set the list of preloaded extension modules to be empty: +<programlisting> +ALTER SYSTEM SET shared_preload_libraries TO NULL; +</programlisting> + </para> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 2218f54682e..16c7e9a7b26 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -21,8 +21,8 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -SET [ SESSION | LOCAL ] <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> | '<replaceable class="parameter">value</replaceable>' | DEFAULT } -SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replaceable> | '<replaceable class="parameter">value</replaceable>' | LOCAL | DEFAULT } +SET [ SESSION | LOCAL ] <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> [, ...] | DEFAULT } +SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replaceable> | LOCAL | DEFAULT } </synopsis> </refsynopsisdiv> @@ -123,7 +123,7 @@ SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replac <term><replaceable class="parameter">configuration_parameter</replaceable></term> <listitem> <para> - Name of a settable run-time parameter. Available parameters are + Name of a settable configuration parameter. Available parameters are documented in <xref linkend="runtime-config"/> and below. </para> </listitem> @@ -133,9 +133,12 @@ SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replac <term><replaceable class="parameter">value</replaceable></term> <listitem> <para> - New value of parameter. Values can be specified as string + New value of the parameter. Values can be specified as string constants, identifiers, numbers, or comma-separated lists of these, as appropriate for the particular parameter. + Values that are neither numbers nor valid identifiers must be quoted. + If the parameter accepts a list of values, <literal>NULL</literal> + can be written to specify an empty list. <literal>DEFAULT</literal> can be written to specify resetting the parameter to its default value (that is, whatever value it would have had if no <command>SET</command> had been executed @@ -284,6 +287,19 @@ SELECT setseed(<replaceable>value</replaceable>); <programlisting> SET search_path TO my_schema, public; </programlisting> + Note that this is not the same as +<programlisting> +SET search_path TO 'my_schema, public'; +</programlisting> + which would have the effect of setting <varname>search_path</varname> + to contain a single, probably-nonexistent schema name. + </para> + + <para> + Set the list of temporary tablespace names to be empty: +<programlisting> +SET temp_tablespaces TO NULL; +</programlisting> </para> <para> |