From a927b30705d1e8c6b1b046e7512cc67cbdf19a21 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Wed, 13 Mar 2024 00:56:38 +0900 Subject: Remove update_updated_at functions. --- verify/articles_update_updated_at.sql | 14 -------------- verify/tags_update_updated_at.sql | 14 -------------- verify/update_updated_at.sql | 9 --------- 3 files changed, 37 deletions(-) delete mode 100644 verify/articles_update_updated_at.sql delete mode 100644 verify/tags_update_updated_at.sql delete mode 100644 verify/update_updated_at.sql (limited to 'verify') diff --git a/verify/articles_update_updated_at.sql b/verify/articles_update_updated_at.sql deleted file mode 100644 index 744b1fd..0000000 --- a/verify/articles_update_updated_at.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify diary:articles_update_updated_at on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'diary' - AND event_object_table = 'articles' - AND trigger_name = 'update_updated_at'); - END -$$; - -ROLLBACK; diff --git a/verify/tags_update_updated_at.sql b/verify/tags_update_updated_at.sql deleted file mode 100644 index e6940ce..0000000 --- a/verify/tags_update_updated_at.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Verify diary:tags_update_updated_at on pg - -BEGIN; - -DO $$ - BEGIN - ASSERT (SELECT 1 from information_schema.triggers - WHERE trigger_schema = 'diary' - AND event_object_table = 'tags' - AND trigger_name = 'update_updated_at'); - END -$$; - -ROLLBACK; diff --git a/verify/update_updated_at.sql b/verify/update_updated_at.sql deleted file mode 100644 index 59c71be..0000000 --- a/verify/update_updated_at.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Verify diary:update_updated_at on pg - -BEGIN; - -SET search_path to diary; - -SELECT has_function_privilege('update_updated_at()', 'EXECUTE'); - -ROLLBACK; -- cgit v1.2.3