another question i met during reviewing

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  

Responses

Browse pgsql-hackers by date

  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