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-10 00:57:14
Message-ID: 6713b9b2-8cdf-39ec-3188-b4444a3c5db6@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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-10 22:51:25 Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Previous Message Inoue, Hiroshi 2019-08-10 00:56:04 Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver