Skip site navigation (1) Skip section navigation (2)

Re: pgAgent bugs?

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: pgAgent bugs?
Date: 2007-10-29 20:53:46
Message-ID: 4726485A.3090807@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Roberts, Jon wrote:
> In job.cpp, it has this code to get the next job step:
> 
>     DBresult *steps=threadConn->Execute(
>         wxT("SELECT jstid, jstkind, jstdbname, jstcode, jstonerror ")
>         wxT("  FROM pgagent.pga_jobstep ")
>         wxT(" WHERE jstenabled ")
>         wxT("   AND jstjobid=") + jobid +
>         wxT(" ORDER BY jstname, jstid"));
> 
> If I had a job with step 1 called Zebra and step 2 called Apple, the above
> query would get and then execute step 2 first because of the order by
> clause.

This is intentional - for the same reason trigger execution is ordered
by name in PostgreSQL. It allows you to control the order of step
execution rather than have it fixed by the order in which you create the
steps.

> I also noticed with version 1.8 of the UI, if I change the On Error flags,
> nothing seems to happen.  If I insert a new step, I can make it Succeed,
> Fail, or Ignore but changes to this field using pgAdmin after the step has
> been created are ignored.

Yup - thats a bug. Fixed for 1.8.1 - thanks.

Regards, Dave.

In response to

pgadmin-hackers by date

Next:From: svnDate: 2007-10-29 21:11:10
Subject: SVN Commit by dpage: r6795 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/schema
Previous:From: svnDate: 2007-10-29 20:51:34
Subject: SVN Commit by dpage: r6794 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/agent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group