Re: RFC: pgAgent Scheduler Design - Mailing list pgadmin-hackers

From Dave Page
Subject Re: RFC: pgAgent Scheduler Design
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E472BAD9@ratbert.vale-housing.co.uk
Whole thread Raw
In response to RFC: pgAgent Scheduler Design  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-hackers

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 11 March 2005 19:30
> To: Dave Page
> Cc: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] RFC: pgAgent Scheduler Design
>
> You do.
>
> int rc=serviceConn->ExecuteVoid(
>       "UPDATE ... SET jobagentpid=pg_backend_pid() ...
>           WHERE jobagentid IS NULL ...");
>
> if (rc == 1) // i.e. if exactly one row was affected, it's
> our job now.

Yeah, I saw that, but looking again I missed job::Runnable() in the
header.

So that's alright then! :-)

/D

pgadmin-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: RFC: pgAgent Scheduler Design
Next
From: "Florian G. Pflug"
Date:
Subject: [PATCH] Various OSX fixes & .app bundle building support