blob: 50f348e88dcd8c7c985aa9302f8e5106a22d9d40 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
-- Verify kakeibo:transactions_update_timestamp on pg
BEGIN;
DO $$
BEGIN
ASSERT (SELECT 1 from information_schema.triggers
WHERE trigger_schema = 'kakeibo'
AND event_object_table = 'transactions'
AND trigger_name = 'update_timestamp');
END
$$;
ROLLBACK;
|