Re: BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Antonio Mari" <amari(at)at4(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded
Date: 2007-09-28 15:13:44
Message-ID: 1969.1190992424@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Antonio Mari" <amari(at)at4(dot)net> writes:
> LC_COLLATE: es_ES(at)euro
> LC_CTYPE: es_ES(at)euro

> As you see the initdb was initialized with es_ES(at)euro locale (LATIN9).

> When connecting via psql to a database encoded in UTF8 and client_encoding
> is LATIN9 (or LATIN1) and try a wrong query I've the PANIC error.

This is pilot error: you must have LC_COLLATE and LC_CTYPE compatible
with the database encoding. The reason is that gettext looks to those
to determine what encoding to return localized error messages in, but
Postgres thinks they are in the database encoding, and only finds out
its mistake when it has to translate to another encoding. Of course,
the error message reporting *that* also has to be translated ...

There are a lot of other things that don't work well when the locale
settings don't match the database encoding, so my advice is "don't do
that".

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2007-09-28 16:38:30 Re: BUG #3641: Concat fails in update
Previous Message Heikki Linnakangas 2007-09-28 13:46:32 Re: BUG #3641: Concat fails in update