Skip site navigation (1) Skip section navigation (2)

Re: Can we have time based triggers in Postgresql??

From: "Chris Boget" <chris(at)wild(dot)net>
To: "Shanmugasundaram Doraisamy" <shan(at)ceedees(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: Can we have time based triggers in Postgresql??
Date: 2004-03-30 19:45:45
Message-ID: 01db01c4168f$984f3a40$8c01a8c0@entropy (view raw or flat)
Thread:
Lists: pgsql-general
>                       I would like to know if can have a time based
> trigger, for example a procedure that could be run everyday at say 10 in
> the night.  Thanking you,

Isn't this what cron is for?  Just set it up so it invokes pg with a command
line
query.

Chris



In response to

pgsql-general by date

Next:From: Diogo BiazusDate: 2004-03-30 21:55:07
Subject: Wich hardware suits best for large full-text indexed databases
Previous:From: Dave PageDate: 2004-03-30 18:01:57
Subject: Re: Error on deleting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group