Hi,
I know it has been asked a millions of times and I know there are previous posts about this topic too but the thing is I'm a windows user and I can't use cron. I'm sure that windows has it's own system like cron but what I look is something that is integrated to the pgsql. When the time will come he will do what he has to and will get to passive mod till the come once agan (yes, I know I describe cron.). Is there an option in pgsql that does this thing?
I think that there could be a way with triggers or functions. But this should slow down the server. I can insert this check in my forms but this will cause a higher slow down rate then triggers I think. Why do I need this is for a session table. I insert rows for logged in users. I delete them if they click logout. But if they dont I want that my session table be cleared from entries that are entered two days ago or something like that. As that session is an useless data and is just a junk in the db. And the scheduled task will check every 4.00 am or 5.00 am for junk entries and will delete them.
If there is no way for this in pgsql, how can I use, cron can you point me to a good tutorial or can you point me to the windows equal of the cron.
Thanks for your time.
Express yourself instantly with MSN Messenger!
MSN Messenger