[postgis-devel] [PostGIS] #1702: SetSRID, ST_Transform and geometry_columns in sync?
PostGIS
trac at osgeo.org
Thu Mar 22 05:13:42 PDT 2012
#1702: SetSRID, ST_Transform and geometry_columns in sync?
------------------------+---------------------------------------------------
Reporter: darkblueb | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 2.0.0
Component: postgis | Version: trunk
Resolution: invalid | Keywords:
------------------------+---------------------------------------------------
Changes (by robe):
* status: new => closed
* resolution: => invalid
Comment:
dbb -- yes this is the behavior we want.
geometry_columns works off the definition of your column not what you put
in it. What you put in it is constrained by what the definition allows.
You defined your column as an unconstrained geometry column, which means
you are free to throw in whatever crap geometry you want in it.
Think of geometry_columns as metadata listing WHAT IS ALLOWED, not WHAT IS
IN the table. How owuld you expect an empty table to display?
NOTE: You either have to define your geometry column as
geometry(POINT,3310)
or use AddGeometryColumn ... http://trac.osgeo.org/postgis/ticket/1693
with use_typmod=false to get a constraint constrained geometry column.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1702#comment:1>
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