[postgis-users] Postigs 2.3 spatial view and geometry_columns

[Walter Lorenzetti]

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: lorenzetti at gis3w.it
skype: aiki74
twitter:w_lorenzetti <https://twitter.com/w_lorenzetti>
g+:aiki74 <https://plus.google.com/117055903318462447104/>
Tel/Cell: (+39) 347-6597931
Viale Verdi 24 - 51016 Montecatini Terme (PT)
Nuovi corsi QGIS e GFOSS 
<http://gis3w.it/it/calendario-corsi-software-geografici>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170926/1bd109ef/attachment.html>