From 5111c39ad9c1665347471da9fc1ae5737e37cde5 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sun, 10 May 2026 00:41:56 +0100
Subject: Be specific about values from entities table

Fixes compatibility with PostgreSQL 18 which fails due to ambiguity.
---
 src/schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'src/schema.sql')

diff --git a/src/schema.sql b/src/schema.sql
index 056f7ac..e09be28 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -78,12 +78,12 @@ BEGIN
 	IF recid IS NULL THEN
 		RETURN query
 		SELECT
-			id,
-			detail IS NULL
+			e.id,
+			e.detail IS NULL
 		FROM
-			entities
+			entities e
 		WHERE
-			md5(value) = md5(newValue);
+			md5(e.value) = md5(newValue);
 	END IF;
 	RETURN query
 VALUES (recid,
-- 
cgit v1.3

