[postgis-devel] [PostGIS] #1152: SRID_MAXIMUM should be raised, gserialized_get/set_srid () should be patched and typemod int too
PostGIS
trac at osgeo.org
Sun Aug 7 07:27:52 PDT 2011
#1152: SRID_MAXIMUM should be raised, gserialized_get/set_srid () should be
patched and typemod int too
----------------------+-----------------------------------------------------
Reporter: vince | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 2.0.0
Component: postgis | Version: trunk
Resolution: invalid | Keywords: srid liblwgeom
----------------------+-----------------------------------------------------
Comment(by robe):
It's stored as a number in the pg_attribute.atttypmod column for each
table column.
so if a geometry column was created with the form ADD COLUMN
geometry(POINT,4326)
you'll see a number in that column corresponding to that. If it was
created without typmod, that record would have -1 in the column.
The new geometry_columns view checks both typmod and constraints
and uses the helper functions postgis_typmod_* and postgis_constraint_* to
parse out the relevant srid, dim and type information from the typmod
number or table constraints.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1152#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list