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

2017-08-21 Thread Rahkonen Jukka (MML)
nen viesti- Lähettäjä: Brian M Hamlin [mailto:mapl...@light42.com] Lähetetty: 21. elokuuta 2017 11:41 Vastaanottaja: jump-pilot-devel@lists.sourceforge.net; Rahkonen Jukka (MML) Aihe: Re: [JPP-Devel] Uppercase "GEOMETRY" when saving into PostGIS the recent default name for a colum

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