PG Bug reporting form <noreply@postgresql.org> writes:
> tl;dr:
> ALTER SYSTEM SET log_statement = 'all'; -- quotes required around the new
> value
The reason for that is that ALL is a reserved word in SQL.
> ALTER SYSTEM SET shared_preload_libraries = pg_stat_statements,plprofiler;
> -- requires the new value *not* be quoted, this is what's confusing me
Well, you could quote the list elements individually, eg
ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements','plprofiler';
But this:
> ALTER SYSTEM SET shared_preload_libraries =
> 'pg_stat_statements,plprofiler';
says you just want one list element that happens to include a comma.
No, the syntax rules here are not the same as they are in postgresql.conf.
> Is this expected behavior? If so, can we get some examples in the docs to
> help folks figure out the correct quoting rules?
AFAICS the documentation statements you quoted are accurate.
regards, tom lane