- fixed removing of an item under PostgreSQL (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@1181 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 9 insertions, 0 deletions

diff --git a/frontends/php/include/config.inc.php b/frontends/php/include/config.inc.php
index 2f23c18d..fe3e1162 100644
--- a/frontends/php/include/config.inc.php
+++ b/frontends/php/include/config.inc.php
@@ -2142,6 +2142,14 @@ where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=$triggerid";
 		return	DBexecute($sql);
 	}
 
+	# Delete from Trends
+
+	function	delete_trends_by_itemid( $itemid )
+	{
+		$sql="delete from trends where itemid=$itemid";
+		return	DBexecute($sql);
+	}
+
 	function	delete_trigger_dependency($triggerid_down,$triggerid_up)
 	{
 
@@ -2338,6 +2346,7 @@ where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=$triggerid";
 		{
 			return	$result;
 		}
+		$result=delete_trends_by_itemid($itemid);
 		$result=delete_history_by_itemid($itemid);
 		$sql="delete from graphs_items where itemid=$itemid";
 		if(!$result)