Re: keeping track of inserts (periodical) into a table

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: keeping track of inserts (periodical) into a table
Date: 2005-12-04 06:51:52
Message-ID: dmu3kf$dtb$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Assad Jarrahian" <jarraa(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurent Herve 2005-12-04 09:10:41 Fwd: Enhancement Request : Expressions for format string in PlPgsql RAISE statement
Previous Message Assad Jarrahian 2005-12-04 06:33:02 keeping track of inserts (periodical) into a table