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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
