Thread: Exec limit in pgtclsh

Hi all,

  Has anyone bumped into the 16K limit on the size of a statement using
pg_exec in the pgtclsh interface?  I'd like to populate a "text" field
using a large amount of text, but I get an error on the length limit of
the pg_exec call.  Something like this:


PQsendQuery() -- query is too long.  Maximum length is 16382

    while executing
"pg_exec $conn $statement"


Any ways around it?
-dan

--
Daniel Blezek, Ph.D.
blezek@crd.ge.com
Computer Graphics and Systems Program
Electronic Systems Lab
GE Corporate Research & Development

> I'd like to populate a "text" field
> using a large amount of text, but I get an error on the length limit of
> the pg_exec call.  Something like this:
>
> PQsendQuery() -- query is too long.  Maximum length is 16382
>
>     while executing
> "pg_exec $conn $statement"

1. Divide text among different entries
2. Use large objects


Jeroen


--
J. Elassaiss-Schaap
Dept. Physiology
Leiden University Medical Centre
Postbus 9604
2300 RC Leiden
The Netherlands

tel: 071-5276811
fax: 071-5276782
E-mail: j.schaap@physiology.medfac.leidenuniv.nl