Skip site navigation (1) Skip section navigation (2)

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

From: Raphaël Enrici <blacknoz(at)club-internet(dot)fr>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>,ricpelo(at)hotmail(dot)com
Subject: Re: Bug#257117 Re: Error messages in SQL Query
Date: 2004-07-03 09:40:34
Message-ID: 40E67F12.8020201@club-internet.fr (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.



In response to

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2004-07-03 09:46:06
Subject: Re: Bug#257117 Re: Error messages in SQL Query
Previous:From: Raphaël EnriciDate: 2004-07-03 09:03:18
Subject: Bug#257117 Re: Error messages in SQL Query window

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group