diff options
Diffstat (limited to '')
| -rw-r--r-- | src/db/rest/util/_api_serve_media.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/db/rest/util/_api_serve_media.sql b/src/db/rest/util/_api_serve_media.sql index 8b0f0b8..c2e213a 100644 --- a/src/db/rest/util/_api_serve_media.sql +++ b/src/db/rest/util/_api_serve_media.sql @@ -1,5 +1,5 @@ CREATE FUNCTION _api.serve_media( - _name TEXT + _media_id INTEGER ) RETURNS sys."*/*" LANGUAGE plpgsql VOLATILE @@ -15,13 +15,13 @@ BEGIN '{"Cache-Control": "max-age=259200"}]' , m.type, m.name) FROM admin.media m - WHERE m.name = _name INTO _headers; + WHERE m.id = _media_id INTO _headers; PERFORM SET_CONFIG('response.headers', _headers, true); SELECT m.content FROM admin.media m - WHERE m.name = _name + WHERE m.id = _media_id INTO _data; IF FOUND THEN @@ -35,7 +35,7 @@ BEGIN END $BODY$; -GRANT EXECUTE ON FUNCTION _api.serve_media(TEXT) +GRANT EXECUTE ON FUNCTION _api.serve_media(INTEGER) TO rest_anon, rest_user; GRANT SELECT ON TABLE admin.media TO rest_anon, rest_user; |