Re: Can't create a batch job in pgagent

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Obe, Regina DND\MIS
> Sent: 26 September 2005 13:40
> To: 'pgadmin-support(at)postgresql(dot)org'
> Subject: [pgadmin-support] Can't create a batch job in pgagent
> 
> I'm using the 9/19/05 build of pgAdmin with PostgreSQL 
> 8.1-beta2 and the
> pgagent.sql that comes with pgAdmin that to build the pgagent tables.
> 
> When you try to create a batch job, it fails the pga_jobstep_check
> constraint on the pga_jobstep table.  It appears that the 
> editor is trying
> to stuff a null into the jstdbname field when the constraint 
> is requiring an
> empty string.

Thanks for the report - I've committed a fix to SVN for this.

Regards, Dave.