question for patch "Automatically update view"

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? 

Responses

Browse pgsql-hackers by date

  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