I am trying to load this query result using PostGIS 2.5 connection in QGIS 3.4, QGIS 2.18.
SELECT ST_VoronoiPolygons(geom) As geom FROM (SELECT 'MULTIPOINT (50 30, 60 30, 100 100,10 150, 110 120)'::geometry As geom ) As g;
Getting the error of the vector layer GeometryCollection result as Raster Layer in QGIS.
I have tried PostGIS function to verify results
And Applying ST_AsGeoJSON and ST_AsText, results are GeometryCollection, valid, I have imported that GeoJSON in https://mapshaper.org/. the result is correct. on other PostGIS function like ST_CollectionExtract with polygon and ST_Dump working fine with this query result. I have faced this type of error much time before with GeometryCollection result of PostGIS DB Queries in QGIS, so why is QGIS Load GEometryCollection vector query result as raster layer?