Received: from golem.pgsql.com (w148.z064003068.lax-ca.dsl.cnc.net
	[64.3.68.148])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB34SPF71912
	for <pgsql-interfaces@postgresql.org>;
	Sat, 2 Dec 2000 23:28:25 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1])
	by golem.pgsql.com (Postfix) with ESMTP
	id 2411517C5E; Sun,  3 Dec 2000 04:28:44 +0000 (UTC)
Message-ID: <3A29CBFC.F28FC13C@alumni.caltech.edu>
Date: Sun, 03 Dec 2000 04:28:44 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
Organization: Yes
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: "Bryan (Mailing Lists)" <bryan_lists@netmeme.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC and long TEXT fields
References: <200012011652.WAA08483@tcs.com>
	<012d01c05c66$0108d6f0$c6290218@workhorse>
	<002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200012/11
X-Sequence-Number: 348

> I am trying to insert rows into a table containing a field of type "TEXT".
> The documentation says there is no limit to the size of this field; yet,
> when I try to insert or update a row with a field contents of around 10k, I
> get an error from the JDBC driver...

As Greg points out, there is an upper limit. I would hope that the docs
say that TEXT has no *fixed* limit, unlike SQL9x types char() and
varchar().

Let us know if that is not what the docs say (and where they don't say
that ;) and we'll get them fixed up. Though for the next release there
is only a huge upper limit, in principle.

                   - Thomas