| From: | Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | enter/leave session triggers |
| Date: | 2012-09-24 08:24:30 |
| Message-ID: | 1348475070.22293.145.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Have there been any discussion on the list on triggers fires when new
session (libpg session to server?) is opened/closed? Somehow I cannot
google anything with the keywords I use.
And the question is: has postgresql any plans to have:
1. triggers that fire BEFORE/AFTER user opens a session with server?
2. triggers that fire BEFORE/AFTER user ENTERS/LEAVES a role?
the simplist use is to have session timestamps logged in application
speciffic tables; but I personaly find myself always having a "users"
table, full of attributs which quite often are there to setup user
profiles for the duration of sessions and to be persistent across
sessions.
-R
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pavithra | 2012-09-24 09:06:32 | Re: Need to run a job in PgAdmin-III |
| Previous Message | Raghavendra | 2012-09-24 07:02:27 | Re: Need to run a job in PgAdmin-III |