In our last post spoke of a little issue we experienced issuing a query against a PostgreSQL Instance.
The Issue is that our result set included an array column.
select tblUSR.name as "region" , array_agg ( tblUSS.name ) as "stateAsArray" from us.state tblUSS inner join us.region tblUSR on tblUSS.region = tblUSR.name group by tblUSR.name order by tblUSR.name
Visited dbeaver support website @ Github.
Issued a query matching on PostgreSQL ( Link).
Here are the matches :-
- Web Link :- https://github.com/dbeaver/dbeaver/issues/6437 ( Link )
- Opened By :- pyrocks
- Opened On :- Commented 5 days ago ( 2019-08-04 )
- Confirm fixed in 6.1.4
Check your current version.
If prior to v6.1.4, please download and apply new version.
Here is what our version number looked like prior to upgrade.