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);
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
