Hi, Did you try to specify the geometry type on the fly using typemod with ::geometry(geometrytype, srid) ?
Regards, Hug De: "Walter Lorenzetti" <[email protected]> À: "PostGIS Users Discussion" <[email protected]> Envoyé: Mardi 26 Septembre 2017 12:51:38 Objet: [postgis-users] Postigs 2.3 spatial view and geometry_columns Hi list, I can make a spatial 3d view and add it to geometry_columns? I'm on PostgreSql 9.5 and Postgis 2.3 I did in this way: CREATE OR REPLACE VIEW view3d AS select st_force3dz(st_transform(the_geom, 25832)), .... after select populate_geometry_columns('view3d'::regclass); in the geometry_columns i look that: f_table_catalog | f_table_schema | f_table_name | f_geometry_column | coord_dimension | srid | type ----------------------+--------------------+-------------------+--------------------------+-----------------------+-------+------- database | public | view3d | the_geom | 2 | 0 | GEOMETRY wrong coord_dimention, srid and type If instead to do a view a I do a table, all is correct. Someone can help me. Thanks in advance Walter -- Walter Lorenzetti phD email: [ mailto:[email protected] | [email protected] ] skype: aiki74 twitter: [ https://twitter.com/w_lorenzetti | w_lorenzetti ] g+: [ https://plus.google.com/117055903318462447104/ | aiki74 ] Tel/Cell: (+39) 347-6597931 Viale Verdi 24 - 51016 Montecatini Terme (PT) [ http://gis3w.it/it/calendario-corsi-software-geografici | Nuovi corsi QGIS e GFOSS ] _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
