Does someone know how to integrate pgagent with Greenplum?

I could install it but it says that:

function cannot execute on segment because it issues a non-SELECT statement
(fucntion.c133) (seg0 localhost.localdomain:40000 pid=2780 (cdbisp.c1475)
 DETAIL SQL statement "UPDATE pgagent.pga_job SET jobnextrun = NULL WHERE
jobenalbed AND jobid=$1"

 PL/pgSQL function "pga_schedule_trigger" line 10 at SQL statement
<http://postgresql.1045698.n5.nabble.com/file/n5756084/pgadminIII.jpg> 



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Greenplum-pgagent-tp5756084.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Reply via email to