Mercurial > gemma
view schema/updates/1425/01.inline_utm_covers.sql @ 5420:851c14d57680 marking-single-beam
Merged default into marking-single-beam branch.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 08 Jul 2021 00:14:58 +0200 |
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;