From 5111c39ad9c1665347471da9fc1ae5737e37cde5 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe 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(-) 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