Re: Bug#257117 Re: Error messages in SQL Query

Ricardo just sent me an email where saying the problem also appears in psql:

a) leave lc_messages = 'es_ES@euro'; export LC_ALL=es_ES@euro ;
/etc/init.d/postgresql restart
:~ > psql xxx
Contraseña:
Bienvenido a psql 7.4.3, el terminal interactivo de PostgreSQL.

Digite:  \copyright para ver los términos de distribución
        \h para obtener ayuda sobre comandos SQL
        \? para obtener ayuda sobre comandos internos
        \g o termine con punto y coma (;) para ejecutar consulta
        \q para salir
xxx=# select * from non_existent;
ERROR:  ERRORDATA_STACK_SIZE exceeded
xxx=#

I can't reproduce this one, but it seems there is a problem with the
backend. To determine if it's debian specific or not, can someone test
what's described below on another linux distro with PostgreSQL 7.4.3 ?

Cheers,
Raphaël

Raphaël Enrici wrote:

> Hi Andreas,
>
> hope I won't mess you with a known one...
>
> Andreas Pflug wrote:
>
>> Raphaël Enrici wrote:
>>
>>> can one of you confirm that error messages displayed under the SQL
>>> query window are generated by the PostgreSQL backend and not by
>>> pgAdmin III ?
>>
>>
>>
>> That's correct, everything in the message tab and in case of problems
>> in the status line is from the backend.
>
>
> Ok,
> Ricardo Pérez López (CCed) reported a strange behaviour about two days
> ago concerning error messages not displayed at all while using a
> es_ES@euro locale under debian. The detail of the bug can be found here:
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=257117
>
> The problem appears while playing with locales and trying to query a
> non existent table:
> select * from doesnotexist; in the SQL Query window.
>
> Here is where I am with it:
> a)
> put lc_messages=es_ES@euro in postgresql.conf
> export LC_ALL=POSIX ; /etc/init.d/postgresql restart
> open a new terminal without changing anything to you normal locale
> settings, launch pgadmin3 and retry your test... The error message
> should appear correctly in spanish.
> b)
> leave es_ES@euro in postgresql.conf then do this
> export LC_ALL=es_ES@euro ; /etc/init.d/postgresql restart
> open a new terminal without changing anything to you normal locale
> settings, launch pgadmin3 and retry your test... The error message
> *DOES NOT* appear correctly in spanish.
>
> What makes me think it is not a backend bug is that everything runs
> well if I do the same thing with psql (I mean I have the expected
> error message in Spanish). The problem seems to occur only in pgAdmin
> III.