Postgres Pro
Downloads
Home   >   mailing lists

Re: keeping track of inserts (periodical) into a table - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: keeping track of inserts (periodical) into a table
Date
Msg-id dmu3kf$dtb$1@news.hub.org
Whole thread Raw
In response to keeping track of inserts (periodical) into a table  (Assad Jarrahian <jarraa@gmail.com>)
List pgsql-general
Tree view 
"Assad Jarrahian" <jarraa@gmail.com> 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

pgsql-general by date:

Previous
From: Assad Jarrahian
Date:
Subject: keeping track of inserts (periodical) into a table
Next
From: Eugene Prokopiev
Date:
Subject: function in index expression and unnecessary function calls in select