Can't create a batch job in pgagent

From: "Obe, Regina DND\\MIS" <robe(dot)dnd(at)cityofboston(dot)gov>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Can't create a batch job in pgagent
Date: 2005-09-26 12:40:15
Message-ID: 35F9812087218F47B050D41D1B58298B086F1D@dnd5.dnd.boston.cob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-09-26 13:30:02 Re: Can't create a batch job in pgagent
Previous Message Dave Page 2005-09-25 09:58:55 Re: Current snapshots for SuSE Linux distribution