Re: JDBC and long TEXT fields

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Bryan (Mailing Lists)" <bryan_lists(at)netmeme(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: JDBC and long TEXT fields
Date: 2000-12-03 04:28:44
Message-ID: 3A29CBFC.F28FC13C@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> 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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bryan (Mailing Lists) 2000-12-03 04:40:46 Re: JDBC and long TEXT fields
Previous Message Greg Speegle 2000-12-03 03:50:17 Re: JDBC and long TEXT fields