Re: BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded

From: Florian Wunderlich <fwunderlich(at)factor3(dot)de>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded
Date: 2008-02-05 13:19:19
Message-ID: 47A86257.6060004@factor3.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera wrote:
> Florian Wunderlich wrote:
>
>> - input file in encoding iso-8859-1:
>>
>> set client_encoding='iso-8859-1';
>> select upper('ä'), lower('Ä');
>>
>> (note: the argument to upper is a lower case a umlaut, while the argument to
>> lower is an upper case a umlaut)
>>
>> - database "iso" with encoding iso-8859-1,
>> database "utf" with encoding utf-8,
>> both in a cluster with locale=de_DE
>
> I think this is just a case of a misconfigured server. If you choose
> locale de_DE, which supports only the iso-8859-1 encoding, it is an
> error to build a database with utf8 encoding -- which is why 8.3 rejects
> that combination.
>

You are correct; if I use de_DE.UTF-8 for initdb, the database with
encoding utf-8 works fine (and the database with iso-8859-1 doesn't).

Because such an invalid combination cannot happen for 8.3 anymore, the
PANIC cannot occur anymore, and thus the bug can be closed.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2008-02-05 15:24:01 Re: [BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file
Previous Message Alvaro Herrera 2008-02-05 13:03:30 Re: BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded