| From: | Shachar Shemesh <psql(at)shemesh(dot)biz> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: A few problems with the ODBC driver |
| Date: | 2003-07-02 13:43:16 |
| Message-ID: | 1057153396.3f02e17478739@latenight.fiasco.org.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Quoting Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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 | Content-Type | Size |
|---|---|---|
| execute.diff | application/octet-stream | 667 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nisha Joseph | 2003-07-02 13:49:53 | lo type-- |
| Previous Message | Shachar Shemesh | 2003-07-02 11:20:56 | Re: A few problems with the ODBC driver |