14:13What's new with constraints in Postgres 18 | POSETTE: An Event for Postgres 2026
From the creator
PostgreSQL 18 introduced several important enhancements to constraint handling, including new capabilities and improved flexibility. Gülçin Yıldırım Jelínek (Xata) covers the changes in her talk “What's new with constraints in Postgres 18” at POSETTE: An Event for Postgres 2026. Abstract: PostgreSQL 18 introduces temporal keys, NOT ENFORCED constraints and promotes NOT NULL to a first-class constraint. Constraint handling for partitioned tables has also improved. In this session, we’ll walk through these changes with practical examples and finish with a sneak peek at what’s coming in PostgreSQL 19. Gülçin Yıldırım Jelínek started working with PostgreSQL in 2012. Over the years, she has contributed to the PostgreSQL community by organizing conferences, delivering talks and engaging as a dedicated community member. Gülçin got recognized as an official PostgreSQL Contributor. She currently works as Technical Product Manager at Xata. ► Video chapters: ⏩ 00:00 – Music & introduction ⏩ 00:37 – Agenda: temporal keys and constraint changes ⏩ 01:14 – What constraints are and why they matter ⏩ 03:50 – Overview of Postgres 18 constraint updates ⏩ 04:56 – Understanding temporal databases and time models ⏩ 07:04 – Semantics of time: valid time vs transaction time explained ⏩ 09:34 – Temporal queries and data modeling shift ⏩ 11:22 – Temporal primary keys and no-overlap rules ⏩ 12:50 – Booking example with temporal constraints ⏩ 15:41 – Temporal foreign keys and referential integrity ⏩
Published 2026-06-17 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.





