enter/leave session triggers - Mailing list pgsql-general

From Rafal Pietrak
Subject enter/leave session triggers
Date
Msg-id 1348475070.22293.145.camel@localhost.localdomain
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Need to run a job in PgAdmin-III
Next
From: pavithra
Date:
Subject: Re: Need to run a job in PgAdmin-III