weird - invalid string enlargement request size - Mailing list pgsql-hackers

From Walter Cruz
Subject weird - invalid string enlargement request size
Date
Msg-id 32cabba0712040918x48546a71vd5db5dad05c98f56@mail.gmail.com
Whole thread Raw
Responses Re: weird - invalid string enlargement request size  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
A simple query:

select prec.bl_considerada_prioritaria
AS "A proposta é considerada prioritária por Conselho Municipal ou Estadual"
from consultaprevia2008.tab_urb_asse_prec prec

The result: ERROR:  invalid string enlargement request size 1073741823

But.. If i replace the accented char, leaving the query like:

select prec.bl_considerada_prioritaria
AS "A proposta e considerada prioritaria por Conselho Municipal ou Estadual"
from consultaprevia2008.tab_urb_asse_prec prec


More weird yet: This is part of a large query. I have the keyword
"as", using accented chars in some other places, and works ok.

My pg version:

"PostgreSQL 8.2.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)"

This is a restored backup from 8.1 . In 8.1 it works ok.

[]'s
- Walter


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: TOASTed size
Next
From: Gregory Stark
Date:
Subject: Re: There's random access and then there's random access