Re: A few problems with the ODBC driver - Mailing list pgsql-odbc

From Shachar Shemesh
Subject Re: A few problems with the ODBC driver
Date
Msg-id 1057153396.3f02e17478739@latenight.fiasco.org.il
Whole thread Raw
In response to A few problems with the ODBC driver  (Shachar Shemesh <psql@shemesh.biz>)
List pgsql-odbc
Quoting Hiroshi Inoue <Inoue@tpf.co.jp>:

> Maybe I found a cause.
> Please try the snapshot dll at
>     http://www.geocities.jp/inocchichichi/psqlodbc/ .
>
I found the cause of the problem.

The SQLExecute command constructs a query in order to find the table. It forgot
to double quote the table name. As all the table names in my database are
uppercase, this caused the query to fail (PGSQL converts all unquoted ids to
lowercase), and the recordset was marked readonly.

Attached is a patch that fixes this problem. Forgive me if this is the wrong
place to post it. Let me know where I should post it.

                 Shachar

Attachment

pgsql-odbc by date:

Previous
From: Shachar Shemesh
Date:
Subject: Re: A few problems with the ODBC driver
Next
From: "Nisha Joseph"
Date:
Subject: lo type--