"20.16. Customized Options" – cannot be set by `ALTER SYSTEM`

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: gavinpanella(at)gmail(dot)com
Subject: "20.16. Customized Options" – cannot be set by `ALTER SYSTEM`
Date: 2023-10-16 13:34:57
Message-ID: 169746329791.169914.16613647309012285391@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2023-10-16 15:09:37 Re: SP-GiST confusing introductory paragraph
Previous Message PG Doc comments form 2023-10-16 01:58:46 SP-GiST confusing introductory paragraph