Bug report #439

PostgreSQL Query Builder can't handle quoted schemas

Added by hartmut-tschauner-gmail-com - almost 14 years ago. Updated about 11 years ago.

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 14 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

Fixed in 85828f42 (SVN r6239) (promptly:)

#2 Updated by Anonymous about 11 years ago

Milestone Version 0.8 deleted

Also available in: Atom PDF