Query Exercise: Find Foreign Key Problems
Let’s say we’ve decided to implement foreign keys, and we need to find data that’s going to violate our desired keys. We’re going to use the Stack Overflow database, and…
Smart Postgres News and Techniques 2024 Vol 1
When picking a primary key for a table, you might pick a UUID, serial, or identity column. Laurenz Albe says you should default to using a bigint sequence, and explains…
Smart Postgres News and Techniques 2023 Vol 52
When you need to change a table, and we’re talking big changes like changing a column type, adding a constraint, or creating an index, you have to be careful if…