Postgres Pro
Downloads
Home   >   mailing lists

Re: Help: Change the SQL query length - Mailing list pgsql-general

From Tom Lane
Subject Re: Help: Change the SQL query length
Date
Msg-id 5211.989596627@sss.pgh.pa.us
Whole thread Raw
In response to Help: Change the SQL query length  (Marcos Cruz <Marcos.Cruz@iti.gov.br>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: How to create a trigger
Next
From: webb sprague
Date:
Subject: Max simultaneous users