aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-02-28 21:00:18 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-02 09:22:36 +0900
commit343155aab78c28d6d09bea75671b390aec9599f6 (patch)
treece21628e140de64ee748734df1ae081dbd1b002c /verify
parent8102191eb96a7f5a7cd2baf2711c273f179a11e4 (diff)
Add function to delete a traansaction.
Diffstat (limited to 'verify')
-rw-r--r--verify/delete_transaction.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/verify/delete_transaction.sql b/verify/delete_transaction.sql
new file mode 100644
index 0000000..13a6cd3
--- /dev/null
+++ b/verify/delete_transaction.sql
@@ -0,0 +1,7 @@
+-- Verify kakeibo:delete_transaction on pg
+
+BEGIN;
+
+SELECT has_function_privilege('kakeibo.delete_transaction(integer)', 'execute');
+
+ROLLBACK;