Hi All (and Guillaume),
Happy new year to all ... with less crazy bugs for everyone than in 2006 (and that's including me ... please).
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 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 de 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)
andfor the Server (Ubuntu 6.06, PG 8.1).
Let me know if you need more info about this.
Cheers,
L@u
The Computing Froggy
----- Message d'origine ----
De : Laurent ROCHE <laurent_roche@yahoo.com>
À : pgadmin-support@postgresql.org
Cc : guillaume@lelarge.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@u
The Computing Froggy
----- Message d'origine ----
De : Guillaume Lelarge <guillaume@lelarge.info>
À : Laurent ROCHE <laurent_roche@yahoo.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
databaseand 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
tosimple 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