verify/articles_update_updated_at.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- 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;