merchant

commit cd0ff1f0bd80070eb4caf075807eea386053df21
parent 0da70eb44628f541ac6f56bd97de6a81eb8808cb
Author: Florian Dold <florian@dold.me>
Date:   Mon, 17 Nov 2025 00:28:00 +0100

digest function is now in public schema

Diffstat:
M
src/backenddb/pg_insert_product.sql
 | 
2
+-
M
src/backenddb/pg_update_product.sql
 | 
2
+-

2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/pg_insert_product.sql b/src/backenddb/pg_insert_product.sql
@@ -84,7 +84,7 @@ INSERT INTO merchant_inventory
  ,CASE
     WHEN (in_image IS NULL) OR (in_image = '')
     THEN NULL
-    ELSE encode(digest(convert_to(in_image, 'UTF8'),
+    ELSE encode(public.digest(convert_to(in_image, 'UTF8'),
                        'sha256'),
                 'hex')
   END
diff --git a/src/backenddb/pg_update_product.sql b/src/backenddb/pg_update_product.sql
@@ -129,7 +129,7 @@ UPDATE merchant_inventory SET
   ,image_hash=CASE
                WHEN (in_image IS NULL) OR (in_image = '')
                THEN NULL
-               ELSE encode(digest(convert_to(in_image, 'UTF8'),
+               ELSE encode(public.digest(convert_to(in_image, 'UTF8'),
                                   'sha256'),
                            'hex')
              END