the recent default name for a column of type geometry in PostGIS development, is geom. It is absolutely a horrible mistake to use any uppercase default name, and especially so if the name is the same name as the type. I am sure people would agree on this, just a simple change to get on the right track..  
hth-
  --Brian
 
 
 
On Mon, 21 Aug 2017 07:46:39 0000, "Rahkonen Jukka (MML)" <[email protected]> wrote:

Hi,

The driver "PostGIS Table (new)" creates the geometry column and names it as uppercase GEOMETRY. I would say that it would be better to use lowercase "geometry". Now when writing direct database queries users must use exact column name with double quotes
select "GEOMETRY" from table;

If it would be for some reason important to have just "GEOMETRY" as the name of the geometry column it could be made selectable through the UI which might be a good idea anyways.
-Jukka Rahkonen-

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

--
Brian M Hamlin
OSGeo California Chapter
blog.light42.com

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to