Re: [JPP-Devel] Uppercase "GEOMETRY" when saving into PostGIS

2017-08-21 Thread Rahkonen Jukka (MML)
Hi, I do not consider that using "GEOMETRY" is an horrible mistake but rather a moderate inconvenience. Using "geom" with PostGIS may be a common habit but there are other frequently used names like "the_geom" (shp2pgsql), "wkb_geometry" (GDAL) and "way" (OSM workchain). The PostGIS documentati

Re: [JPP-Devel] Uppercase "GEOMETRY" when saving into PostGIS

2017-08-21 Thread Brian M Hamlin
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 rig

[JPP-Devel] Uppercase "GEOMETRY" when saving into PostGIS

2017-08-21 Thread Rahkonen Jukka (MML)
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