Month: July 2016
Inheritance – One more reason to love PostgreSQL
After doing full-time PostgreSQL consulting for over 16 years now, I actually don’t remember a time without inheritance anymore. Of course things have improved over time, but in my head it has always been there, and it has always just worked as expected. After so many years, I still love this feature, because it offers […]
Read more
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE keyword. This feature is not very well known. However, people can use it to implement highly sophisticated constraints which are very hard to do on the application level. In a way, “exclusion constraints” are “beyond […]
Read more