From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Bryan (Mailing Lists) <bryan_lists@netmeme.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC and long TEXT fields
Date: Sun, 03 Dec 2000 04:28:44 +0000
Message-ID: <3A29CBFC.F28FC13C@alumni.caltech.edu> (raw)
References: <200012011652.WAA08483@tcs.com>
<012d01c05c66$0108d6f0$c6290218@workhorse>
<002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, bryan_lists@netmeme.org
Subject: Re: JDBC and long TEXT fields
In-Reply-To: <3A29CBFC.F28FC13C@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox