Log Message:
-----------
Refresh tree properly after editting Agent objects.
Modified Files:
--------------
pgadmin3/src/agent:
pgaJob.cpp (r1.16 -> r1.17)
pgaSchedule.cpp (r1.21 -> r1.22)
pgaStep.cpp (r1.17 -> r1.18)
Index: pgaSchedule.cpp
===================================================================
RCS file: /projects/pgadmin3/src/agent/pgaSchedule.cpp,v
retrieving revision 1.21
retrieving revision 1.22
diff -Lsrc/agent/pgaSchedule.cpp -Lsrc/agent/pgaSchedule.cpp -u -w -r1.21 -r1.22
--- src/agent/pgaSchedule.cpp
+++ src/agent/pgaSchedule.cpp
@@ -80,7 +80,7 @@
{
pgCollection *obj=(pgCollection*)browser->GetItemData(parentItem);
if (obj->GetType() == PGA_SCHEDULES)
- schedule = ReadObjects(obj, 0);
+ schedule = ReadObjects(obj, 0, wxT("\n AND jscid=") +
NumToStr(GetRecId()));
}
return schedule;
}
Index: pgaStep.cpp
===================================================================
RCS file: /projects/pgadmin3/src/agent/pgaStep.cpp,v
retrieving revision 1.17
retrieving revision 1.18
diff -Lsrc/agent/pgaStep.cpp -Lsrc/agent/pgaStep.cpp -u -w -r1.17 -r1.18
--- src/agent/pgaStep.cpp
+++ src/agent/pgaStep.cpp
@@ -74,7 +74,7 @@
{
pgCollection *obj=(pgCollection*)browser->GetItemData(parentItem);
if (obj->GetType() == PGA_STEPS)
- Step = ReadObjects(obj, 0);
+ Step = ReadObjects(obj, 0, wxT("\n AND jstid=") +
NumToStr(GetRecId()));
}
return Step;
}
Index: pgaJob.cpp
===================================================================
RCS file: /projects/pgadmin3/src/agent/pgaJob.cpp,v
retrieving revision 1.16
retrieving revision 1.17
diff -Lsrc/agent/pgaJob.cpp -Lsrc/agent/pgaJob.cpp -u -w -r1.16 -r1.17
--- src/agent/pgaJob.cpp
+++ src/agent/pgaJob.cpp
@@ -107,7 +107,7 @@
{
pgObject *obj=(pgObject*)browser->GetItemData(parentItem);
if (obj->GetType() == PGA_JOBS)
- job = ReadObjects((pgCollection*)obj, 0);
+ job = ReadObjects((pgCollection*)obj, 0, wxT("\n WHERE
j.jobid=") + NumToStr(GetRecId()));
}
return job;
}
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match