question for patch "Automatically update view"
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?
On Mon, Nov 10, 2008 at 8:27 PM, Unicron <ssmei_2000@yahoo.com> wrote:
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
AFAIR, this patch only supports SQL92 so only views based on single
tables are supported...
There isn't a message indicating that the view will not be updatable?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157