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

From Alvaro Herrera
Subject Re: weird - invalid string enlargement request size
Date
Msg-id 20071204174638.GE4727@alvh.no-ip.org
Whole thread Raw
In response to weird - invalid string enlargement request size  ("Walter Cruz" <walter.php@gmail.com>)
Responses Re: weird - invalid string enlargement request size  ("Walter Cruz" <walter.php@gmail.com>)
List pgsql-hackers
Walter Cruz escribió:
> 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

Weird.  Probably encoding mismatch.  What are your locale and encoding
settings, and what encoding is the actual client?  And what client is
it?  Easiest way to show server settings is:

select name, setting
from pg_settings
where name ~~ any ( array['lc_%', '%_encoding']);

-- 
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: There's random access and then there's random access
Next
From: "Walter Cruz"
Date:
Subject: Re: weird - invalid string enlargement request size