deploy/items_update_timestamp.sql


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

-- Deploy kakeibo:items_update_timestamp to pg
-- requires: items
-- requires: update_timestamp

BEGIN;

CREATE OR REPLACE TRIGGER update_timestamp
  BEFORE UPDATE ON kakeibo.items
  FOR EACH ROW
    EXECUTE FUNCTION kakeibo.update_timestamp();

COMMIT;