Re: bytea size limit? - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: bytea size limit?
Date
Msg-id 20090121135445.GF14570@it.is.rice.edu
Whole thread Raw
In response to bytea size limit?  (paulo matadr <saddoness@yahoo.com.br>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: paulo matadr
Date:
Subject: bytea size limit?
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: [GENERAL] bytea size limit?