X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 01C249DCA5E for ; Mon, 27 Feb 2006 13:06:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56615-01 for ; Mon, 27 Feb 2006 13:06:51 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 5931D9DCA1C for ; Mon, 27 Feb 2006 13:06:50 -0400 (AST) Received: from smtp1.clb.oleane.net (smtp1.clb.oleane.net [213.56.31.17]) by svr4.postgresql.org (Postfix) with ESMTP id 026455AF04C for ; Mon, 27 Feb 2006 17:06:49 +0000 (GMT) Received: from smtp1.clb.oleane.net (localhost [127.0.0.1]) by smtp1.clb.oleane.net (antivirus) with ESMTP id k1RH6hES027901 for ; Mon, 27 Feb 2006 18:06:43 +0100 Received: from [192.168.8.219] ([62.160.127.238]) (authenticated) by smtp1.clb.oleane.net with ESMTP id k1RH6dfp027703 for ; Mon, 27 Feb 2006 18:06:39 +0100 Message-ID: <44033246.9030808@elios-informatique.fr> Date: Mon, 27 Feb 2006 18:09:26 +0100 From: Jamal Ghaffour User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: fr, en MIME-Version: 1.0 To: postgres performance list Subject: The trigger can be specified to fire on time condition? Content-Type: multipart/mixed; boundary="------------010204020204050203090106" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200602/418 X-Sequence-Number: 17404 This is a multi-part message in MIME format. --------------010204020204050203090106 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------010204020204050203090106 Content-Type: text/x-vcard; charset=utf-8; name="Jamal.Ghaffour.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Jamal.Ghaffour.vcf" 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 --------------010204020204050203090106--