Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-odbc by date

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

pgsql-general by date

Next:From: Lamar OwenDate: 2001-05-14 03:12:07
Subject: Re: RPM problem
Previous:From: hirokoDate: 2001-05-14 01:41:34
Subject: Roooooooooooooll back!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group