Mercurial > gemma
view schema/updates/1104/01.remove_function.sql @ 5082:c4ebb6ccc588 time-sliding
client: start a request for the last changed time on time slider
* initiate a refresh layers request when the time for the
finished request differs from the selected time on time slider
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Wed, 18 Mar 2020 14:11:44 +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();