From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
---|---|
To: | Antonio Carlos Ferreira Júnior <antoniocferreira(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: PSQLODBC case insensitive |
Date: | 2007-02-09 16:01:09 |
Message-ID: | 20070209160109.GA12600@soptik.pzkagis.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> I'm accessing my PostgreSQL server from Windev (a french development
> tool) through the ODBC driver. I created the tables without quotes, so it
Where have you created the tables? Could you try create new one with
logs enabled to see what SQL command is executed?
> doesnt if I execute this:
>
> SELECT column FROM table
> or this:
> SELECT CoLuMn FROM tAbLe
Sorry, I don't understand what's the problem.
> But when I put the tables and columns names in Windev on lowercase I can
> access without problems. If I change one or more letters to uppercase I get
> an error.
> Seems like the driver is building the statements like this:
>
> SELECT "CoLuMn" FROM "tAbLe"
What does psqlodbc.log or mylog say (SQL statements)?
Regards,
Luf
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2007-02-09 19:03:59 | [ psqlodbc-Bugs-1001906 ] Unable to obtain list of tables from the datasource |
Previous Message | noreply | 2007-02-09 07:44:41 | [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB |