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

On Tue, Jan 29, 2013 at 8:03 PM, DANIEL CRISTIAN CRUZ
<daniel(dot)cruz(at)sc(dot)senai(dot)br> wrote:
> 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...

You might be able to get it for errors by raising plpy.SPIError(error,
detail), but that doesn't help for warnings. I think for warnings you
would need to write a helper in PL/pgSQL or similar and use it to log
the warnings using plpy.prepare/plpy.execute.

--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/