all-things-risingwave
Can I add a primary key to a view?
I saw a table type case
ji
jie
Asked on May 25, 2022
- In general, it is not recommended to manually specify a primary key for views.
- Views are derived from base tables, and there is no guarantee that the view will always satisfy the manually specified integrity constraint.
- RisingWave internally derives a primary key for materialized views.
- Consider exporting this feature to provide users with more convenient access to the data in materialized views.
May 26, 2022Edited by