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