[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