Logon trigger in PostgreSQL
This post explains how this works and how such a LOGON/LOGIN trigger can be implemented and used in real life.
Broken foreign keys: how can that happen in PostgreSQL?
by
Laurenz Albe |
12.2023One of the fundamental requirements for a relational database is that the transaction system always maintains consistency. That means that […]
Using multiple triggers on the same table in PostgreSQL
What happens if you deploy many triggers on the very same PostgreSQL table? What order do the multiple triggers fire in?
Why are my PostgreSQL updates getting slower?
by
Laurenz Albe |
10.2022 Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]
Automatic partition creation in PostgreSQL
by
Laurenz Albe |
02.2022 Table partitioning is one of the best-liked features out of the more recent PostgreSQL developments. However, there is no […]
What to return from a PostgreSQL row level trigger?
by
Laurenz Albe |
04.2021 In this article, I'll talk about row level triggers, which are the most frequently used kind of triggers. I […]
PostgreSQL: How to write a trigger
UPDATED 2023: A trigger is a way to automatically respond to events. This is a tutorial on how to manage and program triggers in PostgreSQL.
Performance differences between normal and generic audit triggers
Performance differences between normal and generic audit triggers | PostgreSQL database | PostgreSQL trigger performance
Triggers to enforce constraints in PostgreSQL
by
Laurenz Albe |
04.2019 Sometimes you want to enforce a condition on a table that cannot be implemented by a constraint. In such […]
Rules or triggers to log bulk updates?
by
Laurenz Albe |
07.2018 Inspired by my co-worker's recent blog post, I decided to revisit the old question of rules vs. triggers and […]
