New answers tagged


Try sudo apt-get install postgresql-9.3-postgis-2.1


Your query is needlessly complicated and can be untangled to this 100 % equivalent one: SELECT gid, id, ST_MakeValid(geom) AS geom FROM schema.table_polygons WHERE geom IS NOT NULL; Neither original nor this one remove any duplicates (except by possibly removing some with geom IS NULL, but I doubt that was your intention). Possible misunderstanding ...

Top 50 recent answers are included