diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-30 00:10:06 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:12:43 +0900 |
commit | 6d6f4546b0cda266e6f5e6f2cda783da985dfb00 (patch) | |
tree | 9211460cc6d9038e2d2d65c740687f15173e43da /verify | |
parent | c624400168c1f6b6d902a8eace3f722d5ca1eb90 (diff) |
Add function to update timestamp
Diffstat (limited to 'verify')
-rw-r--r-- | verify/update_timestamp.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/verify/update_timestamp.sql b/verify/update_timestamp.sql new file mode 100644 index 0000000..df5609d --- /dev/null +++ b/verify/update_timestamp.sql @@ -0,0 +1,9 @@ +-- Verify photos:update_timestamp on pg + +BEGIN; + +SET search_path to photos; + +SELECT has_function_privilege('update_timestamp()', 'EXECUTE'); + +ROLLBACK; |