Temporal Event

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

On Wed, 2002-07-03 at 08:20, 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.

man crontab

Cron is your friend here. Just write a cronjob that invokes psql and
the appropriate SQL statement(s).

I do this with some of my daily maintenance stuff.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

On Wed, Jul 03, 2002 at 10:20:50AM -0300, 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.

Use cron.

PostgreSQL currently doesn't support periodic command scheduling
(and a good argument can be made that it shouldn't, since we'd
just be rewriting cron inside PostgreSQL).

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

Can't you just run a cronjob executing a query?
Something like this in your crontab:
0 12 * * * su - postgres -c "psql < your.job.sql"

eunice palmeira wrote:

This is a problem for your cron daemon. Look outside of postgresql for the
solution to this one.

Joshua b. Jore ; http://www.greentechnologist.org

On Wed, 3 Jul 2002, [iso-8859-1] eunice palmeira wrote: