view schema/updates/1104/01.remove_function.sql @ 5539:90ba92820b26 aggregate-gm-import-logging

Merged default into aggregate-gm-import-logging branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 26 Oct 2021 00:05:28 +0200
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();