From: Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: The trigger can be specified to fire on time condition?
Date: Mon, 27 Feb 2006 18:09:26 +0100
Message-ID: <44033246.9030808@elios-informatique.fr> (raw)
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
Attachments:Jamal.Ghaffour.vcf (text/x-vcard, 376B) download
begin:vcard
fn:Jamal Ghaffour
n:Ghaffour;Jamal
org:ELIOS Informatique
adr;quoted-printable:;;1, sq de ch=C3=AAne Germain,;CESSON SEVIGNE;;35510;FRANCE
email;internet:Jamal.Ghaffour@elios-informatique.fr
tel;work:(+33) 2.99.63.85.30
tel;fax:(+33) 2.99.63.85.93
tel;home:(+33) 2 99 36 73 96
tel;cell:(+33) 6.21.85.15.91
url:http://www.elios-informatique.fr
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jamal.Ghaffour@elios-informatique.fr
Subject: Re: The trigger can be specified to fire on time condition?
In-Reply-To: <44033246.9030808@elios-informatique.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox