Re: [pgadmin-support] Quick pgagent bug fix

2007-11-28 Thread Dave Page
Brian Kalbfus wrote: > > The SQL will return a row if the jobhostagent field matches every time > (the OR clause is on the same level as all the AND clauses). We need to > group the last two clauses: Thanks Brian, I've applied a patch per your suggestion. Regards, Dave.

[pgadmin-support] Quick pgagent bug fix

2007-11-28 Thread Brian Kalbfus
I have two jobs scheduled and the second one ran every poll interval, regardless of any schedule I put in it. I traced the cause to the "host agent" field being populated. Looking at the source of pgAgent.cpp, from 5 weeks ago, I see the following query being used to check if the agent should