shp2pgsql-gui exports all geometry columns but unselected column as text
Okay I suspect this may be an issue in 2.0 as well, but I'm running with the 2.1 version so can't be sure.
I have a table that has 2 geometry columns. shp2pgsql-gui lets me select one as it should, but it still includes the other and throws it in the dbf file as hex text.
I noticed this when I was trying to load into my spatialite database and was wondering why is that column there? and why isn't it a geometry column?
Change History
(5)
| Component: |
postgis → loader/dumper
|
| Owner: |
changed from pramsey to mcayland
|
| Milestone: |
PostGIS 2.0.4 → PostGIS 2.2.0
|
| Milestone: |
PostGIS 2.2.0 → PostGIS 2.1.9
|
| Resolution: |
→ wontfix
|
| Status: |
new → closed
|
I think this is 'won't fix'. Obviously the second column isn't a geometry column because shape can only have one geometry column at a time. And some people will want second columns ignored and others won't, which implies Yet More Configuration Flags, which is silly since it's such a minor case: if you don't want the column, just ignore it, it's only going to be 256 bytes long at worst, the most DBF can handle.