I have a repeatable issue where on an update rule (attached to a view) not all of the statements are firing under certain conditions. There is no error but the rule does not seem to be completely going through the statements. I'm not sure if this is correct behavior reading the documentation but it smells funny. I confirmed the statements are not updating by inserting sql log statements in between the queries in the rule. Also, by converting the rule to a rule + sql function it works 100% correct every time. this is on postgresql 8.1.4 on windows xp. create or replace rule insert_fsv as on insert to frequency_service_view do instead ( insert into frequency_operation select new.table_name, new.frequency, old.code where new.set = true and old.set = false; delete from frequency_operation where table_name = old.table_name and frequency_operation.code = old.code and frequency_operation.frequency = new.frequency and new.set = false; update operation set code = new.code where code = old.code and old.code != new.code; ); merlin