weird - invalid string enlargement request size

From: "Walter Cruz" <walter(dot)php(at)gmail(dot)com>
To: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: weird - invalid string enlargement request size
Date: 2007-12-04 17:18:36
Message-ID: 32cabba0712040918x48546a71vd5db5dad05c98f56@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-12-04 17:46:23 Re: There's random access and then there's random access
Previous Message Simon Riggs 2007-12-04 16:31:14 TOASTed size