Re: Temporal Event

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br>
Cc: alewis(at)themecca(dot)net, pgsql-general(at)postgreSQL(dot)org
Subject: Re: Temporal Event
Date: 2002-07-03 20:44:06
Message-ID: Pine.LNX.4.21.0207032141510.2828-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2002-07-03 20:46:46 I am being interviewed by OReilly
Previous Message Bruce Momjian 2002-07-03 20:21:35 Re: EVAL and SET equivalents in PostgreSQL