Mercurial > gemma

comparison schema/auth.sql @ 5016:cf25b23e3eec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Keep historic data of waterway axis ... and accordingly configure the respective layer as WMS-T.
author Tom Gottfried <tom@intevation.de>
date Fri, 13 Mar 2020 17:34:59 +0100
parents 388947a3050d
children 4c658a8f34da
comparison
equal deleted inserted replaced
5015:df3cab060ed9 5016:cf25b23e3eec
210 WITH CHECK ((SELECT ST_Covers(a, 210 WITH CHECK ((SELECT ST_Covers(a,
211 ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a))) 211 ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
212 FROM users.current_user_area_utm() AS a (a))); 212 FROM users.current_user_area_utm() AS a (a)));
213 CREATE POLICY responsibility_area_update ON waterway.waterway_axis 213 CREATE POLICY responsibility_area_update ON waterway.waterway_axis
214 FOR UPDATE TO waterway_admin 214 FOR UPDATE TO waterway_admin
215 USING ((SELECT ST_Covers(a,
216 ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
217 FROM users.current_user_area_utm() AS a (a)));
218 CREATE POLICY responsibility_area_delete ON waterway.waterway_axis
219 FOR DELETE TO waterway_admin
220 USING ((SELECT ST_Covers(a, 215 USING ((SELECT ST_Covers(a,
221 ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a))) 216 ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
222 FROM users.current_user_area_utm() AS a (a))); 217 FROM users.current_user_area_utm() AS a (a)));
223 218
224 -- 219 --