Re: [ODBC] Re: Help: Change the SQL query length

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marcos Cruz <Marcos(dot)Cruz(at)iti(dot)gov(dot)br>, pgsql-general(at)postgreSQL(dot)org, pgsql-odbc(at)postgreSQL(dot)org
Subject: Re: [ODBC] Re: Help: Change the SQL query length
Date: 2001-05-14 02:48:53
Message-ID: 3AFF4795.E5B8195E@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Tom Lane wrote:
>
> Marcos Cruz <Marcos(dot)Cruz(at)iti(dot)gov(dot)br> writes:
> > I'm changing a database from Access'97 to PostgreSQL 7.1.1 and
> > found a query limit when a I have large text field into the SQL
> > insert.
>
> > The returned msg is like " query too long, length > 8191 octets"

Which version of psqlodbc driver are you using ?
The max query length is 65536 in the latest driver.
However

>
> Hm, I notice
>
> #define TEXT_FIELD_SIZE 8190 /* size of text fields
> * (not including null
> * term) */
>
> in src/interfaces/odbc/psqlodbc.h ...

the limit of a text field is 8190 as above.
It seems that the size must be set via psqlodbc driver option
setting but it doesn't seem to work properly now.

regards,
Hiroshi Inoue

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2001-05-14 03:12:07 Re: RPM problem
Previous Message hiroko 2001-05-14 01:41:34 Roooooooooooooll back!

Browse pgsql-odbc by date

  From Date Subject
Next Message Rony Khoury 2001-05-14 08:03:44 security concern
Previous Message Norbert Schollum 2001-05-13 16:38:41 Problems since Office XP