Richard Huxton <dev@xxxxxxxxxxxx> writes: > Steve Crawford wrote: >> I'm having trouble understanding something I saw in my data from >> yesterday involving an inconsistency between values in a table and its >> associated rule-updated log table. >> >> For application debugging purposes (effectiveness of web double-submit >> suppression) we have a rule that creates an entry in a log table >> whenever the table we are watching is updated: > Ah, I think you'll find you don't. You have a rule that looks at first > glance like it *should* add an entry to your log table. We'd have to see the original query (the one the rule acted on) to be sure, but I suspect Richard's diagnosis is correct. > For inserting to a log table you'll want a trigger. +1 ... triggers are way less likely to do strange things. 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
