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 documentation does use "geom" in the first example http://postgis.net/docs/AddGeometryColumn.html but names of the next geometry colums "geom_c, geomcp_c" are by no means any better or worse.
Column name and type name being the same should not make real problems. OK, it is a bit more difficult to read what happens with type cast like in some query like SELECT ST_Buffer(geometry::geography,10)::geometry FROM my_table AS geometry; However "geometry" is the name that is used in the examples of GeoPackage, and Oracle by default has upper case column names which means that when people convert data from one system to another all name variants will occur. But anyway, for avoiding some inconvenience I thing that "geometry" or "geom" would be a better default. -Jukka Rahkonen- -----Alkuperäinen viesti----- Lähettäjä: Brian M Hamlin [mailto:[email protected]] Lähetetty: 21. elokuuta 2017 11:41 Vastaanottaja: [email protected]; Rahkonen Jukka (MML) <[email protected]> Aihe: Re: [JPP-Devel] Uppercase "GEOMETRY" when saving into PostGIS 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
