Re: psqlodbc - table name is truncated to 127 characters even SQL_MAX_TABLE_NAME_LEN is set to 255

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-13 12:11:06
Message-ID: e65a0c9c-30b0-d2ab-e662-feff3aaef526@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Scott Goley 2019-08-13 12:46:23 Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Previous Message 2985369863 2019-08-13 03:03:06 the psqlodbc_11_01_0000 installed on the windows srever 2008 R2