Mercurial > lada > lada-server
view db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1315:84bb7e2aecb1
Do not redefine existing operator.
The removed SQL failed on PostgreSQL 9.5 because the operator is
provided and needed by the system. Further, it does not seem to be
used here.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 17 Mar 2017 13:25:57 +0100 |
| parents | f094aca05cf2 |
| children |
line wrap: on
line source
INSERT INTO stammdaten.verwaltungsgrenze(gem_id, shape) SELECT verwaltungseinheit.id, gem_utm.geom FROM stammdaten.verwaltungseinheit JOIN geo.gem_utm ON verwaltungseinheit.id = gem_utm.ags;