Search Postgresql Archives

Re: Time trigger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux