From: | Unicron <ssmei_2000(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | another question i met during reviewing |
Date: | 2008-11-11 03:40:29 |
Message-ID: | 192624.66233.qm@web62403.mail.re1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Here is another example for testing "Automatic update view", seems that "check option" doesn't work, i am not sure any other things i need to do, or it is a bug for the patch, anyone give me a help?
Thanks
postgres=# create view old_customer as
postgres-# select name,
postgres-# age,
postgres-# city
postgres-# from customer
postgres-# where age > 30
postgres-# with check option;
NOTICE: CREATE VIEW will create implicit INSERT/UPDATE/DELETE rules
postgres=# insert into old_customer values ('Kalley', 43, 'Kava');
INSERT 0 1
postgres=# insert into old_customer values ('Kalley', 21, 'loppe');
INSERT 0 1
postgres=# select * from customer;
Jim | 25 | WDC
Kim | 34 | Pet
Lottery | 75 | Polley
Kalley | 43 | Kava
Kalley | 21 | loppe
postgres=# select * from old_customer;
Kim | 34 | Pet
Lottery | 75 | Polley
Kalley | 43 | Kava
postgres=# insert into old_customer values ('Mathaa', 20, 'loaa');
INSERT 0 1
postgres=# select * from old_customer;
Kim | 34 | Pet
Lottery | 75 | Polley
Kalley | 43 | Kava
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-11-11 03:55:28 | Re: typedefs for indent |
Previous Message | ITAGAKI Takahiro | 2008-11-11 03:28:20 | Re: autovacuum and reloptions |