"Assad Jarrahian" <jarraa@xxxxxxxxx> wrote > Hi all, > I have a design decission to make. I am using Lucene (Java Search > API) and I need to update lucenes index from time to time. > Is there a way one can keep track of all the inserts coming > into a table (holding onto their Primary key's are sufficient) and > then reseting that after a certain time period? > Check out the example here: http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html Regards, Qingqing
