By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

on connect trigger

P: n/a
Is there any kind of mechanism in pg 7.3 for doing something like what I
would describe as a "login trigger" procedure or maybe "on connect"
trigger, i.e., a way to specify a stored procedure to run when a user
connects to the database?

What I'm thinking is this. Right now, my end-user GUI application calls a
procedure which updates the user account expiration date whenever they
log in. The idea is that accounts that are never used will expire,
eventually, and those that are active will continually have the
expiration date pushed further ahead each time they log in.

I'd like to not depend on the application making this call, because other
applications which connect to the same database will be written, and the
developers might not build in this same explicit procedure call -- it
really is the kind of thing that is best done on the backend.

~Berend Tober


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.