Mercurial > gemma
view schema/updates/1104/01.remove_function.sql @ 5301:955196acfcb5
Updated version for ongoing development.
author | wilde@azure1.rgb.intevation.de |
---|---|
date | Wed, 11 Nov 2020 11:09:07 +0100 |
parents | 5466562cca60 |
children |
line wrap: on
line source
DROP POLICY same_country ON import.imports; CREATE POLICY same_country ON import.imports FOR ALL TO waterway_admin USING (EXISTS(SELECT 1 FROM users.list_users lu WHERE lu.username = imports.username)); ALTER TABLE users.templates ALTER COLUMN country DROP DEFAULT; CREATE OR REPLACE FUNCTION users.current_user_area_utm() RETURNS geometry AS $$ DECLARE utm_area geometry; BEGIN SELECT ST_Transform(area::geometry, best_utm(area)) INTO STRICT utm_area FROM users.responsibility_areas WHERE country = (SELECT country FROM users.list_users WHERE username = current_user); RETURN utm_area; END; $$ LANGUAGE plpgsql STABLE PARALLEL SAFE; DROP FUNCTION users.current_user_country();