I have a table in Postgresql with a geom_multiline column which, as the name suggests, is of type MULTILINESTRING and a second column geom_buffer which is a MULTIPOLYGON type. When I perform this query:

UPDATE locparktable
SET geom_buffer = 

I get this error:

Error : ERROR: Geometry type (MultiLineString) does not match column type (LineString)

I have dropped and readded geom_buffer multiple times I even at one point added it as a generic GEOMETRY type to see if that would help and it did not. I'm at the end of my knowledge and Googling is failing to provide any useful help. Does anyone know what might be causing this error?

The only thing I can think of (though I have not yet verified it) is that there may be MULTILINESTRING data in our geom_line (LINESTRING) column for a feature that we're trying to update with this query (No, I don't know how that would happen, but let's say it did).

Does anyone know if that would cause this error?

  • ST_CollectionExtract(ST_Multi(ST_Transform(ST_Buffer(st_transform(geom_multiline,2248),200), 4326)),3) postgis.net/docs/ST_CollectionExtract.html
    – ziggy
    Commented Apr 26, 2018 at 18:06
  • how do you create that column exactly? ...doesn't seem to obey to your commands a lot ,) btw., if you want radius in meter from EPSG:4326, use a cast to geography to avoid multiple transforms (ST_Buffer(geom_multiline::geography, 200))
    – geozelot
    Commented Apr 27, 2018 at 9:50
  • ST_Mutli combined with ST_Buffer should return a multipolygon. I don't understand the error, though. Commented Apr 27, 2018 at 15:25

1 Answer 1


You need to convert from Multi-linestring to linestring using ST_Dump as follows

UPDATE locparktable
SET geom_buffer = 

Note: geom is the name of geometry column, it may be different in your case. Just have a look at the results of


to be sure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.