New answers tagged postgis
Try sudo apt-get install postgresql-9.3-postgis-2.1 http://packages.ubuntu.com/trusty/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