Thread: BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"

The following bug has been logged online:

Bug reference:      5216
Logged by:          Henrik Pestano
Email address:      hpestano@uci.cu
PostgreSQL version: 8.4.1
Operating system:   Ubuntu 9.10
Description:        pgFouine 1.1 not working correctly, when LC_MESSAGES is
"es_ES.UTF-8"
Details:

I have a problem with the parameter LC_MESSAGES, where its value is
es_ES.UTF-8 (Spanish), the pgFouine 1.1 not work correctly, because csvlog
generates a column "duración: 0138 ms sentencia: SELECT format_type (oid,
54) as typname pg_type FROM WHERE oid = 1043" and pgFouine not understand
the words "duración" and "sentencia". This information can be in two
columns.

Henrik,

On Fri, Nov 27, 2009 at 4:15 AM, Henrik Pestano <hpestano@uci.cu> wrote:
> I have a problem with the parameter LC_MESSAGES, where its value is
> es_ES.UTF-8 (Spanish), the pgFouine 1.1 not work correctly, because csvlog
> generates a column "duraci=F3n: 0138 ms sentencia: SELECT format_type (oi=
d,
> 54) as typname pg_type FROM WHERE oid =3D 1043" and pgFouine not understa=
nd
> the words "duraci=F3n" and "sentencia". This information can be in two
> columns.

Please note that pgsql-bugs mailing list is for PostgreSQL bugs only.

pgFouine doesn't support lc_message other than english. It's usually
considered a good practice to keep your logs in english as it's far
easier to find useful information on the internet with a log message
in english.

I suppose you could use a sed line to translate your logs before
analyzing them with pgFouine.

--=20
Guillaume

On Fri, Nov 27, 2009 at 2:11 AM, Guillaume Smet
<guillaume.smet@gmail.com> wrote:
> Henrik,
>
> On Fri, Nov 27, 2009 at 4:15 AM, Henrik Pestano <hpestano@uci.cu> wrote:
>> This information can be in two columns.
>
> Please note that pgsql-bugs mailing list is for PostgreSQL bugs only.
>

i think what Henrik was proposing is change postgresql's csv format to
store the duration and statements values in different columns. Then,
pgFouine will have no problem identifying those values no matter the
language.

i know i agree with the idea, is very ugly to be writing: " like
'duration: %' instead of simply 'duration >=3D '

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Guillaume Smet escreveu:
> pgFouine doesn't support lc_message other than english.
>
What about adding a translation table in pgFouine to catch those cases too?


--
  Euler Taveira de Oliveira
  http://www.timbira.com/

Guillaume Smet escribió:
> Henrik,
>
> On Fri, Nov 27, 2009 at 4:15 AM, Henrik Pestano <hpestano@uci.cu> wrote:
> > I have a problem with the parameter LC_MESSAGES, where its value is
> > es_ES.UTF-8 (Spanish), the pgFouine 1.1 not work correctly, because csvlog
> > generates a column "duración: 0138 ms sentencia: SELECT format_type (oid,
> > 54) as typname pg_type FROM WHERE oid = 1043" and pgFouine not understand
> > the words "duración" and "sentencia". This information can be in two
> > columns.
>
> Please note that pgsql-bugs mailing list is for PostgreSQL bugs only.

Well, it begs the question: why are those spilled out as translated
words and not as their own columns?  It can be construed as a Postgres
bug.

(As a note, I suggested Henrik to report this here for this reason).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.