Trace triggers

[Marek Lewczuk]

Hi,
I have a table with many triggers. Now, it can happen that in middle of
execution one of table's triggers there will be unknown error (like
"NEW" is not assigned yet) - is there a way to trace which trigger fired
this error ?

Thanks in advance.

ML



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

[url]http://archives.postgresql.org[/url]

[Terry Lee Tucker]

I don't know if there is some built in way of doing it, but we have
implemented the following in all our trigger code:

DECLARE
....
....
dbg BOOLEAN DEFAULT False; -- debug messages flag
BEGIN
IF dbg THEN
RAISE NOTICE ''% (%)'', TG_NAME, TG_OP;
END IF;

While developing triggers or a series of triggers, we turn that dbg flag on.
Then we can see what is happening.

On Thursday 13 January 2005 09:14 am, Marek Lewczuk saith:

> Hi,
> I have a table with many triggers. Now, it can happen that in middle of
> execution one of table's triggers there will be unknown error (like
> "NEW" is not assigned yet) - is there a way to trace which trigger fired
> this error ?
>
> Thanks in advance.
>
> ML
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> [url]http://archives.postgresql.org[/url]

__
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: [email]terry@esc1.com[/email]

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

[url]http://archives.postgresql.org[/url]

[Tom Lane]

Marek Lewczuk <newsy@lewczuk.com> writes:

> I have a table with many triggers. Now, it can happen that in middle of
> execution one of table's triggers there will be unknown error (like
> "NEW" is not assigned yet) - is there a way to trace which trigger fired
> this error ?

Use PG 7.4 or later, and look at the CONTEXT part of the error message.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend