This question appeared couple of times on irc, so I figured I can do a blogpost about it.

Another one missed, quite a long time ago, too..: On 4th of November 2016, Kevin Grittner committed patch: Implement syntax for transition tables in AFTER triggers. This is infrastructure for the complete SQL standard feature. No support is included at this point for ...

Some time ago someone on irc asked about creating fast counters for something (banners I think). I talked with her (him?) about it, but figured, I can as well write a blogpost, so others can use it too.

On 7th of December, Simon Riggs committed patch: Event Trigger for table_rewrite Generate a table_rewrite event when ALTER TABLE attempts to rewrite a table. Provide helper functions to identify table and reason. Intended use case is to help assess or to react to schema changes that ...

On 11th of December, Peter Eisentraut committed patch: PL/Perl: Add event trigger support From: Dimitri Fontaine

On 20th of July, Robert Haas committed patch: Make new event trigger facility actually do something. Commit 3855968f328918b6cd1401dd11d109d471a54d40 added syntax, pg_dump, psql support, and documentation, but the triggers didn't actually fire. With this commit, they now do. This is still a pretty basic ...

On 25th of January, Alvaro Herrera committed patch: Add pg_trigger_depth() function This reports the depth level of triggers currently in execution, or zero if not called from inside a trigger. No catversion bump in this patch, but you have to initdb if you want access ...

Some time ago I wrote about getting fast pagination. While fast, it had some problems which made it unusable for some. Specifically - you couldn't get page count, and easily jump to page number N. I did some thinking on the ...

On 10th of October, Tom Lane committed patch by Deal Rasheed, which adds triggers on views: Support triggers on views.   This patch adds the SQL-standard concept of an INSTEAD OF trigger, which is fired instead of performing a physical insert/update/delete. The trigger function ...

On 28th of July, Simon Riggs committed patch which: Log Message: ----------- Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions. Avoid hard-coding lockmode used for many altering DDL commands, allowing easier future changes of lock levels. Implementation of initial analysis ...