Using:
CREATE TABLE trajectories(
gid SERIAL PRIMARY KEY,
vehID VARCHAR(10),
state INTEGER,
geom geometry(MULTILINESTRING)
)
I get an error, for instance, after inserting:
INSERT INTO trajectories(vehid,state,geom)
VALUES(001140,2,ST_GeomFromText('MULTILINESTRING((1 2 3,4 5 6))'))
it gives:
Geometry has Z dimension but column does not.
How could I circumvent this error?