blob: c6e7f4ff484f7fcc207167197f1b5504fed43b56 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE FUNCTION _api.user_update()
RETURNS TRIGGER
LANGUAGE plpgsql VOLATILE
AS $BODY$
DECLARE
_length INTEGER;
BEGIN
RETURN NEW;
END
$BODY$;
GRANT EXECUTE ON FUNCTION _api.user_update()
TO rest_user;
GRANT DELETE ON TABLE api.user
TO rest_user;
CREATE TRIGGER api_user_update_trgr
INSTEAD OF UPDATE
ON api.user
FOR EACH ROW
EXECUTE PROCEDURE _api.user_update();
|
