#439 closed bug (fixed)
PostgreSQL Query Builder can't handle quoted schemas
| Reported by: | Owned by: | g_j_m | |
|---|---|---|---|
| Priority: | major: does not work as expected | Milestone: | |
| Component: | Data Provider | Version: | 0.8 |
| Keywords: | PostgreSQL Query Builder quoted schemas | Cc: | |
| Must Fix for Release: | No | Platform: | Windows |
| Platform Version: | Awaiting user input: | no |
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
Fixed in r6238 (promptly:)