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

Bug#257117 Re: Error messages in SQL Query window

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: Bug#257117 Re: Error messages in SQL Query window
Date: 2004-07-03 09:03:18
Message-ID: 40E67656.8020208@club-internet.fr (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.

I've tried a recent snapshot with no luck. Nothing particular in 
pgAdmin3 logs.

It seems something is broken somewhere but I can't discover what and 
where. Can someone reproduce this on another distro ? Any further idea ?

Regars,
Raphaël

In response to

Responses

pgadmin-hackers by date

Next:From: Raphaël EnriciDate: 2004-07-03 09:40:34
Subject: Re: Bug#257117 Re: Error messages in SQL Query
Previous:From: Andreas PflugDate: 2004-07-03 07:14:13
Subject: Re: Error messages in SQL Query window

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