"Assad Jarrahian" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
