Re: Large strings

Поиск
Список
Период
Сортировка
От John David Garza
Тема Re: Large strings
Дата
Msg-id Pine.BSF.4.10.10004191356410.79249-100000@localhost
обсуждение исходный текст
Ответ на Re: Large strings  (Nelson Ferreira Junior <nelson@radix.com.br>)
Список pgsql-interfaces
Hello,

If your strings are much larger than the limit, it might be more efficient
to store the string in it's own file and just store the location of that
file in the db.

John David Garza
garza@keyframe.cjas.org

On Wed, 19 Apr 2000, Nelson Ferreira Junior wrote:

>      I reinstalled Postgre with page size set to 32K, but it still doesn't
> work. I got the following errors. Is it complaining abou the size of the
> query itself ?
> 
> * Java program (even using a prepared statement)
>      SQLException: The SQL Statement is too long
> * Puting the query in a file and calling with psql -f :
>      ERROR:  Tuple is too big: size 11424, max size 8140
> 
>                                                              Thanks
> 
> 



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

Предыдущее
От: "Ken J. Wright"
Дата:
Сообщение: Re: Inserting NULL with pgaccess
Следующее
От: Tibor Laszlo
Дата:
Сообщение: Re: ODBC not reporting RI violations.