| From: | Justin Clift <justin(at)postgresql(dot)org> |
|---|---|
| To: | Ric Mañalac <ric(dot)manalac(at)webphilippines(dot)com> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: auto execute |
| Date: | 2002-10-11 03:52:36 |
| Message-ID: | 3DA64B04.3C99179D@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keary Suska | 2002-10-11 05:35:18 | Re: auto execute |
| Previous Message | Ric Mañalac | 2002-10-11 03:19:10 | auto execute |