This statement attempts to modify (insert, delete, or update) rows in a view which does not have an appropriate INSTEAD OF trigger defined. Starting with version 9.40, you can define an INSTEAD OF trigger on a view. Without an INSTEAD OF trigger, this view is not modifiable because it is based on a SELECT statement that joins two or more tables or that selects calculated values or literal values. (You can DELETE from a view that selects from a single table even if some calculated values are selected.) Direct the statement against the actual table on which the view is based or define an INSTEAD OF trigger on the view to make it modifiable.