Re: Re: Too much data received? - Mailing list pgsql-jdbc

From Peter Eisentraut
Subject Re: Re: Too much data received?
Date
Msg-id Pine.LNX.4.30.0107110000250.677-100000@peter.localdomain
Whole thread Raw
In response to Re: Too much data received?  (Steve Wampler <swampler@noao.edu>)
List pgsql-jdbc
Steve Wampler writes:

> I think I originally saw the problem when an INSERT that included a
> *very* long text field entry generated an exception (I had dropped a
> function used as a trigger on inserts)) - the message that
> comes back from the back end includes (as near as I can remember)
> the original insert text, generating the above.

That would explain it perfectly.

> The exception above went away when I bumped the size of receive_sbuf
> to something larger than 8096 [this was with jdbc7.1-1.2.jar] and
> changed the calls to use the new size where they had been using 8096
> before.  I bumped it to 262144, incidently - these were large text
> fields.  This enabled me to find the other error and fix it.

Well, the longest piece of data you can store in a column is around 1GB,
so we obviously need to find a more flexible solution.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-jdbc by date:

Previous
From: "Arsalan Zaidi"
Date:
Subject: Re: [INTERFACES] New code for JDBC driver
Next
From: Sebastian Schuette
Date:
Subject: Strange behaviour of trigger functions when initiated via jdbc