-- Deploy photos:diaries_update_timestamp to pg -- requires: schema -- requires: diaries -- requires: update_timestamp BEGIN; SET search_path to photos; CREATE OR REPLACE TRIGGER update_timestamp BEFORE UPDATE ON diaries FOR EACH ROW EXECUTE FUNCTION update_timestamp(); COMMIT;