Re: [SQL] SQL Statement too long

2001-08-20 Thread Josh Berkus
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

[SQL] SQL Statement too long

2001-08-20 Thread Jayson Callaway
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

Re: [SQL] Statement too long

2000-11-24 Thread Serge Canizares
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, >

[SQL] Statement too long

2000-11-23 Thread Yves Martin
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