Skip site navigation (1) Skip section navigation (2)

Re: PSQLODBC case insensitive

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 (view raw or flat)
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

In response to

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2007-02-09 19:03:59
Subject: [ psqlodbc-Bugs-1001906 ] Unable to obtain list of tables from the datasource
Previous:From: noreplyDate: 2007-02-09 07:44:41
Subject: [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group