<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Hug,</p>
<p>it works!</p>
<p>Thanks a lot!</p>
<p>W<br>
</p>
<br>
<div class="moz-cite-prefix">Il 26/09/2017 13:06, Hugues François ha
scritto:<br>
</div>
<blockquote type="cite"
cite="mid:1590346901.3385613.1506423989810.JavaMail.zimbra@irstea.fr">
<div style="font-family: garamond,new york,times,serif; font-size:
12pt; color: #000000">
<div>Hi,</div>
<div><br data-mce-bogus="1">
</div>
<div>Did you try to specify the geometry type on the fly using
typemod with ::geometry(geometrytype, srid) ?</div>
<div><br data-mce-bogus="1">
</div>
<div>Regards,</div>
<div><br data-mce-bogus="1">
</div>
<div>Hug</div>
<div><br>
</div>
<hr id="zwchr" data-marker="__DIVIDER__">
<div data-marker="__HEADERS__"><b>De: </b>"Walter Lorenzetti"
<a class="moz-txt-link-rfc2396E" href="mailto:lorenzetti@gis3w.it"><lorenzetti@gis3w.it></a><br>
<b>À: </b>"PostGIS Users Discussion"
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org"><postgis-users@lists.osgeo.org></a><br>
<b>Envoyé: </b>Mardi 26 Septembre 2017 12:51:38<br>
<b>Objet: </b>[postgis-users] Postigs 2.3 spatial view and
geometry_columns<br>
</div>
<div><br>
</div>
<div data-marker="__QUOTED_TEXT__">
<p>Hi list,</p>
<p>I can make a spatial 3d view and add it to
geometry_columns?</p>
<p>I'm on PostgreSql 9.5 and Postgis 2.3<br>
</p>
<p>I did in this way:</p>
<p>CREATE OR REPLACE VIEW view3d AS <br>
select st_force3dz(st_transform(the_geom, 25832)), ....</p>
<p>after <br>
</p>
<p>select populate_geometry_columns('view3d'::regclass);</p>
<p>in the geometry_columns i look that:</p>
<p> f_table_catalog | f_table_schema | f_table_name |
f_geometry_column | coord_dimension | srid | type <br>
----------------------+--------------------+-------------------+--------------------------+-----------------------+-------+-------<br>
database | public | view3d
| the_geom |
2 | 0 | GEOMETRY<br>
</p>
<p>wrong coord_dimention, srid and type</p>
<p>If instead to do a view a I do a table, all is correct.</p>
<p>Someone can help me.</p>
<p>Thanks in advance</p>
<p>Walter<br>
</p>
<div class="moz-signature">-- <br>
<p style="font-size:12px;"> Walter Lorenzetti phD<br>
email: <a class="moz-txt-link-abbreviated"
href="mailto:lorenzetti@gis3w.it" target="_blank"
moz-do-not-send="true">lorenzetti@gis3w.it</a><br>
skype: aiki74<br>
twitter:<a href="https://twitter.com/w_lorenzetti"
target="_blank" moz-do-not-send="true">w_lorenzetti</a><br>
g+:<a
href="https://plus.google.com/117055903318462447104/"
target="_blank" moz-do-not-send="true">aiki74</a><br>
Tel/Cell: (+39) 347-6597931<br>
Viale Verdi 24 - 51016 Montecatini Terme (PT) <br>
<a
href="http://gis3w.it/it/calendario-corsi-software-geografici"
target="_blank" moz-do-not-send="true">Nuovi corsi QGIS
e GFOSS</a> </p>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<p style="font-size:12px;">
Walter Lorenzetti phD<br>
email: <a class="moz-txt-link-abbreviated" href="mailto:lorenzetti@gis3w.it">lorenzetti@gis3w.it</a><br>
skype: aiki74<br>
twitter:<a href="https://twitter.com/w_lorenzetti">w_lorenzetti</a><br>
g+:<a href="https://plus.google.com/117055903318462447104/">aiki74</a><br>
Tel/Cell: (+39) 347-6597931<br>
Viale Verdi 24 - 51016 Montecatini Terme (PT)
<br>
<a
href="http://gis3w.it/it/calendario-corsi-software-geografici">Nuovi
corsi QGIS e GFOSS</a>
</p>
</div>
</body>
</html>