Comment by GordonS
7 years ago
> And, as a fan of static typing, I can't help but cringe at the possibility of someone changing the constraints on the table without realizing that there are queries which implicitly depend on the old ones
When creating views and sprocs, SQL Server lets you mark them as 'schema bound', creating dependencies on the schema objects it uses.
Not sure if something like this exists in Postgres?
All views in PostgreSQL are schema bound, which is usually good but can be annoying at times.
Ah, I didn't know that!