Re: Can't create a batch job in pgagent

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