From: Markus Wagner <wagner@imsd.uni-mainz.de>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: distinguishing different database connections
Date: Fri, 22 Jun 2001 09:59:15 +0200
Message-ID: <3B32FAD3.47A5A9D@imsd.uni-mainz.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: wagner@imsd.uni-mainz.de, pgsql-sql@postgresql.org
Subject: Re: distinguishing different database connections
In-Reply-To: <3B32FAD3.47A5A9D@imsd.uni-mainz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox