Mercurial > gemma
view schema/updates/1104/01.remove_function.sql @ 4808:db450fcc8ed7
client: add title for the exported image
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Tue, 29 Oct 2019 11:04:14 +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();