On 2025-09-30 19:11 +0200, celati Laurent wrote: > The table union_v4 is in public schema. > When i execute SHOW search_path : > > "$user", public
Are you running your query in the same database? Is something setting an empty search path (or at least without "public") before running the query? Besides that, I have no clue why you might get that error. > Le mar. 30 sept. 2025 à 17:37, Erik Wienhold <[email protected]> a écrit : > > > 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
