Thread: ...
hello,I need to know if there are any database event triggers in postgres like i want the trigger to run periodically(every day just like crontab on unix), i need to delete the records in a table automatically after a period of say 90 days. It is possible to create trigger on table before insert or update but if there are no insertions or updations on the table, the record will remain in the database. looking forward for the suggestions. Thanx in advance Hema _____________________________________ Powered by EBHASIN V-Mail Service. Visit http://www.ebhasin.com
Hi, Even i would love to hear if there is any such feature. but there is an easy work around, use the unix crontab and -c option of psql to pass the query from the crontab file it self. regds mallah. On Thursday 23 May 2002 04:57 pm, rhema@bhasin.co.in wrote: > hello, > I need to know if there are any database event triggers > in postgres like i want the trigger to run periodically(every day just like > crontab on unix), i need to delete the records in a table automatically > after a period of say 90 days. > > It is possible to create trigger on table before insert or update but if > there are no insertions or updations on the table, the record will remain > in the database. > looking forward for the suggestions. > > Thanx in advance > Hema > > _____________________________________ > Powered by EBHASIN V-Mail Service. > Visit http://www.ebhasin.com > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
On Thu, May 23, 2002 at 11:27:20 +0000, rhema@bhasin.co.in wrote: > hello, > I need to know if there are any database event triggers > in postgres like i want the trigger to run periodically(every day just like > crontab on unix), i need to delete the records in a table automatically > after a period of say 90 days. > > It is possible to create trigger on table before insert or update but if > there are no insertions or updations on the table, the record will remain > in the database. > looking forward for the suggestions. Probably you just ran to run a cron job that deletes records older than 90 days in order to reclaim space. If it is important that transactions not see this older data, than you want to write your selects so that older records are not visible.