scheduling stored procedure

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: scheduling stored procedure
Date: 2008-03-23 16:08:52
Message-ID: 75645bbb0803230908v4463c85p7cb015f165d7bee3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a temporary table in which i store all emails of users who want to
receive a newsletter.
to avoid spamming and to limit the size of this table, i would like to
delete all requests (records) which are older than 72 hours.

i was thinking to execute each hour a stored procedure which will check the
time and date (of now) if it is greater than "registration request time"
stored in this temporary table.
if it is greater, so record will be deleted.

does postgresql have such timer (something like "cron" under unix/linux) ?

thanks a lot,

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-03-23 16:18:55 Re: scheduling stored procedure
Previous Message Tom Lane 2008-03-23 15:59:20 Re: --enable-thread-safety bug