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: pgsql-general(at)postgresql(dot)org
Subject: Is there a way to add a detail message in a warning with pl/Python?
Date: 2013-01-29 13:03:34
Message-ID: 5107C8A6.6080202@sc.senai.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I build a function and added some warnings where the id of the affected
rows are inside it; and would be nice to put it into a detail, not in
the message, since pgbadger can group it and I can see clearly what is
wrong in my cluster.

I read the manual and tried something with no success:

plpy.warning('test', 'detail') -> output both values
plpy.warning({'message': 'test', 'detail': 'detail'}) -> output the dict
plpy.warning('test', detail='detail') -> fail

Am I missing something?

I would read the code, but I had no time right now...

Thanks,
--
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2013-01-29 13:03:39 Re: Optimizing select count query which often takes over 10 seconds
Previous Message Bartosz Dmytrak 2013-01-29 11:50:50 Fwd: Functions not visible in pg_stat_user_functions view