libeufin

commit e7774899c1750ecc59c2f1126d49b1bdbed1cc47
parent 04ae8385b3c154630b13cba4a9a1e588d43d516a
Author: MS <ms@taler.net>
Date:   Sun,  3 Dec 2023 16:26:04 +0100

fixing _v existence check

Diffstat:
M
util/src/main/kotlin/DB.kt
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/util/src/main/kotlin/DB.kt b/util/src/main/kotlin/DB.kt
@@ -196,7 +196,7 @@ fun PreparedStatement.executeProcedureViolation(): Boolean {
 fun maybeApplyV(conn: PgConnection, cfg: DatabaseConfig) {
     conn.transaction {
         val checkVSchema = conn.prepareStatement(
-            "SELECT schema_name FROM information_schema.schemata WHERE schema_name = '_v'"
+            "SELECT EXISTS (SELECT FROM pg_tables WHERE schemaname = '_v' AND tablename  = 'patches')"
         )
         if (!checkVSchema.executeQueryCheck()) {
             logger.debug("_v schema not found, applying versioning.sql")