Re: Temporal Event - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: Temporal Event
Date
Msg-id Pine.LNX.4.21.0207032141510.2828-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Temporal Event  (eunice palmeira <e_palmeira@yahoo.com.br>)
List pgsql-general
On Wed, 3 Jul 2002, eunice palmeira wrote:

> Hi,
>   I would like to trigger a rule every day in the
> specific periodic time, such as: at 12:00 pm, in
> Postgresql. But i don't know if it is possible. Help
> me please.
>      Eunice Palmeira -- Maceió AL - Brasil


I don't believe this is possible from within the server. Your best bet is to
use a client program kicked off by a crontab entry.

I think Oracle does have such a facility though. Does anyone know and is it
something that should be added to Postgres?


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants




pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: One source of constant annoyance identified
Next
From: Bruce Momjian
Date:
Subject: Re: EVAL and SET equivalents in PostgreSQL