scripts/entry_limit_trigger.pgsql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

CREATE OR REPLACE FUNCTION milla.janitor ()
    RETURNS TRIGGER
    AS $$
BEGIN
    UPDATE
        posts
    SET
        updated_at = now()
    WHERE
        id = NEW.id;
    RETURN new;
END;
$$
LANGUAGE plpgsql;

CREATE TRIGGER janitor_trigger
    AFTER INSERT ON milla.tables
    EXECUTE PROCEDURE milla.janitor ();