Breaking your PostgreSQL database with bad CHECK constraints
by
Laurenz Albe |
03.2023I am on a spree! After writing about breaking your database and transaction ID wraparound, here I am writing about […]
A unique constraint where NULL conflicts with everything
by
Laurenz Albe |
01.2023 I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]
Primary Keys vs. UNIQUE Constraints in PostgreSQL
What primary keys and UNIQUE constraints do: Both features create an index, but what makes a primary key different from a unique constraint?
PostgreSQL: Useful new data types - CREATE DOMAIN
UPDATED 08.05.2023 How to create useful new data types with CREATE DOMAIN in PostgreSQL | Advanced server side check constraints
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 […]
