PostgreSQL - Views and Materialized Views
You have a view defined as CREATE VIEW emp_view AS SELECT id, name FROM employees WHERE active = true; You want to ensure updates through this view only affect active employees. What is the best way?
You have a view defined as CREATE VIEW emp_view AS SELECT id, name FROM employees WHERE active = true; You want to ensure updates through this view only affect active employees. What is the best way?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand WITH CHECK OPTION
This option restricts updates and inserts through the view to rows visible in the view.Step 2: Apply to the scenario
Adding WITH CHECK OPTION ensures only active employees can be updated via the view.Final Answer:
Add WITH CHECK OPTION to the view definition. -> Option BQuick Check:
WITH CHECK OPTION enforces view row conditions on updates [OK]
Quick Trick: Use WITH CHECK OPTION to restrict updates in views [OK]
Common Mistakes:
- Removing WHERE clause loses filtering
- Assuming triggers are always needed
- Confusing materialized views with update control
Master "Views and Materialized Views" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes