Postgres Pro
Downloads
Home   >   mailing lists

Re: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255 - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255
Date
Msg-id 6713b9b2-8cdf-39ec-3188-b4444a3c5db6@dream.email.ne.jp
Whole thread Raw
In response to RE: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255  (Xuesong Gao <xgao@senturus.com>)
Responses Re: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Tree view
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



ウイルス フリー｡ www.avg.com

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Next
From: Scott Goley
Date:
Subject: Re: Regarding conversion of SQL_TSI_DAY operator forDatetimeadd function in ODBC driver