[GENERAL] How do I find a trigger function that is raising notices?

2013-09-26 Thread Rob Richardson
Greetings! I've got a query that is behaving strangely, but that's not the reason for this question. The update results in a trigger being fired, but I don't know which one. I thought I disabled all of the triggers on the table being updated. So, I wanted to find the trigger function that

Re: [GENERAL] How do I find a trigger function that is raising notices?

2013-09-26 Thread bricklen
On Thu, Sep 26, 2013 at 9:04 AM, Rob Richardson rdrichard...@rad-con.comwrote: Select * from pg_proc where lower(prosrc) = '%target_string%' A slight revision should work: select distinct proname from pg_proc where prosrc ilike '%target_string%';

Re: [GENERAL] How do I find a trigger function that is raising notices?

2013-09-26 Thread Rob Richardson
Cc: pgsql-general Subject: Re: [GENERAL] How do I find a trigger function that is raising notices? On Thu, Sep 26, 2013 at 9:04 AM, Rob Richardson rdrichard...@rad-con.commailto:rdrichard...@rad-con.com wrote: Select * from pg_proc where lower(prosrc) = '%target_string%' A slight revision should