I've got a postgreSQL/postGIS table whose geom column holds Geometry type (MultiLineString). I want to include in the table also Points and MultiPoints, so I tried to change the geometry type with
alter table lineas alter column geom type geometry(geometrycollection);
However, it returns
ERROR: Geometry type (MultiLineString) does not match column type (GeometryCollection) SQL state: 22023
Why is that? A GeometryCollection column shoud be able to admit all other types, shouldn't it? How can it be solved?