On Tue, Jan 29, 2013 at 8:03 PM, DANIEL CRISTIAN CRUZ
<daniel.c...@sc.senai.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 <stu...@stuartbishop.net> http://www.stuartbishop.net/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
