What's new with constraints in Postgres 18

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.