aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>2025-04-04 15:17:17 +0300
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>2025-04-04 15:17:17 +0300
commitb4f453f6ab71eb72cb3a46a5be18e07e5cc285df (patch)
tree2aa054b377d4c3ee2ccbbeb1e07e67947bd6d973
parent7afca7edef751b8d7c0f5b6402ffcefc11c67fdd (diff)
downloadpostgresql-b4f453f6ab71eb72cb3a46a5be18e07e5cc285df.tar.gz
postgresql-b4f453f6ab71eb72cb3a46a5be18e07e5cc285df.zip
docs: Clarify that NULL arg to set_config() means reset to default
Author: David G. Johnston <david.g.johnston@gmail.com> Reviewed-by: Zhang Mingli <zmlpostgres@gmail.com> Discussion: https://www.postgresql.org/message-id/CAKFQuwY0SK6JdCci1VJX6xsztRXgGeVEY-grkENZx%2B3CZpyPcQ@mail.gmail.com
-rw-r--r--doc/src/sgml/func.sgml5
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 9f531e23283..0224f93733d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -28577,6 +28577,11 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
the SQL command <xref linkend="sql-set"/>.
</para>
<para>
+ <function>set_config</function> accepts the NULL value for
+ <parameter>new_value</parameter>, but as settings cannot be null, it
+ is interpreted as a request to reset the setting to its default value.
+ </para>
+ <para>
<literal>set_config('log_statement_stats', 'off', false)</literal>
<returnvalue>off</returnvalue>
</para></entry>