<div dir="ltr">Hi Tim,<div>I don't think this is possible</div><div><a href="https://www.postgresql.org/message-id/CAB7nPqTLmMn1LTb5WE0v0dO57iP0U73yKwzbZytAXDF1CAWLZg@mail.gmail.com">https://www.postgresql.org/message-id/CAB7nPqTLmMn1LTb5WE0v0dO57iP0U73yKwzbZytAXDF1CAWLZg@mail.gmail.com</a><br></div><div><br></div><div>I hope you can count the dependent views with your fingers of the 2 hands ;)</div><div><br></div><div>Denis</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le sam. 20 avr. 2019 à 17:33, Tim Sutton <<a href="mailto:tim@kartoza.com">tim@kartoza.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;">Hi Denis<div><br></div><div><br></div><div><blockquote type="cite"><div dir="auto"><div dir="auto">Are you looking for st_force3d?</div><div dir="auto"><a href="https://postgis.net/docs/ST_Force_3D.html" target="_blank">https://postgis.net/docs/ST_Force_3D.html</a><br></div></div></blockquote></div><div><div dir="auto"><br></div></div><div><br></div><div>Thanks for your reply. Yeah I have a process working like this:</div><div><br></div><div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><span style="color:rgb(15,0,170)">DROP</span> <span style="color:rgb(15,0,170)">VIEW</span> vw_aoi;</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><span style="color:rgb(15,0,170)">DROP</span> <span style="color:rgb(15,0,170)">VIEW</span> vw_boundary;</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><span style="color:rgb(15,0,170)">ALTER</span> <span style="color:rgb(22,23,255)">TABLE</span> camps</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"> <span style="color:rgb(15,0,170)">ALTER</span> <span style="color:rgb(22,23,255)">COLUMN</span> geom <span style="color:rgb(15,0,170)">TYPE</span> geometry(PolygonZ,20790) <span style="color:rgb(22,23,255)">USING</span> ST_Force3D(geom);</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><span style="color:rgb(22,23,255)">CREATE</span> <span style="color:rgb(15,0,170)">VIEW</span> vw_boundary <span style="color:rgb(22,23,255)">AS</span> <span style="color:rgb(22,23,255)">SELECT</span> 1,</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"> st_union(camps.geom) <span style="color:rgb(22,23,255)">AS</span> geom</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"> <span style="color:rgb(22,23,255)">FROM</span> camps; </div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><span style="color:rgb(22,23,255)">CREATE</span> <span style="color:rgb(15,0,170)">VIEW</span> vw_aoi <span style="color:rgb(22,23,255)">AS</span> <span style="color:rgb(22,23,255)">SELECT</span> 1 <span style="color:rgb(22,23,255)">AS</span> id,</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"> st_buffer(st_envelope(vw_boundary.geom), 50::<span style="color:rgb(15,0,170)">double</span> <span style="color:rgb(15,0,170)">precision</span>) <span style="color:rgb(22,23,255)">AS</span> geom</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"> <span style="color:rgb(22,23,255)">FROM</span> vw_boundary;</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo"><br></div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">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?</div><div><br></div>Regards</div><div><br></div><div>Tim<br><div>
<div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><span>—</span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><br class="gmail-m_758598560499861668Apple-interchange-newline" style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><span style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><span><span><span><span><span><span><span><span><span><span><span><img id="gmail-m_7585985604998616689CEF848C-D806-4A14-9C0F-E743B2615836" src="cid:16a3d9af8c02451cdf21"></span><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br class="gmail-m_758598560499861668Apple-interchange-newline"><br class="gmail-m_758598560499861668Apple-interchange-newline"><br class="gmail-m_758598560499861668Apple-interchange-newline"><br class="gmail-m_758598560499861668Apple-interchange-newline"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Tim Sutton</b></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Co-founder:</b><span class="gmail-m_758598560499861668Apple-converted-space"> </span>Kartoza</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Ex Project chair:</b><span style="font-weight:normal"><span class="gmail-m_758598560499861668Apple-converted-space"> </span><a href="http://QGIS.org" target="_blank">QGIS.org</a></span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Visit <a href="http://kartoza.com/" target="_blank"><span>http://kartoza.com</span></a> to find out about open source:</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Desktop GIS programming services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Geospatial web development</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">GIS Training</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Consulting Services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Skype</b>: timlinux </div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>IRC:</b><span class="gmail-m_758598560499861668Apple-converted-space"> </span>timlinux on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)">I'd love to connect. </span><a class="gmail-m_758598560499861668t-quick-start-share-link" href="https://calendly.com/timlinux" style="color:rgb(0,162,255);text-decoration:none;font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left" target="_blank">Here's my calendar link</a><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)"> to make finding time easy.</span></div>
</span></span></span></span></span></span></span></span></span></span></span></div>
</div><br></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span style="color:rgb(0,0,0);font-family:Verdana,sans-serif;font-size:10pt">Denis Rouzaud</span><br style="color:rgb(0,0,0);font-family:Times;font-size:medium"><a href="mailto:denis@opengis.ch" style="font-family:Times;font-size:medium" target="_blank"><span style="color:rgb(0,0,0);font-family:Verdana,sans-serif;font-size:8pt">denis@opengis.ch</span> </a><br style="color:rgb(0,0,0);font-family:Times;font-size:medium"><span style="color:rgb(0,0,0);font-family:Verdana,sans-serif;font-size:8pt"><a href="tel:+41763702122" target="_blank">+41 76 370 21 22</a></span><br style="color:rgb(0,0,0);font-family:Times;font-size:medium"><div style="color:rgb(0,0,0);font-family:Times;font-size:medium"><a href="https://www.opengis.ch" target="_blank"><img alt="OPENGIS.ch Logo" height="80" width="200"></a></div></div></div></div></div>