Exec limit in pgtclsh

From: "Daniel J(dot) Blezek, Ph(dot)D(dot)" <blezek(at)crd(dot)ge(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Exec limit in pgtclsh
Date: 2000-03-07 20:18:14
Message-ID: Pine.LNX.4.10.10003071515000.4329-100000@pragmatic.crd.ge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)crd(dot)ge(dot)com
Computer Graphics and Systems Program
Electronic Systems Lab
GE Corporate Research & Development

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2000-03-07 21:27:52 Re: [ADMIN] Cannot install postgreSQL
Previous Message Ross J. Reedstrom 2000-03-07 20:14:38 Re: [ADMIN] Cannot install postgreSQL