merchant

commit f6de141e14b2f78234362de18d948563f805ee26
parent b22242ec7f2f8154312f3df3a258caa36f7f3aea
Author: Florian Dold <florian@dold.me>
Date:   Sun, 16 Nov 2025 19:55:52 +0100

alter pg_trgm created in merchant-0025, put public in search path where required

Diffstat:
M
src/backenddb/merchant-0025.sql
 | 
2
+-
M
src/backenddb/merchant-0026.sql
 | 
6
+++++-

2 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/merchant-0025.sql b/src/backenddb/merchant-0025.sql
@@ -29,7 +29,7 @@ SET search_path TO public;
 -- We will need this for LIKE-style pattern matching "gin" indices.
 CREATE EXTENSION IF NOT EXISTS pg_trgm;
 
-SET search_path TO merchant;
+SET search_path TO merchant, public;
 
 
 -- See enum GNUNET_TIME_RounderInterval
diff --git a/src/backenddb/merchant-0026.sql b/src/backenddb/merchant-0026.sql
@@ -28,7 +28,11 @@ SET search_path TO public;
 
 CREATE EXTENSION IF NOT EXISTS pgcrypto;
 
-SET search_path TO merchant;
+-- Was created by merchant-0025.sql
+ALTER EXTENSION pgcrypto SET SCHEMA public;
+ALTER EXTENSION pg_trgm SET SCHEMA public;
+
+SET search_path TO merchant, public;
 
 ALTER TABLE merchant_inventory
   ADD COLUMN image_hash TEXT;