From 46827c3b9eaec65dd82fc4629904e1dcdd666aea Mon Sep 17 00:00:00 2001
From: Nicolas Franck <nicolas.franck@ugent.be>
Date: Wed, 20 Mar 2024 15:59:59 +0100
Subject: auto discover current schema, and create indexes on that schema

---
 lib/Catmandu/Store/DBI/Handler/Pg.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'lib/Catmandu/Store/DBI/Handler/Pg.pm')

diff --git a/lib/Catmandu/Store/DBI/Handler/Pg.pm b/lib/Catmandu/Store/DBI/Handler/Pg.pm
index af6178a..0f1e82a 100644
--- a/lib/Catmandu/Store/DBI/Handler/Pg.pm
+++ b/lib/Catmandu/Store/DBI/Handler/Pg.pm
@@ -66,10 +66,10 @@ IF NOT EXISTS (
     FROM   pg_class c
     JOIN   pg_namespace n ON n.oid = c.relnamespace
     WHERE  c.relname = '${name}_${col}_idx'
-    AND    n.nspname = 'public'
+    AND    n.nspname = (SELECT CURRENT_SCHEMA)
     ) THEN
 
-    CREATE INDEX ${name}_${col}_idx ON public.${name} (${q_col});
+    CREATE INDEX ${name}_${col}_idx ON ${name} (${q_col});
 END IF;
 
 END\$\$;
-- 
cgit v1.2.3