Re: PQsendQuery: Query is too long

Henrik Steffen <steffen@city-map.de> writes:

> Hello all,
>
> when doing larger queries, e.g. an insert of lots of text,
> I always get "Query too long" if the query is longer then 8192 bytes.
>
> a) What exactly is the reason for this limitation? (postgres, libpq or Pg.pm?)

You don't say what software versions you're using.  The 8k tuple-size
limit has been gone in PG since 7.1, but many client-side libraries
still enforce an 8k query limit for basically stupid reasons.

> b) What can I do to avoid this limitation?

Upgrade.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863