Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
