Re: "trigger"ing a procedure every X minutes

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "trigger"ing a procedure every X minutes
Date: 2001-06-06 17:22:58
Message-ID: m3ofs1v7yl.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net> writes:

> Is the preferred method of calling a procedure every X minutes to have a
> cronjob installed external to the database, or is there something I can
> do internally to achieve the same effect (and would be portable along
> with the database when/if I move it to a different machine)?

I'm pretty sure there is no internal mechanism for scheduled
procedures. I think the cronjob is your best bet.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2001-06-06 17:42:51 Re: Something odd with Postgresql 6.5
Previous Message jmscott@REMOVEMEyahoo.com 2001-06-06 17:07:35 maximum number of rows in table - what about oid limits?