I got a problem when reviewing patch "Automatically update view", the code can
be built and executed successfully, but when i tried the eaxmple below, it
seemed that the patch didn't work
create view v_name_account
as
select customer.name,
customer.age,
customer.city,
depositor.account_number
from customer,
depositor
where customer.name = depositor.name
with CHECK OPTION;
insert into v_name_account values ('Jim', 23, 'WDC', 'A-100');
ERROR: cannot insert into a view
HINT: You need an unconditional ON INSERT DO INSTEAD rule.
^
insert into v_name_account (name, age, city) values ('Jim', 23, 'WDC');
ERROR: cannot insert into a view
HINT: You need an unconditional ON INSERT DO INSTEAD rule.
Are there any other things i need to do for testing the patch?
