I am running the following query on Postgres 10.3/Postgis 2.4:
create table table_c as ( select A.*, B.area_name, B.id from table_a A left join table_b B on ST_Contains(A.geom, B.geom) );
that fails with a cryptic:
ERROR: GEOSContains: TopologyException: side location conflict at -2.0889721121124643 53.528652265475735
due to Postgis (and relative used libraries).
Is there a way to skip exceptional cases and keeping the query running until finished?