Matthew Schumacher <matt.s@xxxxxxxxxxxxx> writes: > I'm having trouble getting the rule system to work on updates that do > not match the where clause. You did not say what you mean by "doesn't work", but what I suspect you are getting bit by is that ON UPDATE rules fire before the original query is done. By the time the original query executes, you've inserted a row into accounting_tab and so its added condition fails. regards, tom lane
