December 11th, 2012 by depesz | Tags: automatic, delete, insert, pg93, postgresql, rule, rules, update, view, views, writable | 4 comments »
On 8th of December, Tom Lane committed patch: Support automatically-updatable views. This patch makes "simple" views automatically updatable, without the need to create either INSTEAD OF triggers or INSTEAD rules. "Simple" views are those classified as updatable according to SQL-92 rules. The ...
June 15th, 2010 by depesz | Tags: benchmark, comparison, opinion, postgresql, rule, rules, trigger, triggers | 26 comments »
Every now and then there is someone on IRC, mailing lists, or private contact which asks about rules. My answer virtually always is: don't use rules. If you think that they solve your problem, think again. Why?
