Thread: 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,
Regina

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Obe, Regina DND\MIS
> Sent: 26 September 2005 13:40
> To: 'pgadmin-support@postgresql.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.