Mark Wong: PDXPUG Septemter 8, 2026, MeetUp: Migrating to a Temporal Schema

Please note different time and location this month at UpStart Collective at the U.S. Bancorp Tower (a.k.a. Big Pink ). Please RSVP on MeetUp . Tuesday September 8, 2026 from 6:30pm to 8:30pm. Coinciding with devopsdays Portland, OR , Sept 8-10, 2026. In v18, Postgres got temporal primary keys, unique constraints, and foreign keys (with `NO ACTION`). Hopefully in v19 we’ll have `UPDATE/DELETE FOR PORTION OF`. So it’s a good time to start thinking about migrating your schema to a temporal structure. Some advantages include: – Easier queries and joins to reconstruct historical data. – A better wa