question for patch "Automatically update view"

Started by Unicronabout 17 years ago2 messages
#1Unicron
ssmei_2000@yahoo.com

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? 

#2Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: Unicron (#1)
Re: question for patch "Automatically update view"

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