Re: weird - invalid string enlargement request size

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Walter Cruz <walter(dot)php(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: weird - invalid string enlargement request size
Date: 2007-12-04 17:46:38
Message-ID: 20071204174638.GE4727@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Walter Cruz 2007-12-04 18:31:49 Re: weird - invalid string enlargement request size
Previous Message Gregory Stark 2007-12-04 17:46:23 Re: There's random access and then there's random access