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.
> 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.
In response to
pgsql-odbc by date
|Next:||From: Rony Khoury||Date: 2001-05-14 08:03:44|
|Subject: security concern|
|Previous:||From: Norbert Schollum||Date: 2001-05-13 16:38:41|
|Subject: Problems since Office XP|
pgsql-general by date
|Next:||From: Lamar Owen||Date: 2001-05-14 03:12:07|
|Subject: Re: RPM problem|
|Previous:||From: hiroko||Date: 2001-05-14 01:41:34|
|Subject: Roooooooooooooll back!|