Hello.
I enjoy using VIEWs. Often my views are updatable, either automatically (due to being a simple 1-table view, or due to a TRIGGER). Sometimes they are meant to be just read-only.
Is there any way to set a VIEW to be read-only -- specifically, can I do this for a view that is automatically updatable due to being simple?
The reason I want this: It will help me encode into my schema the distinction between views that are supposed to behave like full-fledged "subtypes" of a larger relation and need to be updatable, vs those that are merely a report / literally just a "view".
Thanks!
Ryan