Re: Time trigger

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Piechu Piechu <piechutm(at)wp(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Time trigger
Date: 2005-11-10 12:16:03
Message-ID: 43733A03.7000206@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Piechu Piechu schrieb:
> hello
>
> I'm new in this list, so sorry if my question seems stupid
>
> Is it possible to invoke store procedure because of time, I mean for example I want my procedure to be invoked every ten minutes - what should I do to reach this goal
>

Usually one takes the system cron service to start a script
which in turn acts on the database in the way you want.
Since you are using windows, you perhaps have no built in
way (although I remember there was an ability with IE
offline pages you can use to timely trigger things iirc)
but there are many "cron" - like tools for download
you could use.

Postgres has currently no built in for that because
the vast number of instances run on some unices where
cron is common.

HTH
Tino Wildenhain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-11-10 12:29:35 Re: PL language selection
Previous Message A. Kretschmer 2005-11-10 12:12:11 Re: Time trigger