[postgis-users] SRID in geometry_columns view
Richard Greenwood
richard.greenwood at gmail.com
Tue Jul 24 14:49:53 PDT 2012
I am having difficulty getting my views' SRIDs into the
geometry_columns view in PostGIS 2.0. The doc's [1] suggest casting
the geometry in the view so I tried:
wkb_geometry::geometry(3739)
which generates the error:
ERROR: Invalid geometry type modifier: 3739
next I tried:
wkb_geometry::geometry(Geometry,3739)
which generates the error:
ERROR: cannot change data type of view column "wkb_geometry" from
geometry to geometry(Geometry,3739)
Any suggestions would be appreciated.
Rich
[1] http://postgis.refractions.net/docs/using_postgis_dbmanagement.html#geometry_columns
--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
More information about the postgis-users
mailing list