Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group