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

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 ?


Thanks

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.

Jamal.Ghaffour@elios-informatique.fr (Jamal Ghaffour) writes:
> 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 ?

Time-based event scheduling is done using cron, external to the
database.
--
output = reverse("gro.mca" "@" "enworbbc")
http://cbbrowne.com/info/sgml.html
"Even in the  area of anticompetitive conduct, Microsoft  is mainly an
imitator." -- Ralph Nader (1998/11/11)