diff options
author | MS <ms@taler.net> | 2023-12-03 16:43:48 +0100 |
---|---|---|
committer | MS <ms@taler.net> | 2023-12-03 16:43:48 +0100 |
commit | d148d5da3fdf88b7f1fbca02a71422d9942b58d0 (patch) | |
tree | bcb6253aa78cd961b6b312cc89f0e2610c979f95 /util | |
parent | e7774899c1750ecc59c2f1126d49b1bdbed1cc47 (diff) | |
download | libeufin-d148d5da3fdf88b7f1fbca02a71422d9942b58d0.tar.gz libeufin-d148d5da3fdf88b7f1fbca02a71422d9942b58d0.tar.bz2 libeufin-d148d5da3fdf88b7f1fbca02a71422d9942b58d0.zip |
fixing schema permissions: needs USAGE privilege
Diffstat (limited to 'util')
-rw-r--r-- | util/src/main/kotlin/DB.kt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/src/main/kotlin/DB.kt b/util/src/main/kotlin/DB.kt index bfa77236..ec7268f7 100644 --- 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 EXISTS (SELECT FROM pg_tables WHERE schemaname = '_v' AND tablename = 'patches')" + "SELECT schema_name FROM information_schema.schemata WHERE schema_name = '_v'" ) if (!checkVSchema.executeQueryCheck()) { logger.debug("_v schema not found, applying versioning.sql") |