Hello, Ok sorry for the mistake. So please read the correction :
----------------------- CREATE TABLE example_intersections_a AS (SELECT ST_Intersection (part_1.geom, part_2.geom)FROM fra_adm0 AS part_1,france_merge_pts1 AS part_2 WHERE ST_Intersects(part_1.geom, part_2.geom)); ALTER TABLE example_intersections_a ADD COLUMN id SERIAL; ALTER TABLE example_intersections_a ADD PRIMARY KEY (id); ---------------------- My goal is to populate into a new table the points from my raw points layer (france_merge_pts1) which contain or touch the surface of my raw surface polygon (fra_adm0). According to you, my query is good? My point layer is huge. I launched the query. It is still ongoing. Maybe is there a way to speed up the process? In advance, thank you. -- View this message in context: http://postgis.17.x6.nabble.com/ST-intersects-error-message-tp5005029p5005031.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
