Pgadmin - Can't create a batch job in pgagent

Author

Can't create a batch job in pgagent

Obe, Regina DND\\MIS

2005-09-26, 9:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Dave Page

2005-09-26, 9:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links