Hi Regina,
Thanks for reporting this.
This is a bug.
Dave,
Please find the patch for it.
Paragon Corporation wrote:
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
-
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: http://www.enterprisedb.com
Index: agent/dlgStep.cpp
===================================================================
--- agent/dlgStep.cpp (revision 7798)
+++ agent/dlgStep.cpp (working copy)
@@ -288,6 +288,11 @@
connstr = wxT("''");
}
}
+ else
+ {
+ db = wxT("''");
+ connstr = wxT("''");
+ }
sql = wxT("INSERT INTO pgagent.pga_jobstep (jstid, jstjobid, jstname, jstdesc, jstenabled, jstkind, jstonerror, jstcode, jstdbname");
if (hasConnStrSupport)
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
