| From: | Unicron <ssmei_2000(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | question for patch "Automatically update view" |
| Date: | 2008-11-11 01:27:57 |
| Message-ID: | 675345.98884.qm@web62403.mail.re1.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-11 02:46:05 | Re: Patch for ISO-8601-Interval Input and output. |
| Previous Message | Lawrence, Ramon | 2008-11-11 01:01:23 | Re: WIP: Hash Join-Filter Pruning using Bloom Filters |