Re: [QGIS-Developer] DB-manager and large query results (for time manager)

2020-08-26 Thread Giovanni Manghi
Hi Raymond, > The data sources are these: > > https://geodata.rivm.nl/covid-19/COVID-19_aantallen_gemeente_cumulatief.csv3 > > https://geodata.nationaalgeoregister.nl/wijkenbuurten2019/wfs?service=WFS2 > (layer: gemeenten2019) > > > and the query: > > select c.*, g.geom, g.inwoners > from covid19

Re: [QGIS-Developer] DB-manager and large query results (for time manager)

2020-08-25 Thread Raymond Nijssen
On 25-08-2020 10:27, Giovanni Manghi wrote: Hi Raymond, There's a question on a Dutch geo forum about a join query in DB-Manager that does not return data, but an error without message instead. PG Admin runs the query with he expected results, so it seems ok. I have seen this type of

Re: [QGIS-Developer] DB-manager and large query results (for time manager)

2020-08-25 Thread Giovanni Manghi
Hi Raymond, > There's a question on a Dutch geo forum about a join query in DB-Manager > that does not return data, but an error without message instead. PG > Admin runs the query with he expected results, so it seems ok. I have seen this type of problem in the past, but now I can't recall the

Re: [QGIS-Developer] DB-manager and large query results (for time manager)

2020-08-24 Thread Richard Duivenvoorde
On 8/24/20 3:28 PM, Raymond Nijssen wrote: > PS In my 3.15 opening the DB-manager crashes my QGIS instandly, so I could > only test the query in 3.12 without the time manager. Issue created for that some days ago https://github.com/qgis/QGIS/issues/38393 But I cannot reproduce it on Windows..

[QGIS-Developer] DB-manager and large query results (for time manager)

2020-08-24 Thread Raymond Nijssen
There's a question on a Dutch geo forum about a join query in DB-Manager that does not return data, but an error without message instead. PG Admin runs the query with he expected results, so it seems ok. People have been trying to reproduce this with different results. The query is joining a