Re: Trace triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: Trace triggers
Date
Msg-id 9431.1105631598@sss.pgh.pa.us
Whole thread Raw
In response to Trace triggers  (Marek Lewczuk <newsy@lewczuk.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: vacuum vs open transactions
Next
From: Csaba Nagy
Date:
Subject: Re: [HACKERS] Much Ado About COUNT(*)