Re: auto execute - Mailing list pgsql-php

From Bruno Wolff III
Subject Re: auto execute
Date
Msg-id 20021011120907.GA29853@wolff.to
Whole thread Raw
In response to auto execute  (Ric Mañalac <ric.manalac@webphilippines.com>)
List pgsql-php
On Fri, Oct 11, 2002 at 11:19:10 +0800,
  Ric Mañalac <ric.manalac@webphilippines.com> 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.

If they new to not be visible exactly 1 day after they are created, you
can use a view to do that. You will still want to run a cron job to
actually delete the records.

pgsql-php by date:

Previous
From: Keary Suska
Date:
Subject: Re: auto execute
Next
From: "Waruna Geekiyanage"
Date:
Subject: syncronize databases