From: | Antonio Carlos Ferreira Júnior <antoniocferreira(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | PSQLODBC case insensitive |
Date: | 2007-02-08 21:00:09 |
Message-ID: | e999797a0702081300j18d50e86sff2ee453e85a95e3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi folks
I'm accessing my PostgreSQL server from Windev (a french development
tool) through the ODBC driver. I created the tables without quotes, so it
doesnt if I execute this:
SELECT column FROM table
or this:
SELECT CoLuMn FROM tAbLe
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"
So the server cant find the tables and columns. Thas what I think. I'm I
wrong? If not, is that a way that I can make the ODBC driver build the
statements without quotes?
Sorry for my bad English.
Antonio Carlos,
Itabuna - BA - Brasil
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2007-02-09 07:44:41 | [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB |
Previous Message | noreply | 2007-02-05 15:10:37 | [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB |