02-20-2020 08:39 AM
I'm working on a project where i need to enable point or line geometries creation on a single table.
When i use GeometryCollection in my Postgis DB, in the desktop app, with the SC_DIGITIZE I'm getting an error saying the LineString is not compatible with the geom type GeometryCollection.
"Geometry type (LineString) does not match column type (GeometryCollection)"
The same goes with point.
Is there a way to make it work?
Thanks in advance
Solved! Go to Solution.
02-21-2020 03:21 AM
I would suggest you to use the generic "Geometry" type within PostGIS to be able to capture different types of geometries.
02-21-2020 04:34 AM
It does work.
I've created the DB when working with another solution hence the GeometryCollection in the first place.
Hope you are doing awesome.