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


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

http://www.postgresql.org/docs/faq

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

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)