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: | Raw Message | Whole Thread | 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 |