Re: Add hint message for check_log_destination()

On Fri, 07 Jul 2023 at 14:46, jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> 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?
>>
>
> 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 ?

Thanks for your review!

Yeah, the description of extra_desc is more accurate. Updated.

--
Regrads,
Japin Li.