Re: Is there a way to add a detail message in a warning with pl/Python?

From: DANIEL CRISTIAN CRUZ <daniel(dot)cruz(at)sc(dot)senai(dot)br>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a way to add a detail message in a warning with pl/Python?
Date: 2013-01-30 10:49:56
Message-ID: 5108FAD4.1060405@sc.senai.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 29/01/2013 17:30, Adrian Klaver escreveu:
> Why not:
>
> DO $$
> plpy.warning('test, detail')
> $$ LANGUAGE plpythonu;
>
> In log:
>
> WARNING: test, detail
>

Because pgBadger doesn't use it this way:

http://dalibo.github.com/pgbadger/example.html#NormalizedErrorsMostFrequentReport

I read the code yesterday, and didn't find how to get a detail through
it. Maybe my C knowledge is somewhat broken...

--
Daniel Cristian Cruz
Unidade de Tecnologia da Informação

Sistema FIESC
Rod. Admar Gonzaga, 2765 - Itacorubi - 88034-001 - Florianópolis - SC
Fone (48) 3239-1422 - e-mail: daniel(dot)cruz(at)sc(dot)senai(dot)br
site: http://www.sistemafiesc.org.br

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wolfgang 2013-01-30 11:08:05 Optimizing query?
Previous Message Neil Worden 2013-01-30 08:58:27 naming of wal-archives