Bug report #439
PostgreSQL Query Builder can't handle quoted schemas
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: |  Gavin Macaulay - | ||
| Category: | Data Provider | ||
| 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 |
Description
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.
Cheers, Hartmut
History
#1
Updated by Gavin Macaulay - almost 18 years ago
- Resolution set to fixed
- Status changed from Open to Closed
Fixed in 85828f42 (SVN r6239) (promptly:)
#2 Updated by Anonymous about 15 years ago
Milestone Version 0.8 deleted