auto execute
auto execute
От:
Ric Mañalac <ric.manalac@webphilippines.com>
Дата:
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
Re: auto execute
От:
Justin Clift <justin@postgresql.org>
Дата:
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
Re: auto execute
От:
Keary Suska <hierophant@pcisys.net>
Дата:
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"
Re: auto execute
От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Fri, Oct 11, 2002 at 11:19:10 +0800, 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. 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.