December 23rd, 2009 by depesz | Tags: cond, conditional, conditions, constraint, deferrable, deferred, pg85, pg90, postgresql, triggers | No comments »
On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be checked to determine whether the trigger should be fired. For BEFORE triggers this is mostly ...
August 11th, 2009 by depesz | Tags: constraint, deferrable, deferred, pg85, pg90, postgresql, primary key, unique | 6 comments »
On 29th of July ( I know, there is a long backlog in waiting for 8.5 series. I'm working on it :), Tom Lane committed patch by Dean Rasheed: Support deferrable uniqueness constraints. The current implementation fires an AFTER ROW trigger for ...
