<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Here is another example
fortesting "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? <br /><br />Thanks<br /><br />postgres=# create view
old_customeras<br />postgres-# select name,<br />postgres-# age,<br />postgres-# city<br />postgres-#
fromcustomer<br />postgres-# where age > 30<br />postgres-# with check option;<br />NOTICE: CREATE VIEW will create
implicitINSERT/UPDATE/DELETE rules<br />postgres=# insert into old_customer values ('Kalley', 43, 'Kava');<br />INSERT
01<br />postgres=# insert into old_customer values ('Kalley', 21, 'loppe');<br />INSERT 0 1<br />postgres=# select *
fromcustomer;<br /> Jim | 25 | WDC <br /> Kim | 34 |
Pet <br /> Lottery | 75 | Polley <br /> Kalley | 43 |
Kava <br /> Kalley | 21 | loppe <br />postgres=# select * from
old_customer;<br/> Kim | 34 | Pet <br /> Lottery | 75 |
Polley <br /> Kalley | 43 | Kava <br />postgres=# insert into old_customer
values('Mathaa', 20, 'loaa');<br />INSERT 0 1<br />postgres=# select * from old_customer;<br /> Kim |
34| Pet <br /> Lottery | 75 | Polley <br /> Kalley | 43 |
Kava <br /><br /><br /></td></tr></table><br />