SVN Commit by dpage: r4214 - trunk/pgadmin3/xtra/pgagent - Mailing list pgadmin-hackers

Author: dpage
Date: 2005-05-19 10:27:24 +0100 (Thu, 19 May 2005)
New Revision: 4214

Modified:
   trunk/pgadmin3/xtra/pgagent/job.cpp
   trunk/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Rename jslstarted -> jslstart for consistency

Modified: trunk/pgadmin3/xtra/pgagent/job.cpp
===================================================================
--- trunk/pgadmin3/xtra/pgagent/job.cpp    2005-05-19 08:31:32 UTC (rev 4213)
+++ trunk/pgadmin3/xtra/pgagent/job.cpp    2005-05-19 09:27:24 UTC (rev 4214)
@@ -144,7 +144,7 @@

         rc=serviceConn->ExecuteVoid(
             "UPDATE pgagent.pga_jobsteplog "
-            "   SET jslduration = now() - jslstarted, "
+            "   SET jslduration = now() - jslstart, "
             "       jslresult = " + NumToStr(rc) + ", jslstatus = '" + stepstatus + "' "
             " WHERE jslid=" + jpsid);
         if (rc != 1 || stepstatus == "f")

Modified: trunk/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-05-19 08:31:32 UTC (rev 4213)
+++ trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-05-19 09:27:24 UTC (rev 4214)
@@ -131,7 +131,7 @@
 jslcode              text                 NOT NULL,
 jslstatus            char                 NOT NULL CHECK (jslstatus IN ('r', 's', 'i', 'f')) DEFAULT 'r', -- running,
success,ignored, failed 
 jslresult            int2                 NULL,
-jslstarted           timestamptz          NOT NULL DEFAULT current_timestamp,
+jslstart             timestamptz          NOT NULL DEFAULT current_timestamp,
 jslduration          interval             NULL
 ) WITHOUT OIDS;
 CREATE INDEX pga_jobsteplog_jslid ON pgagent.pga_jobsteplog(jsljlgid);