Opened 16 years ago

Closed 16 years ago

Last modified 14 years ago

#439 closed bug (fixed)

PostgreSQL Query Builder can't handle quoted schemas

Reported by: hartmut.tschauner@… 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


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

Change History (2)

comment:1 by g_j_m, 16 years ago

Resolution: fixed
Status: newclosed

Fixed in r6238 (promptly:)

comment:2 by (none), 14 years ago

Milestone: Version 0.8

Milestone Version 0.8 deleted

Note: See TracTickets for help on using tickets.