Re: Tracking SQLs that update data - Mailing list pgsql-general

From Tom Lane
Subject Re: Tracking SQLs that update data
Date
Msg-id 26246.1276572609@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tracking SQLs that update data  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
>> My question: how can I set up a "RULE" so that when a specific column
>> is updated, a separate table also logs which update SQL was issued?

> It's far easier to adjust the logging.

Or, if you're worried about actions from functions, use a trigger to do
the logging.  There are approximately no cases where a rule is really
better than a trigger :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Adam Alkins
Date:
Subject: Re: Does enterprisedb.com down?
Next
From: "M. Bashir Al-Noimi"
Date:
Subject: Re: Does enterprisedb.com down?