[postgis-users] Postigs 2.3 spatial view and geometry_columns

[Walter Lorenzetti]

Hi Hug,

it works!

Thanks a lot!

W


Il 26/09/2017 13:06, Hugues François ha scritto:
> 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: 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>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 

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/fcdb0dbf/attachment.html>