| From: | Keary Suska <hierophant(at)pcisys(dot)net> |
|---|---|
| To: | Postgres-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: auto execute |
| Date: | 2002-10-11 05:35:18 |
| Message-ID: | B9CBBF36.1427F%hierophant@pcisys.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
on 10/10/02 9:19 PM, ric(dot)manalac(at)webphilippines(dot)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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-10-11 12:09:07 | Re: auto execute |
| Previous Message | Justin Clift | 2002-10-11 03:52:36 | Re: auto execute |