I have a mixed love/hate relationship with tests. I hate writing them. I hate remembering to add them when I'm in the zone, and application code is flowing freely from the tips of my fingers. But when I do add them, I ...

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?

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