Re: Large strings - Mailing list pgsql-interfaces

From John David Garza
Subject Re: Large strings
Date
Msg-id Pine.BSF.4.10.10004191356410.79249-100000@localhost
Whole thread Raw
In response to Re: Large strings  (Nelson Ferreira Junior <nelson@radix.com.br>)
List 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 by date:

Previous
From: "Ken J. Wright"
Date:
Subject: Re: Inserting NULL with pgaccess
Next
From: Tibor Laszlo
Date:
Subject: Re: ODBC not reporting RI violations.