Bug report #439
PostgreSQL Query Builder can't handle quoted schemas
|Assignee:||Gavin Macaulay -|
|Affected QGIS version:||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||10498|
This is a follow-up to the previous ticket that was quickly resolved.
There is still a problem with the PostgreSQL Query Builder when the schema name contains a period. The query builder apparently splits the schema name at the period, cuts off the last character before the blank, and quotes the pre- and post-period parts separately as if they were schema name and table name. For example, if I try to enter a query on a table in a schema of my name, i.e., "hartmut.tschauner"."tablename", the query builder will try to query a table "hartmu"."tschauner", evidently splitting the schema name at the period (removing one character) and dropping the table name. The field list for such a table is empty. I can see the SQL when I hit the Sample button.