Re: The trigger can be specified to fire on time condition?

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Jamal Ghaffour wrote:
> Hi All,
> I ' m using the postgresql datbase to stores cookies. Theses cookies 
> become invalid after  30 mn and have to be deleted. i have defined a 
> procedure that will
> delete all invalid cookies, but i don't know how to call it in loop way 
> (for example each hour).
> I think that it  possible  because this behaivor is the same of the 
> autovaccum procedure that handle the vaccum process every time (60s in 
> default way).
> After reading the documentation, it seems  that triggers can't handle 
> this stuff .
> how can i resolve the problem ?

Use your system's crontab!  (On Windows, "scheduled tasks" or whatever).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.