Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3169F475F00 for ; Thu, 10 Oct 2002 23:52:46 -0400 (EDT) Received: from new-smtp1.ihug.com.au (new-smtp1.ihug.com.au [203.109.250.27]) by postgresql.org (Postfix) with ESMTP id E89D4475E2B for ; Thu, 10 Oct 2002 23:52:44 -0400 (EDT) Received: from p89-tnt2.mel.ihug.com.au (postgresql.org) [203.173.164.89] by new-smtp1.ihug.com.au with esmtp (Exim 3.22 #1 (Debian)) id 17zqqs-0001KS-00; Fri, 11 Oct 2002 13:52:38 +1000 Message-ID: <3DA64B04.3C99179D@postgresql.org> Date: Fri, 11 Oct 2002 13:52:36 +1000 From: Justin Clift X-Mailer: Mozilla 4.79 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Ric =?iso-8859-1?Q?Ma=F1alac?= Cc: pgsql-php@postgresql.org Subject: Re: auto execute References: <3DA6432D.E253E07B@webphilippines.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/31 X-Sequence-Number: 1546 Hi Ric, You could use a cron job that executes a SQL statement to delete the old records. :-) Regards and best wishes, Justin Clift Ric Maņalac wrote: > > hello, > > 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. > > thanks. > > ric > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi