on 10/10/02 9:19 PM, ric.manalac@xxxxxxxxxxxxxxxxxx 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"
