Bug report #439
PostgreSQL Query Builder can't handle quoted schemas
|Gavin Macaulay -
|Affected QGIS version:
|Pull Request or Patch supplied:
|Crashes QGIS or corrupts data:
|Copied to github as #:
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.