You are right, it is too much work to do. For the moment application_name
will suffice!
Best regards, Cristi Boboc
On Friday, November 5, 2021, 06:15:53 PM GMT+2, Vijaykumar Jain
wrote:
On Fri, Nov 5, 2021, 7:46 PM Michael Lewis wrote:
For my purposes, app name isn't long eno
Hi.
If I am going into logging, then I would use SET_CONTEXT function. It is
too little documented, but we can add many pairs of (name, value), like
this:set_context('myvar.varname', 'my value here',
false),set_context('abc.anyname', 'any value', false)
The important part is that dot ins
On Fri, Nov 5, 2021, 7:46 PM Michael Lewis wrote:
> For my purposes, app name isn't long enough so we put a comment at the
> start of every SQL that has a unique ID generated in the application. This
> ensures that we can tell one connection apart from another even when both
> are coming from the
For my purposes, app name isn't long enough so we put a comment at the
start of every SQL that has a unique ID generated in the application. This
ensures that we can tell one connection apart from another even when both
are coming from the same feature/action (applicationName is set to this)
even u
Boboc Cristi writes:
> I need a feature that would me allow to debug "live" the work of an
> application together with a PostgreSQL database.
> I think that if I would be able to define a session variable that is visible
> in pg_stat_activity (or in other system view, table or function) I w
Thank you, Sir!
It is, indeed, a good idea!
Best regards, Cristi Boboc
On Friday, November 5, 2021, 01:41:52 PM GMT+2, Vijaykumar Jain
wrote:
On Fri, Nov 5, 2021, 4:58 PM Boboc Cristi wrote:
Hello!
I need a feature that would me allow to debug "live" the work of an
applica
On Fri, Nov 5, 2021, 4:58 PM Boboc Cristi wrote:
> Hello!
> I need a feature that would me allow to debug "live" the work of an
> application together with a PostgreSQL database.
>
> I think that if I would be able to define a session variable that is
> visible in pg_stat_activity (or in othe
Hello!
I need a feature that would me allow to debug "live" the work of an
application together with a PostgreSQL database.
I think that if I would be able to define a session variable that is visible in
pg_stat_activity (or in other system view, table or function) I would be more
than happ
