[postgis-users] Postigs 2.3 spatial view and geometry_columns

[Hugues François]

Hi, 

Did you try to specify the geometry type on the fly using typemod with ::geometry(geometrytype, srid) ? 

Regards, 

Hug 


De: "Walter Lorenzetti" <lorenzetti at gis3w.it> 
À: "PostGIS Users Discussion" <postgis-users at lists.osgeo.org> 
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:lorenzetti at gis3w.it | lorenzetti at gis3w.it ] 
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 
postgis-users at lists.osgeo.org 
https://lists.osgeo.org/mailman/listinfo/postgis-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170926/1874f403/attachment.html>