Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)

Hi,

Can anyone help me, on this one ?

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
À : pgadmin-support(at)postgresql(dot)org
Cc : guillaume(at)lelarge(dot)info
Envoyé le : Mardi, 9 Janvier 2007, 15h39mn 57s
Objet : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)

Hi All (and Guillaume),

So I have upgraded to the latest and shiny PGAdmin 1.6.2 ... and I still have the same problem I had in 1.6.1.

If I have a database set with UTF-8 character set then when I type the following (in the query tool window):
sdfhsdfj
I get:
ERREUR:
État SQL :42601
Caractère : 1

In a query tool with a database set with LATIN1 or SQL_ASCII characterset, I get:
ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj»
État SQL :42601
Caractère : 1

Which is what I would expect (at least till the PG syntax does not change ;-) ! ).

I do not have this problem with PG Admin 1.4.3, which will write:
ERREUR: erreur de syntaxe sur ou près de «sdfhsdfj» au caractère 1

Of course, you would have guessed from the error messages that I am in French locale for the client (Windows XP SP2) and for the Server (Ubuntu 6.06, PG 8.1).

Let me know if you need more info about this.

Cheers,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
À : pgadmin-support(at)postgresql(dot)org
Cc : guillaume(at)lelarge(dot)info
Envoyé le : Jeudi, 14 Décembre 2006, 16h33mn 25s
Objet : Re : Re : Re : [pgadmin-support] No text for error messages only numbers

Hi,

OK, I have found what the problem is !
My databases are in UTF8, with another charset (LATIN1, ...) that works fine.

And I have checked: pgAdmin III v 1.4.3 can display the error messages of a UTF8 database (as well as non UTF8).
So something got broken along the way !

Good luck fixing it.

Any estimates for the roll-out of 1.6.2 ?
(I have read the the particulary annoying bug of empty tables not being editable is fixed in 1.6.2)

Cheers,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Guillaume Lelarge <guillaume(at)lelarge(dot)info>
À : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Envoyé le : Vendredi, 8 Décembre 2006, 17h02mn 56s
Objet : Re: Re : Re : [pgadmin-support] No text for error messages only numbers

Laurent ROCHE a ecrit le 08/12/2006 17:01:
> Postgres is:
> "PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.0.gcc-opt (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)"
>
> And PgAdmin v 1.6.1 does not work when PgAdmin 1.4.3 does work.
>
> But, as I said in another message, strangely, on the same server, I do get error messages (with 1.6.1) with one database and no error message with the other ! ? !
> I am going to investigate a bit more to find out what are the differences between the databases (and narrow it down to simple example) , and I will post an update.
>

OK, thanks. Just keep me informed.

--
Guillaume.

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com

__________________________________________________
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités
http://mail.yahoo.fr Yahoo! Mail

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com