v4.2.0 - constraints on views / materialized views
Thanks to sponsorship from ULTA.io, this release introduces support for defining constraints (e.g. foreign keys, primary keys, etc) via "smart comments". This means that VIEW
s and MATERIALIZED VIEW
s can now act a lot more like regular tables when viewed by PostGraphile - you can define a @primaryKey
for your view, or have a @foreignKey
that references another table (or another view!). You can also mark fields as @notNull
For more information, see the documentation:
The other change in this release is that we now surface a warning message if a foreign key constraint is skipped because it lacks an index and you're using --no-ignore-indexes
or ignoreIndexes: false
.