This is a discussion on Re: Can't create a batch job in pgagent within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto gadmin-support-owner@postgresql.org] On Behalf Of > Obe, Regina DND\MIS > Sent: 26 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto > 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 |