Re: SQL-Statement is too long

Erwin,

This is probably because you have PostgreSQL compiled with the default blocksize, which is 8k. You can recompile with a larger blocksize, but I think it may be configurable in version 7.1. It's not the JDBC driver's fault anyway :)

Jason

On Mon, Oct 29, 2001 at 05:52:26PM +0100, Erwin Ambrosch wrote:
> Hi,
>
> I'm using Postgesql 7.0.3-8 and the postgresql-jdbc2.jar to talk to the
> databse from within Java. I tried to write a quite long text into a TEXT
> column, and got the following SQLExcpetion: The SQL Statement is too
> long - INSERT INTO ...
>
> A file which contains the text has a size of 9244 byte. Are there any
> restriction for the length of a TEXT column.
>
> Thank you for any response.
>
> Erwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Jason Davies

jason(at)netspade(dot)com