On Mon, 2023-10-16 at 16:21 -0400, Tom Lane wrote:
> So maybe we should allow ALTER SYSTEM for unrecognized parameters,
> as long as the parameter name is syntactically legit and you're a
> superuser.
That seems more consistent than the current behavior, so +1.
Yours,
Laurenz Albe
Laurenz Albe writes:
> On Mon, 2023-10-16 at 12:29 -0400, Tom Lane wrote:
>> So that feels like a bug: we should not allow ALTER SYSTEM to execute
>> against a placeholder GUC definition, because the placeholder can't
>> tell us whether the value is valid. I wonder though if forbidding
>> this wo
On Mon, 2023-10-16 at 12:29 -0400, Tom Lane wrote:
> I do see an issue here:
>
> regression=# ALTER SYSTEM SET foo.bar TO 'baz';
> ERROR: unrecognized configuration parameter "foo.bar"
> regression=# SET foo.bar TO 'baz';
> SET
> regression=# ALTER SYSTEM SET foo.bar TO 'baz';
> ALTER SYSTEM
>
>
PG Doc comments form writes:
> 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.
ALTER SYSTEM
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 *n
On 2023-Oct-16, PG Doc comments form wrote:
> I'm confused by this paragraph:
>
> > These popular data structures were originally developed for in-memory
> > usage. In main memory, they are usually designed as a set of dynamically
> > allocated nodes linked by pointers. This is not suitable for d
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/spgist-intro.html
Description:
I'm confused by this paragraph:
> These popular data structures were originally developed for in-memory
usage. In main memory, they are usually designed as