Thread: Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)
Re : Still no text for error messages only numbers for 1.6.2 (aka the Saga continues)
From
Laurent ROCHE
Date:
Hi, Can anyone help me, on this one ? Have fun, 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 : 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) 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 ___________________________________________________________________________ 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
Did you get a chance to look at this Guillaume? /D Laurent ROCHE wrote: > Hi, > > Can anyone help me, on this one ? > > > Have fun, > 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 : 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) 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. > >
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Laurent Can you try this SET client_encoding TO 'LATIN9' before sending your query ? Christophe. P.S .You can send me your answer in french if you prefer ? Laurent ROCHE a écrit : > Hi, > > Can anyone help me, on this one ? > > > Have fun, > 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 : 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) 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. > > - -- Christophe Chauvet <christophe.chauvet@aznetwork.fr> AZNetwork -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) iD8DBQFFq7ZKMl/S4ZhUIzERApc6AKC9YjnE1LbaDHVi1GIObzwxbLLYiwCgmhDA UKUfpk9I61+9rGL6XsL6Y/c= =HIPu -----END PGP SIGNATURE-----
Dave Page a ecrit le 15/01/2007 17:46: > Did you get a chance to look at this Guillaume? > I already looked at this and wasn't able to reproduce it. I will try again tonight. Perhaps I missed something. Regards. -- Guillaume.