Dynamic updates of fields in NEW in PL/pgSQL Today, on #postgresql on IRC, strk asked about updating fields in NEW record, in plpgsql, but where name of the field is in variable. After some time, he sent his question to hackers mailing ...

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 ...

On 14th of October Tome Lane committed new patch from Itagaki Tahahiro: Log Message: ----------- Support SQL-compliant triggers on columns, ie fire only if certain columns are named in the UPDATE's SET list.   Note: the schema of pg_trigger has not actually changed; we've just started to ...

another new, cool feature commited by tom lane: "Support statement-level ON TRUNCATE triggers." original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).