OK, I read further and now understand. Sorry. andrew
----- Original Message ----- From: "Andrew Dunstan" <[EMAIL PROTECTED]> To: "PostgreSQL Development" <[EMAIL PROTECTED]> Sent: Saturday, August 02, 2003 10:09 PM Subject: Re: [HACKERS] AUTO_INCREMENT patch > > 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 8: explain analyze is your friend