Hi Denis
> Are you looking for st_force3d? > https://postgis.net/docs/ST_Force_3D.html > <https://postgis.net/docs/ST_Force_3D.html> Thanks for your reply. Yeah I have a process working like this: DROP VIEW vw_aoi; DROP VIEW vw_boundary; ALTER TABLE camps ALTER COLUMN geom TYPE geometry(PolygonZ,20790) USING ST_Force3D(geom); CREATE VIEW vw_boundary AS SELECT 1, st_union(camps.geom) AS geom FROM camps; CREATE VIEW vw_aoi AS SELECT 1 AS id, st_buffer(st_envelope(vw_boundary.geom), 50::double precision) AS geom FROM vw_boundary; I was more wondering if there is a way to do the update of the geometry type without having to drop all related views etc. and restore them again? Regards Tim — Tim Sutton Co-founder: Kartoza Ex Project chair: QGIS.org Visit http://kartoza.com <http://kartoza.com/> to find out about open source: Desktop GIS programming services Geospatial web development GIS Training Consulting Services Skype: timlinux IRC: timlinux on #qgis at freenode.net I'd love to connect. Here's my calendar link <https://calendly.com/timlinux> to make finding time easy.
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
