Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6D43247610C for ; Fri, 11 Oct 2002 01:35:23 -0400 (EDT) Received: from krusty.pcisys.net (krusty.pcisys.net [216.229.32.178]) by postgresql.org (Postfix) with ESMTP id A4BD74760F6 for ; Fri, 11 Oct 2002 01:35:22 -0400 (EDT) Received: from [208.202.106.185] (moe1.meg106-185.cos.pcisys.net [208.202.106.185]) by krusty.pcisys.net (8.12.5/8.12.5) with ESMTP id g9B5ZHp1003448 for ; Thu, 10 Oct 2002 23:35:21 -0600 (MDT) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Thu, 10 Oct 2002 23:35:18 -0600 Subject: Re: auto execute From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <3DA6432D.E253E07B@webphilippines.com> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/32 X-Sequence-Number: 1547 on 10/10/02 9:19 PM, ric.manalac@webphilippines.com purportedly said: > how can i make postgres to execute a query automatically during > scheduled times? > > here's my situation. i store records on a table. these records should be > removed 1 day after they were created. AFAIK, not solely within postgres. There needs to be some trigger point, which could be a cron-invoked function, a trigger based on some action on the table, or "cleanup" function that is called every time your app runs. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"