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 747C89DC807 for ; Mon, 27 Feb 2006 14:04:06 -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 64996-02 for ; Mon, 27 Feb 2006 14:04:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id E38749DCB83 for ; Mon, 27 Feb 2006 14:04:02 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 1F89F30C21; Mon, 27 Feb 2006 19:04:03 +0100 (MET) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: The trigger can be specified to fire on time condition? Date: Mon, 27 Feb 2006 12:30:53 -0500 Organization: cbbrowne Computing Inc Lines: 17 Message-ID: <60oe0szp2q.fsf@dba2.int.libertyrms.com> References: <44033246.9030808@elios-informatique.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:94oLrN4Hcf9g33FKFCYoEapg1Z0= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.288 required=5 tests=[AWL=0.288] X-Spam-Score: 0.288 X-Spam-Level: X-Archive-Number: 200602/421 X-Sequence-Number: 17407 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)