[postgis-users] geometry type issue

[Shaozhong SHI]

I added a new column.

alter table a_table add column geom geometry(Polygon, 27700);

Then,

update a_table set geom = (select ST_ConcaveHull(ST_Collect(geom), 0.99)
from b_table where name = _name) where name = _name;

It kept throwing up an error message saying: "geometry type point does not
match polygon".

I thought that a concavehyll is a polygon.  That is why I created a polygon
column for it.

Can anyone help?

Regards,

Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200427/fcee4ba5/attachment.html>