Re: Add hint message for check_log_destination()

On Fri, Jul 7, 2023 at 1:06 PM Japin Li <japinli(at)hotmail(dot)com> wrote:
>
>
> Hi, hackers
>
> When I try to change log_destination using ALTER SYSTEM with the wrong value,
> it complains of the "Unrecognized key word" without available values. This
> patch tries to add a hint message that provides available values for
> log_destination. Any thoughts?
>
> --
> Regrads,
> Japin Li.
>

select * from pg_settings where name ~* 'log.*destin*' \gx

short_desc | Sets the destination for server log output.
extra_desc | Valid values are combinations of "stderr", "syslog",
"csvlog", "jsonlog", and "eventlog", depending on the platform.

you can just reuse extra_desc in the pg_settings (view) column ?