can I access information on the current connection from within a trigger
I need to identify different server connections somehow. Something like
a "connection id" would be enough.
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.
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,
pgsql-interfaces by date
|Next:||From: Christof Glaser||Date: 2001-06-22 08:38:39|
|Subject: Re: [SQL] distinguishing different database connections|
|Previous:||From: Manika Dey||Date: 2001-06-21 20:32:41|
|Subject: OBBC for postgress |
pgsql-sql by date
|Next:||From: Cyril Slucki||Date: 2001-06-22 08:02:36|
|Subject: RE: Difference between insert a tuple in a table by function and by datasheet|
|Previous:||From: DI Hasenöhrl||Date: 2001-06-22 07:23:17|
|Subject: Difference between insert a tuple in a table by function and by datasheet|