On 2025-09-30 17:29 +0200, celati Laurent wrote: > But when i rerun the query with the edit (adding the closing parenthesis) : > > *SELECT min(union_v4.max_hierar) as id, array_agg(union_v4.id) > as ids, union_v6.geomFROM union_v4, (SELECT > (ST_Dump(St_multi(ST_Union(geom)))).geom as geom FROM > union_v6)WHERE st_intersects(union_v4.geom, union_v6.geom)GROUP BY > union_v6.geom* > > *I obtain this time the message : * ERROR: la relation « union_v4 » > n'existe pas LINE 5: FROM union_v4, ^ ERREUR: la relation « union_v4 » > n'existe pas SQL state: 42P01 Character: 105 > > However, i have one table called "union_v4" within my postgis db. > thanks so much.
* In which schema is union_v4 defined? * What is your current search_path setting? Check SHOW search_path; -- Erik Wienhold
