summaryrefslogtreecommitdiff
path: root/db/rest/post/api_post_update.sql
blob: 915d0cdbd05d0eb3b3bd8f03adec2563e2dbc900 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE FUNCTION _api.post_update()
RETURNS TRIGGER
LANGUAGE plpgsql VOLATILE
AS $BODY$
DECLARE
	_length INTEGER;
BEGIN
	RETURN NEW;
END
$BODY$;

GRANT EXECUTE ON FUNCTION _api.post_update() TO rest_user;

CREATE TRIGGER api_post_update_trgr
	INSTEAD OF UPDATE
			ON api.post
			FOR EACH ROW
				EXECUTE PROCEDURE _api.post_update();