Received: from keyframe.cjas.org (keyframe.cjas.org [208.210.124.55])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA14807
	for <pgsql-interfaces@postgresql.org>;
	Wed, 19 Apr 2000 13:59:24 -0400 (EDT) (envelope-from garza@cjas.org)
Received: from localhost (garza@localhost)
	by keyframe.cjas.org (8.9.3/8.9.2) with ESMTP id NAA87298;
	Wed, 19 Apr 2000 13:59:13 -0400 (EDT) (envelope-from garza@cjas.org)
Date: Wed, 19 Apr 2000 13:59:13 -0400 (EDT)
From: John David Garza <garza@cjas.org>
X-Sender: garza@localhost
To: Nelson Ferreira Junior <nelson@radix.com.br>
cc: pgsql-interfaces@postgresql.org
Subject: Re: Large strings
In-Reply-To: <38FDC85C.F11F51EA@radix.com.br>
Message-ID: <Pine.BSF.4.10.10004191356410.79249-100000@localhost>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200004/154

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
> 
>