[postgis-devel] [PostGIS] #369: shp2pg-gui the geometry column setting not sticking

[PostGIS]

#369: shp2pg-gui the geometry column setting not sticking
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.5.0
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by pramsey):

 This is by design. The default "geometry column" is "the_geom" and the
 default "geography column" is "geog". The logic is set up such that, if
 you open Options, then change the load type to geography, the default
 column name will reflect the load type. How do I know if you have a column
 name that is the default? I compare it. So, because you have "geog" (the
 default geography column) in your entry, but you are loading geometry, I
 assume "oh, she's using defaults" and I change it to the default geometry
 column name. If you use any other name than "geog", you'll find that the
 value is perfectly sticky. You'll also find that if you don't touch the
 name, and go into the Options menu and select a geography load, the name
 will automatically change to "geog", which is what we want.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/369#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.