diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-02-28 10:11:02 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-02 09:22:35 +0900 |
| commit | 8102191eb96a7f5a7cd2baf2711c273f179a11e4 (patch) | |
| tree | 555c06fdd196db1a81ac6bec0c5368157f4371cd /verify/insert_transaction.sql | |
| parent | 54e3c3f3e15a01b4ebf6ed43cc4b64cfba59ff36 (diff) | |
Add function to insert transaction.
Diffstat (limited to 'verify/insert_transaction.sql')
| -rw-r--r-- | verify/insert_transaction.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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; |