Learning PostgreSQL 11 - Third Edition

Triggers and updatable views

For views that are not automatically updatable, the trigger system can be used to make them updatable. The seller_account_information view, which shows the information about the seller account, is not automatically updatable because it has INNER JOIN:

CREATE OR REPLACE VIEW car_portal_app.seller_account_info AS   SELECT account.account_id, first_name, last_name, email, password, seller_account_id,     total_rank, number_of_advertisement, street_name, street_number, zip_code , city  FROM car_portal_app.account INNER JOIN    car_portal_app.seller_account ON (account.account_id = seller_account.account_id);

To verify that the preceding view, seller_account_information, is not updatable, we can check the information schema, ...