> -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:
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
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
> 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
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
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