O$: PostgreSQL setting the $programname property

[Alex Clay]

Hi Paul,

We set the application_name value on the connection before logging in to affect pg_stat_activity. For example:

Calculate voSession.$options as "application_name='my great app'"

You can combine this with other settings, such as sslmode.

This needs to be set before calling $logon.

I haven't used $programname, but it looks to do the same as setting application_name. Are you setting $programname before logging on?

Alex


> On Nov 6, 2023, at 02:25, Paul Mulroney <pmulroney at logicaldevelopments.com.au> wrote:
> 
> Hi Everyone,
> 
> Has anyone tried to use the $programname property of a PGSession object?  I'd like to tell Postgres the application that's running (eg Omnis), so that I can see it in the pg_stat_activity table, but I can't seem to get it to work.
> 
> I'm basically doing this:
> 
> Calculate voSession.$programname as 'Fred'
> 
> Am I missing anything?
> 
> Regards,
> Paul.
> 
> 
> I remember the first time I saw a universal remote control … I though to myself "Well, this changes everything"
> -- 
> Paul W. Mulroney                                            We Don't Do Simple Pty Ltd 
> pmulroney at logicaldevelopments.com.au       Trading as Logical Developments
> www.logicaldevelopments.com.au                   ACN 161 009 374 
> Ph: +61 8 9458 3889                                       86 Coolgardie Street
>                                                                         BENTLEY  WA  6102
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com