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

Reply via email to