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

[Raphaël Enrici <blacknoz(at)club-internet(dot)fr>]

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

a) leave lc_messages = 'es_ES(at)euro'; export LC_ALL=es_ES(at)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(at)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(at)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(at)euro in postgresql.conf then do this
> export LC_ALL=es_ES(at)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.