Scott Marlowe <scott.marl...@gmail.com> writes:
> On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula <phoenix.ki...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
