PgAdmin III 1.10 1 beta can't create pgagent batch job steps

From: "Paragon Corporation" <lr(at)pcorp(dot)us>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: PgAdmin III 1.10 1 beta can't create pgagent batch job steps
Date: 2009-04-07 05:45:44
Message-ID: 994F6A256ED04A939D8005F861B4C517@b
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

This worked in pgAdmin III 1.8 and I believe it worked in 1.9 beta too.

When I try to create a batch job step with 1.10 beta 1, I get an error -
looking at the sql it looks like its missing the last argument jstdbname

Creating SQL jobs seems to work fine though.

I tried against both a PostgreSQL 8.2 running on windows and a PostgreSQL
8.3 running on Linux to create a batch job step.

The malformed sql it creates looks like this

INSERT INTO pgagent.pga_jobstep (jstid, jstjobid, jstname, jstdesc,
jstenabled, jstkind, jstonerror, jstcode, jstdbname)
SELECT <StpId>, 1, 'test', '', true, 'b', 'f', E'batch command here', ;

Thanks,
Regina

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2009-04-07 05:50:08 Re: EXPLAIN format changes
Previous Message svn 2009-04-06 20:40:05 SVN Commit by dpage: r7799 - trunk/pgadmin3/pgadmin/debugger

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2009-04-07 08:12:02 Re: [pgadmin-support] PgAdmin III 1.10 1 beta can't create pgagent batch job steps
Previous Message Dave Page 2009-04-06 09:44:46 Re: [pgadmin-support] PgAdmin 1.10 beta 1 - scratch pad won't go away