[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