<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">I got a problem when
reviewingpatch "Automatically update view", the code can be built and executed successfully, but when i tried the
eaxmplebelow, it seemed that the patch didn't work<br /><br />create view v_name_account<br />as<br /> select
customer.name,<br/> customer.age,<br /> customer.city,<br /> depositor.account_number<br
/> from customer,<br /> depositor<br /> where customer.name = depositor.name<br /> with CHECK
OPTION;<br/><br />insert into v_name_account values ('Jim', 23, 'WDC', 'A-100');<br />ERROR: cannot insert into a
view<br/>HINT: You need an unconditional ON INSERT DO INSTEAD rule.<br /> ^<br
/>insertinto v_name_account (name, age, city) values ('Jim', 23, 'WDC');<br />ERROR: cannot insert into a view<br
/>HINT: You need an unconditional ON INSERT DO INSTEAD rule.<br /><br />Are there any other things i need to do for
testingthe patch? <br /></td></tr></table><br />
