PostgreSQL setting the $programname property

John Boehme john at integralservices.biz
Mon Nov 6 22:32:59 UTC 2023


Hi Paul,

We do this:

Do pSession.$programname.$assign($ctask.$app().$appTitleShort())

And the application name appears in the Postgre status display of connections.


John Boehme
940-597-3046

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Paul Mulroney
Sent: Sunday, November 5, 2023 11:25 PM
To: Omnis-dev list
Subject: O$: PostgreSQL setting the $programname property

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 



More information about the omnisdev-en mailing list