Re: Help: Change the SQL query length

Marcos Cruz <Marcos.Cruz@iti.gov.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"

Hm, I notice

#define TEXT_FIELD_SIZE             8190        /* size of text fields
                                                 * (not including null
                                                 * term) */

in src/interfaces/odbc/psqlodbc.h ... does changing that help?

            regards, tom lane