Mercurial > gemma

view schema/updates/1425/01.inline_utm_covers.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 388947a3050d
children
line wrap: on
line source

ALTER POLICY responsibility_area ON waterway.bottlenecks
    USING (staging_done
        OR (SELECT ST_Covers(a,
                ST_Transform(CAST(area AS geometry), ST_SRID(a)))
            FROM users.current_user_area_utm() AS a (a)))
    WITH CHECK ((SELECT ST_Covers(a,
            ST_Transform(CAST(area AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

ALTER POLICY responsibility_area ON waterway.sounding_results
    USING (staging_done
        OR (SELECT ST_Covers(a,
                ST_Transform(CAST(area AS geometry), ST_SRID(a)))
            FROM users.current_user_area_utm() AS a (a)))
    WITH CHECK ((SELECT ST_Covers(a,
            ST_Transform(CAST(area AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

ALTER POLICY responsibility_area ON waterway.fairway_dimensions
    USING (staging_done
        OR (SELECT ST_Covers(a,
                ST_Transform(CAST(area AS geometry), ST_SRID(a)))
            FROM users.current_user_area_utm() AS a (a)))
    WITH CHECK ((SELECT ST_Covers(a,
            ST_Transform(CAST(area AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

ALTER POLICY responsibility_area_insert ON waterway.waterway_axis
    WITH CHECK ((SELECT ST_Covers(a,
            ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

ALTER POLICY responsibility_area_update ON waterway.waterway_axis
    USING ((SELECT ST_Covers(a,
            ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

ALTER POLICY responsibility_area_delete ON waterway.waterway_axis
    USING ((SELECT ST_Covers(a,
            ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
        FROM users.current_user_area_utm() AS a (a)));

DROP FUNCTION users.utm_covers;