On Thu, Jul 14, 2005 at 02:24:17AM -0700, Vivek wrote: > I am developing a database system using PostgreSQL in which I should be > able to delete redundant records once a year (Time specified by the > user). THe redundant records should be inserted into the archive table > which is part of the same database. > > Is this possible in pgsql? Can I program a function in SQL or a trigger > to fire when the computer switches on say Jan 1 of every year?
This is asked and answered from time to time; search the archives for past discussion. The usual answer is to use your operating system's mechanism for scheduling period jobs, e.g., cron on Unix. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
