Re: bytea size limit?

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