Re: Adding application_name to the error and notice message fields

From: Mitar <mmitar(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Adding application_name to the error and notice message fields
Date: 2024-03-27 17:22:27
Message-ID: CAKLmikPHNQvRu=V+uXst2VZSmAOd9xbSLL4T7GW99ZyTekoMkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

Oh, I can use PQparameterStatus to obtain application_name of the
current connection. It seems then it is not needed to add this
information into notice message.

Mitar

On Wed, Mar 27, 2024 at 4:22 PM Mitar <mmitar(at)gmail(dot)com> wrote:
>
> Hi!
>
> We take care to always set application_name to improve our log lines
> where we use %a in log_line_prefix to log application name, per [1].
> But notices which are sent to the client do not have the application
> name and are thus hard to attribute correctly. Could "a" be added with
> the application name (when available) to the error and notice message
> fields [2]?
>
>
> Mitar
>
> [1] https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LINE-PREFIX
> [2] https://www.postgresql.org/docs/current/protocol-error-fields.html
>
> --
> https://mitar.tnode.com/
> https://twitter.com/mitar_m
> https://noc.social/@mitar

--
https://mitar.tnode.com/
https://twitter.com/mitar_m
https://noc.social/@mitar

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-03-27 17:34:57 Re: Possibility to disable `ALTER SYSTEM`
Previous Message Isaac Morland 2024-03-27 17:12:17 Re: Possibility to disable `ALTER SYSTEM`