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
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 |
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 |