Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/29/2013 05:03 AM, DANIEL CRISTIAN CRUZ 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?

Why not:

DO $$
    plpy.warning('test, detail')
$$ LANGUAGE plpythonu;

In log:

WARNING:  test, detail


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

Thanks,



--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux