question for patch "Automatically update view"
От | Unicron |
---|---|
Тема | question for patch "Automatically update view" |
Дата | |
Msg-id | 675345.98884.qm@web62403.mail.re1.yahoo.com обсуждение исходный текст |
Ответы |
Re: question for patch "Automatically update view"
|
Список | pgsql-hackers |
<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 />
В списке pgsql-hackers по дате отправления: