From 8102191eb96a7f5a7cd2baf2711c273f179a11e4 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Feb 2023 10:11:02 +0900 Subject: Add function to insert transaction. --- verify/insert_transaction.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 verify/insert_transaction.sql (limited to 'verify') diff --git a/verify/insert_transaction.sql b/verify/insert_transaction.sql new file mode 100644 index 0000000..a591157 --- /dev/null +++ b/verify/insert_transaction.sql @@ -0,0 +1,7 @@ +-- Verify kakeibo:insert_transaction on pg + +BEGIN; + +SELECT has_function_privilege('kakeibo.insert_transaction(kakeibo.transaction_type, date, text)', 'execute'); + +ROLLBACK; -- cgit v1.2.3