Message-ID: <3B32FAD3.47A5A9D@imsd.uni-mainz.de>
Date: Fri, 22 Jun 2001 09:59:15 +0200
From: Markus Wagner <wagner@imsd.uni-mainz.de>
Organization: IMSD
MIME-Version: 1.0
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: distinguishing different database connections
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

can I access information on the current connection from within a trigger
function?
I need to identify different server connections somehow. Something like
a "connection id" would be enough.

The background:

When a user starts a frontend application (NT, Access) he starts a new
connection to our Linux database server. But for all users the "postgres
user" is the same, since the ODBC connection is hard linked into the
application. The problem is that we need the NT user name within our
trigger (C) functions.

The idea:
Let's execute a function "logon" whenever an instance of the application
is started. This function will get the NT user name as a parameter. It
will recognize the current connection id and it would store the pair
(connection id, NT user name) in a table. Then, whenever some trigger
needs to know the user name (for logging actions), it could lookup the
user name with the current connection id.

Can we do this? Please help.

Thank you very much,

Markus