Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7B2A16323CA;
	Wed, 21 Jan 2009 09:54:53 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 88167-03; Wed, 21 Jan 2009 09:54:49 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from is.rice.edu (is.rice.edu [128.42.42.24])
	by mail.postgresql.org (Postfix) with ESMTP id 437FB6323BE;
	Wed, 21 Jan 2009 09:54:50 -0400 (AST)
Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	by is.rice.edu (Postfix) with ESMTP id A70A641820;
	Wed, 21 Jan 2009 07:54:47 -0600 (CST)
Received: from is.rice.edu ([128.42.42.24])
	by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	(amavisd-new, port 10024)
	with ESMTP id 08900-10; Wed, 21 Jan 2009 07:54:46 -0600 (CST)
Received: by is.rice.edu (Postfix, from userid 18612)
	id 5077941819; Wed, 21 Jan 2009 07:54:46 -0600 (CST)
Date: Wed, 21 Jan 2009 07:54:45 -0600
From: Kenneth Marshall <ktm@rice.edu>
To: paulo matadr <saddoness@yahoo.com.br>
Cc: pgsql-general@postgresql.org, admin <pgsql-admin@postgresql.org>
Subject: Re: bytea size limit?
Message-ID: <20090121135445.GF14570@it.is.rice.edu>
References: <359812.4771.qm@web52512.mail.re2.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <359812.4771.qm@web52512.mail.re2.yahoo.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200901/77
X-Sequence-Number: 31124

On Wed, Jan 21, 2009 at 05:21:03AM -0800, paulo matadr wrote:
> I everyone, need help!!!
> My aplication return erro:
> 
> 2009-01-20 10:22:03,264 INFO  [STDOUT] Caused by: org.postgresql.util.
> PSQLException: ERROR: invalid memory alloc request size 1705447581
> 
>  TABLE batch.relatorio_gerado
> 
>   rege_id integer NOT NULL,
>   fuin_id integer NOT NULL,
>   rela_id integer NOT NULL,
>   rege_tmultimaalteracao timestamp without time zone NOT NULL DEFAULT now(),
>   rege_nnpaginas integer NOT NULL,
>   rege_binario bytea,
>  rege_pdf bytea
> 
> I get this erro above  refers the column "rege_pdf bytea"   , when try generate report in pdf.
> 
> thanks for help
> 

I believe that the default size limit for a bytea or text field is
currently 1GB.

Ken