Ricardo just sent me an email where saying the problem also appears in psql:
a) leave lc_messages = '[EMAIL PROTECTED]'; export [EMAIL PROTECTED] ; /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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] in postgresql.conf then do this
export [EMAIL PROTECTED] ; /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.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
