Help: Change the SQL query length

From: Marcos Cruz <Marcos(dot)Cruz(at)iti(dot)gov(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Help: Change the SQL query length
Date: 2001-05-09 21:06:30
Message-ID: 3AF9B156.DD4B5760@iti.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

HI,

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"

The conection is done through the ODBC driver, with:
text as LongVarChar
Cache size = 100 (default)
max VarChar = 254 (default)
max LongVarChar = 65534 (changed)

The postmaster was running with default values.

If I use the psql utility into the server machine, I can insert the
record
successfully.

Has the postgresql_odbc or psqlodbc_07_01_005 any limitation with
regards
the query length?

The system frontend is running in Windows, and I need use ODBC to
connect
to the Linux server.

Thanks for any help!

Marcos Cruz
ITI - Instituto Nacional de Tecnologia da Informacao
Campinas - SP
Brazil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vince Vielhaber 2001-05-09 21:28:26 Re: Oracle to Pg tool
Previous Message Bruce Momjian 2001-05-09 21:02:16 Re: Oracle to Pg tool

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Michel POURE 2001-05-09 21:49:50 Re: encrypt odbc transactions?
Previous Message Tom Lane 2001-05-09 15:17:38 Re: ODBC and Access 2000