summaryrefslogtreecommitdiff
path: root/verify/diaries_update_timestamp.sql
blob: 916653062e329fcbd9c70755a4e7bc44ea589d25 (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Verify photos:diaries_update_timestamp on pg

BEGIN;

DO $$
  BEGIN
    ASSERT (SELECT 1 from information_schema.triggers
             WHERE trigger_schema = 'photos'
               AND event_object_table = 'diaries'
               AND trigger_name = 'update_timestamp');
  END
$$;

ROLLBACK;