Re: automatic verifications - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: automatic verifications
Date
Msg-id 20031218223724.GA3804@wolff.to
Whole thread Raw
In response to automatic verifications  (Melanie Bergeron <mbergeron_pg@globeecom.com>)
Responses Re: automatic verifications
List pgsql-general
On Thu, Dec 18, 2003 at 17:05:30 -0500,
  Melanie Bergeron <mbergeron_pg@globeecom.com> wrote:
> Hi!
>
> I am new with PostgreSQL and I want to know if this database give the
> possibility  to verify automatically, each night, if some records are
> too old (by example, if session_date is older than a month) and if so
> delete them.

The normal way to do that would be to run a daily cron job that deletes
all of the records with session date older than one month.

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: automatic verifications
Next
From: Reece Hart
Date:
Subject: Re: md5 function