[Gambas-user] Issue 339 in gambas: DataSource.Table does not read tables with non-lowercase names (PostgreSQL)

[gambas at ...2524...]

Status: New
Owner: ----
Labels: Version Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any  
Desktop-Any GUI-Any

New issue 339 by schatten.markus: DataSource.Table does not read tables  
with non-lowercase names (PostgreSQL)
http://code.google.com/p/gambas/issues/detail?id=339

If a table has a non-lowercase name it is impossible to use it with  
DataSource.Table since it seems to be "converted" to lowercase and the  
system returns an error about a non-existent table (SQL is case insensitive  
which is why this happens). Haven't tested with other DBMS, but with  
PostgreSQL 9.1.5:

db=# CREATE TABLE "Uppercase" ( id SERIAL );
NOTICE:  CREATE TABLE will create implicit sequence "Uppercase_id_seq" for  
serial column "Uppercase.id"
CREATE TABLE

Then in Gambas3

DS.Table = "Uppercase"

where DS is a DataSource connected to the db above, raises the error:

Query failed: ERROR: Relation "uppercase" does not exist LINE 1: SELECT  
COUNT(*) AS nRecord FROM Uppercase

The query above would be correct if there were double quotes around the  
table name, e.g.

SELECT COUNT(*) AS nRecord FROM "Uppercase"

System info
-----------
Version: 3.3.0
Operating system: Linux
Distribution: Ubuntu
Architecture: x86
GUI component: QT4