Dissolve keeping all attributes values (concatenation/aggregation)?

[Erik Wienhold]

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 <ewie at ewie.name> 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