Re: [HACKERS] pgAgent job limit

2008-02-26 Thread Roberts, Jon
> -Original Message- > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 26, 2008 8:17 AM > To: Roberts, Jon > Cc: Andrew Dunstan; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] pgAgent job limit > > On Tue, Feb 26, 2008 at 08:10:

Re: [HACKERS] pgAgent job limit

2008-02-26 Thread Magnus Hagander
On Tue, Feb 26, 2008 at 08:10:09AM -0600, Roberts, Jon wrote: > > Roberts, Jon wrote: > > > In pgAgent.cpp, I would like to add LIMIT as shown below: > > > > > > > > > > > > > [snip] > > > > > What do you guys think? > > > > > > > > > > > > > What has this to do with -hackers? > > > > I don't e

Re: [HACKERS] pgAgent job limit

2008-02-26 Thread Alvaro Herrera
Roberts, Jon wrote: > > Roberts, Jon wrote: > > > In pgAgent.cpp, I would like to add LIMIT as shown below: > > > What do you guys think? > > > > What has this to do with -hackers? > > > > I don't even know what project this refers to - it certainly doesn't > > refer to core postgres, which is w

Re: [HACKERS] pgAgent job limit

2008-02-26 Thread Roberts, Jon
> Roberts, Jon wrote: > > In pgAgent.cpp, I would like to add LIMIT as shown below: > > > > > > > > [snip] > > > What do you guys think? > > > > > > > > What has this to do with -hackers? > > I don't even know what project this refers to - it certainly doesn't > refer to core postgres, which is

Re: [HACKERS] pgAgent job limit

2008-02-26 Thread Andrew Dunstan
Roberts, Jon wrote: In pgAgent.cpp, I would like to add LIMIT as shown below: [snip] What do you guys think? What has this to do with -hackers? I don't even know what project this refers to - it certainly doesn't refer to core postgres, which is what -hackers is about. cheer

[HACKERS] pgAgent job limit

2008-02-26 Thread Roberts, Jon
In pgAgent.cpp, I would like to add LIMIT as shown below: LogMessage(_("Checking for jobs to run"), LOG_DEBUG); DBresult *res=serviceConn->Execute( wxT("SELECT J.jobid ") wxT(" FROM pgagent.pga_job J ") wxT(" WHERE jobenabled ") wxT(" AND jobagentid IS NULL ") wxT(" AND jobnextrun <= now