Jayson,
> I am using Postgres 7.1.2 under linux with the JDBC drivers and Iam
> trying
> to do an insert into a text field with about a 9K string of text.
> Does
> anyone know why I would be getting an error back that says "The SQL
> Statement is too long?
You need to post this question on the p
I am using Postgres 7.1.2 under linux with the JDBC drivers and Iam trying
to do an insert into a text field with about a 9K string of text. Does
anyone know why I would be getting an error back that says "The SQL
Statement is too long?
At first I though it was because I was creating the SQL stat
You probably have PostgreSQL compiled with the default blocksize, which is 8k.
OpenACS.org has a nice set of instructions explaining how to increase the size to
16k or 32k.
http://openacs.org/doc/openacs/html/simple-pg-install-2.html#ss2.2
Hope that helps.
Yves Martin wrote:
> Hello,
>
Hello,
I have some problem with too long statement.
In 'psql', the error returned for my insert statement is
ERROR: Tuple is too big: size 10436
In fact, I use JDBC driver to insert a long long string into a 'text'
field. The exception is
The SQL Statement is too long - INSERT