Author: dpage
Date: 2005-05-17 17:07:23 +0100 (Tue, 17 May 2005)
New Revision: 4197
Modified:
trunk/pgadmin3/xtra/pgagent/pgAgent.cpp
Log:
Nuvver typo. Need sleep now.
Modified: trunk/pgadmin3/xtra/pgagent/pgAgent.cpp
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgAgent.cpp 2005-05-17 16:05:23 UTC (rev
4196)
+++ trunk/pgadmin3/xtra/pgagent/pgAgent.cpp 2005-05-17 16:07:23 UTC (rev
4197)
@@ -53,7 +53,7 @@
" FROM pga_tmp_zombies Z "
" JOIN pgagent.pga_job J ON jobagentid=jagpid "
" JOIN pgagent.pga_joblog LG ON jlgjobid=J.jobid "
- " WHERE PR.jlgstatus='r';\n"
+ " WHERE LG.jlgstatus='r';\n"
"UPDATE pgagent.pga_job SET jobagentid=NULL, jobnextrun=NULL "
" FROM pga_tmp_zombies Z "
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
