Re: [GENERAL] "trigger"ing a procedure every X minutes

2001-06-06 Thread Len Morgan
>> It's certainly not a big deal to use the cron, I just thought maybe someone >> had experimented with an internal mechanism. I'd like to try it someday, >> when I know a lot more about Pg. My current project has an ever-growing >> number of cron jobs (up to 6 now) and was just thinking about v

Re: [GENERAL] "trigger"ing a procedure every X minutes

2001-06-06 Thread Herbert.Liechti
On Wed, 6 Jun 2001, Fran Fabrizio wrote: > > Some thoughts are: > > 1. It would be portable with the database. I don't have to go setting up > crons on the new machine if I move the db. > 2. The cron usually involves writing a shell/perl/whatever script to call > the psql client and pass in SQ

Re: [GENERAL] "trigger"ing a procedure every X minutes

2001-06-06 Thread Fran Fabrizio
Some thoughts are: 1. It would be portable with the database. I don't have to go setting up crons on the new machine if I move the db. 2. The cron usually involves writing a shell/perl/whatever script to call the psql client and pass in SQL queries via STDIN or file redirect just to invoke th