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
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 |