Henrik Steffen <steffen(at)city-map(dot)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