Re: question about log entry from trigger execution

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Susan Cassidy <scassidy(at)stbernard(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about log entry from trigger execution
Date: 2010-05-05 17:02:30
Message-ID: 5448.1273078950@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Susan Cassidy <scassidy(at)stbernard(dot)com> writes:
> I have a database I inherited with a number of triggers defined on various tables.
> One AFTER trigger, when executed, causes a database log entry with a "CONTEXT" entry, but no ERROR. I normally only see the CONTEXT entries when an ERROR occurs.

The CONTEXT is associated with the preceding LOG line, in this case.
It's not at all true that CONTEXT is only attached to ERROR --- it
applies to any level of log message.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pgsql 2010-05-05 17:06:11 Re: Please help me debug regular segfaults on 8.3.10
Previous Message Susan Cassidy 2010-05-05 16:48:09 question about log entry from trigger execution