Rod Taylor wrote about using views for identity cols, thus: t=# create schema jboss t-# create view test as select * from data.test; CREATE SCHEMA t=# t=# create rule test_id_generate as on insert to jboss.test t-# do instead t-# insert into data.test (id, word) values (default, new.word); CREATE RULE t=# t=# insert into jboss.test (word) values ('hello'); INSERT 17347 1
The docs currently state that views are read-only. Is this no longer true? andrew ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings