Re: Application name patch - v2

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "David Fetter" <david(at)fetter(dot)org>,"Dave Page" <dpage(at)pgadmin(dot)org>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Application name patch - v2
Date: 2009-10-19 15:53:41
Message-ID: 4ADC4535020000250002BB04@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Fetter <david(at)fetter(dot)org> wrote:

> Could you point to a reference for this? It could help the rest of
us
> see what you're aiming for even better :)

Sybase Adaptive Server Enterprise (ASE)

clientapplname varchar(30) column in sysprocesses table:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables50.htm

It can be set (for example) in the LOGINREC structure with DBSETLAPP:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32600.1500/html/dblib/dblib18.htm

SET clientapplname command to set on the fly by running SQL on the
connection:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.commands/html/commands/commands85.htm

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-19 15:56:29 Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock
Previous Message Tom Lane 2009-10-19 15:50:17 Re: Writeable CTEs and side effects