Re: SQL-Statement is too long

Erwin,

Prior to 7.0, postgres only supported sql statements that were 8K long
(or actually blocksize long which could be from 8K - 32K, but is 8K by
default). That restriction was removed from the server in 7.0, however
arly versions on the 7.0 driver still had this restriction. This bug
was fixed in later 7.0 versions of the jdbc driver.

thanks,
--Barry

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
>