view .hgtags @ 2855:8a8a929182f9

Enable import of axis and area independently from areas of responsibility In preparation of generating the areas of responsibility from data previously imported by a sys_admin! Having the CTE as an item in the FROM-list prevents the SELECT from returning any rows if the CTE returns no rows. Thus, use the CTE only in scalar subqueries that are relevant only if the statement is executed by somebody without sys_admin role. Also introduced an ST_CollectionExtract() in the axis INSERT because here too, the intersection is not guaranteed to have the right dimensionality.
author Tom Gottfried <tom@intevation.de>
date Thu, 28 Mar 2019 17:19:27 +0100
parents 28f1652cfb4d
children fc7b24f89164
line wrap: on
line source

532c8392048fe720bf31b7efb475591ab95a74ec v1-uat1
136aaa7f00af0b500c5c75f9fd9aabfc7fa526ee v1.1.0
724758455a4e44d25b096f00bcb353ceda0e0d57 v2-preview20190111
0059aa870a396e2112efae43f822c0c133454d7a v2
83f9a131dfb69f3ea1f430728a0831ccf96316d7 v2.1.0
83f9a131dfb69f3ea1f430728a0831ccf96316d7 v2.1.0
4d69b79e9df6e2b646ac60f75f6655bb3c64f6c6 v2.1.0