From 26eda4262fa99888e254e9c19b40c04b2a29a75c Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan.goodliffe@octal.co.uk>
Date: Mon, 29 Jun 2026 09:33:57 +0100
Subject: Fix uniqueness of entities

Should be unique for value and type, they're not just strings, they can
be different things with the same value... Albeit rarely.
---
 src/sql/hostUpsert.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/sql/hostUpsert.sql')

diff --git a/src/sql/hostUpsert.sql b/src/sql/hostUpsert.sql
index d5ee11d..5c8be1e 100644
--- a/src/sql/hostUpsert.sql
+++ b/src/sql/hostUpsert.sql
@@ -1,7 +1,7 @@
 INSERT INTO entities(type, value, detail)
 	VALUES ('host', $1, jsonb_build_object('sysname', $2::text, 'release', $3::text,
 	'version', $4::text, 'machine', $5::text, 'domainname', $6::text))
-ON CONFLICT (md5(value))
+ON CONFLICT (md5(value), type)
 	DO UPDATE SET
 		detail = jsonb_build_object('sysname', $2::text, 'release', $3::text, 'version',
 		$4::text, 'machine', $5::text, 'domainname', $6::text)
-- 
cgit v1.3

