Did you get a chance to look at this Guillaume? /D
Laurent ROCHE wrote: > Hi, > > Can anyone help me, on this one ? > > > Have fun, > [EMAIL PROTECTED] > The Computing Froggy > > ----- Message d'origine ---- > De : Laurent ROCHE <[EMAIL PROTECTED]> > À : pgadmin-support@postgresql.org > Cc : [EMAIL PROTECTED] > 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, > [EMAIL PROTECTED] > The Computing Froggy > > ----- Message d'origine ---- > De : Laurent ROCHE <[EMAIL PROTECTED]> > À : pgadmin-support@postgresql.org > Cc : [EMAIL PROTECTED] > 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, > [EMAIL PROTECTED] > The Computing Froggy > > > ----- Message d'origine ---- > De : Guillaume Lelarge <[EMAIL PROTECTED]> > À : Laurent ROCHE <[EMAIL PROTECTED]> > 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. > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend