Hi Tim, I don't think this is possible https://www.postgresql.org/message-id/cab7npqtlmmn1ltb5we0v0do57ip0u73ykwzbzytaxdf1caw...@mail.gmail.com
I hope you can count the dependent views with your fingers of the 2 hands ;) Denis Le sam. 20 avr. 2019 à 17:33, Tim Sutton <[email protected]> a écrit : > Hi Denis > > > Are you looking for st_force3d? > 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 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 -- Denis Rouzaud [email protected] <[email protected]> +41 76 370 21 22 <+41763702122> [image: OPENGIS.ch Logo] <https://www.opengis.ch>
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
