Re: SQL-Statement is too long

Поиск
Список
Период
Сортировка
От Jason Davies
Тема Re: SQL-Statement is too long
Дата
Msg-id 20011030132413.A25075@netspade.com
обсуждение исходный текст
Ответ на SQL-Statement is too long  (Erwin Ambrosch <erwin@ebutec.com>)
Список pgsql-jdbc
Erwin,

This is probably because you have PostgreSQL compiled with the default blocksize, which is 8k. You can recompile with a
largerblocksize, 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@postgresql.org

--
Jason Davies

jason@netspade.com

Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Guy McArthur
Дата:
Сообщение: Re: "No Suitable Driver"
Следующее
От: Erwin Ambrosch
Дата:
Сообщение: German Special Characters