79594236

Date: 2025-04-26 17:55:11
Score: 1.5
Natty:
Report link

The error explicitly states that the view is not updatable because it references multiple tables/views. Even if view1 and view2 are updatable themselves, combining them with a FULL OUTER JOIN makes the top-level view non-updatable. check:

https://dba.stackexchange.com/questions/105957/how-do-i-make-this-postgres-view-that-performs-a-join-updatable

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: dadasese