another question i met during reviewing
От | Unicron |
---|---|
Тема | another question i met during reviewing |
Дата | |
Msg-id | 192624.66233.qm@web62403.mail.re1.yahoo.com обсуждение исходный текст |
Ответы |
Re: another question i met during reviewing
|
Список | pgsql-hackers |
<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 />
В списке pgsql-hackers по дате отправления: