shp2pg-gui the geometry column setting not sticking

[robe]

This is again testing my 12/31/ build so perhaps its been fixed since then.

When i change the geometry column name to "geog"

It flips back the "the_geom" as soon as I click the import button.

[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.

[robe]

Its definitely buggy then. It shouldn't do this when I click the "Import" button. At that point everything is set.

Actually I had chosen geography type and it flipped the name to geog as you said, but and then when I clicked "Import" it flipped it to "the_geom"

So I can never get a "geog" name out of this thing.

[pramsey]

Try at r5091 and close if it is OK. Thanks!

[robe]

Okay works, but I see my password again when I click test connection. I'll reopen that ticket