Re: JDBC and long TEXT fields - Mailing list pgsql-interfaces

From Thomas Lockhart
Subject Re: JDBC and long TEXT fields
Date
Msg-id 3A29CBFC.F28FC13C@alumni.caltech.edu
Whole thread Raw
In response to Thanks.....& How do I implement Connection Pooling....;-))  (Sanjay Arora <sk@pobox.com>)
List 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


pgsql-interfaces by date:

Previous
From: Greg Speegle
Date:
Subject: Re: JDBC and long TEXT fields
Next
From: "Bryan \(Mailing Lists\)"
Date:
Subject: Re: JDBC and long TEXT fields