PostgreSQL Antipatterns: changing data bypassing triggers
Sooner or later, many encounter the need to make bulk edits to table records. I've already discussed how to do this effectively and how to avoid pitfalls. Today, I will touch upon the second aspect of bulk updates — the triggers that come into play. For instance, if there's a troublesome ON UPDATE trigger attached to the table where you need to make adjustments, it carries all the changes to […]
