Using 1.6.2pre on ubuntu (updated from 1.6) with postgres-8.3
When I try to delete a template I get this errormessage:

Code:
2009-01-15 13:36:39 CET ERROR: operator does not exist: character varying = integer at character 78
2009-01-15 13:36:39 CET HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: UPDATE actions SET status=1 WHERE (actionid IN (-1))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles WHERE (hostid IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts_profiles_ext WHERE (hostid IN (10102))
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: SELECT DISTINCT ht.* FROM httptest ht, applications ap WHERE (ap.hostid IN (10102)) AND ht.applicationid=ap.applicationid
2009-01-15 13:36:39 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2009-01-15 13:36:39 CET STATEMENT: DELETE FROM hosts WHERE (hostid IN (10102))

http://www.zabbix.com/forum/showthread.php?t=11519