Thread: Trace triggers
View Single Post

   
  #2 (permalink)  
Old 04-08-2008, 06:50 PM
Tom Lane
 
Posts: n/a
Default Re: Trace triggers

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

Reply With Quote