From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Xuesong Gao <xgao(at)senturus(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: psqlodbc - table name is truncated to 127 characters even SQL_MAX_TABLE_NAME_LEN is set to 255 |
Date: | 2019-08-17 11:20:37 |
Message-ID: | aee86a4d-8de3-2f8c-e499-9506e85f25e8@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
Sorry for the late reply.
I have changed my local branch but wouldn't push it to git at once.
Instead I attached the simplest fix for your system.
Please try the patch.
regards,
Hiroshi Inoue
On 2019/08/13 23:11, Xuesong Gao wrote:
>
> It works!
>
> Do you keep your GitHub source code up-to-date? We took version 09.06
> and customized it, added a load database button (so that users can
> browse instead of type in) for example. So I would like to merge your
> changes to our version.
>
> Here is what our driver looks like, and I can share my code with you
> if you want to add load databases function.
>
> Thanks,
>
> Song Gao
>
> *From:*Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> *Sent:* Tuesday, August 13, 2019 8:11 AM
> *To:* Xuesong Gao <xgao(at)senturus(dot)com>
> *Cc:* pgsql-odbc(at)postgresql(dot)org
> *Subject:* Re: psqlodbc - table name is truncated to 127 characters
> even SQL_MAX_TABLE_NAME_LEN is set to 255
>
> Could you please try the test drivers on Windows 11.00.0300 at
> https://winpg.jp/~inoue/psqlodbc/index.html
> ?
>
> regards,
> Hiroshi Inoue
>
> On 2019/08/10 9:57, Inoue, Hiroshi wrote:
>
> Hi,
>
> I would examine the issue.
>
> regards,
> Hiroshi Inoue
>
> On 2019/08/09 13:37, Xuesong Gao wrote:
>
> Hi,
>
> We wrote our application that acts as a pseudo PostgreSQL
> server and we use PsqlODBC as client. Our table names are very
> long so we set it to 255. Our server actively sends this to
> client after password using parameter status message, it also
> returns 255 when client call “show max_identifier_length”.
>
> Based my test, SQLGetInfo does return 255 when parameter is
> SQL_MAX_TABLE_NAME_LEN, SQL_MAX_IDENTIFIER_LEN, etc. However,
> the table name is still truncated to 127 characters in
> SQLTables call. And I can tell that our server does return
> full length of table name (>128 chars) using Wireshark.
>
> Thanks,
>
> Song Gao
>
---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com
Attachment | Content-Type | Size |
---|---|---|
psqlodbc.patch | text/plain | 564 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Humaj | 2019-08-23 05:26:58 | omission in ODBC documentation ... ? |
Previous Message | Olagoke Akinyemi | 2019-08-15 10:54:19 | Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver |