Timeline for QGIS virtual layer: Query preparation error on PRAGMA table_info(_tview): no such column: t.poly
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 9, 2022 at 18:57 | vote | accept | swiss_knight | ||
| May 9, 2022 at 18:57 | comment | added | swiss_knight | No changes: same behaviour. In order to keep things clean and clearly separate the questions -- because the current one is technically answered -- I've opened a new thread: gis.stackexchange.com/q/430804/65370 | |
| May 9, 2022 at 18:17 | comment | added | JGH | You have mentioned the embedded layers section, which is another not so documented and not so straightforward component. Try adding the tables/layers to the TOC and remove everything from the embedded layers section | |
| May 9, 2022 at 18:07 | comment | added | swiss_knight | Thanks for you edits, that's clearer! I'm actually working the same way, but heck, there is not even a line printed in the console when I launch QGIS by the command line to get it a little more verbose. For the moment, I've only noticed that the "Test" button says "OK" only when I remove the "WHERE bla bla" statement... I don't know what's wrong with it... But I really need it, otherwise, even pgAdmin freeeze; because that's to many feature to query for. | |
| May 9, 2022 at 17:59 | history | edited | JGH | CC BY-SA 4.0 |
added 7 characters in body
|
| May 9, 2022 at 17:51 | comment | added | JGH | Yes, there is one small note about the geometry column name (see the link in the edited answer). For the unresponsiveness, yes, it is a weakness of virtual layers: a small mistake can crash QGIS.. it is getting better with each version, though now I always save my work before touching a VL and I keep a copy of the query in a temp text file | |
| May 9, 2022 at 17:47 | history | edited | JGH | CC BY-SA 4.0 |
add link to the doc
|
| May 9, 2022 at 17:30 | comment | added | swiss_knight | Well, this is good to know. Is it documented somewhere? I'm not successful in my researches... And then, I don't face the error anymore, but when I hit the "Add" button, QGIS is not responding (everything becomes gray and there is this popup telling me either to "Force quit" or "Wait") for such a long time I had to kill the process. | |
| May 9, 2022 at 8:36 | history | answered | JGH | CC BY-SA 4.0 |