Mercurial > gemma
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