pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: gavinpanella@gmail.com
Subject:  "20.16. Customized Options" – cannot be set by `ALTER SYSTEM`
Date: Mon, 16 Oct 2023 13:34:57 +0000
Message-ID: <169746329791.169914.16613647309012285391@wrigleys.postgresql.org> (raw)

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/runtime-config-custom.html
Description:

As far as I can tell, the following statement:

> PostgreSQL will accept a setting for any two-part parameter name

does not hold when creating a *new* setting with `ALTER SYSTEM`, e.g.

  ALTER SYSTEM SET foo.bar TO 'baz';

will elicit an error.

However, if `foo.bar` is defined in `postgresql.conf` or
`postgresql.auto.conf` – put there by hand – then it can be altered, i.e.
the `ALTER SYSTEM` command above will succeed.

I don't know if this is something that should be mentioned in the
documentation or if it's an inconsistency in the implementation.


view thread (5+ messages)  latest in thread

Message-ID: <169746329791.169914.16613647309012285391@wrigleys.postgresql.org>
Permalink:  ../169746329791.169914.16613647309012285391@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/169746329791.169914.16613647309012285391@wrigleys.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, gavinpanella@gmail.com
  Subject: Re:  "20.16. Customized Options" – cannot be set by `ALTER SYSTEM`
  In-Reply-To: <169746329791.169914.16613647309012285391@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox