Re: on connect trigger?
От | |
---|---|
Тема | Re: on connect trigger? |
Дата | |
Msg-id | 64443.66.212.203.144.1068194996.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Re: on connect trigger? ("Keith C. Perry" <netadmin@vcsn.com>) |
Список | pgsql-general |
> Quoting btober@seaworthysys.com: > >> Is there any kind of mechanism in pg 7.3 for doing something like >> what I would describe as a "login trigger" procedure to run >> when a user connects to the database? >> > > Berend, > > I've got something like that setup on an e-communities site I built. > There was already a "last action" query/report I had so what I have > setup on as part of the database nightly vacuum is to first delete any > account that did not have any actions for over a year. You don't need > to do a trigger to do that. You just need to make a cron job that run > at whatever is an acceptable interval. > > -- > Keith C. Perry, MS E.E. That sounds somewhat interesting, and I understand the crontab approach, but the key to your methods is that "last action" thing. I can see how I might get a date from some table that has an column value that gets assigned the current date after insert or update (using DEFAULT or a trigger), but what if the user's access is read-only, i.e., they perform only SELECT operations? How could I catch that? ~Berend Tober
В списке pgsql-general по дате отправления: