OK, I read further and now understand. Sorry.
andrew
----- Original Message -----
From: "Andrew Dunstan" <andrew@dunslane.net>
To: "PostgreSQL Development" <pgsql-hackers@postgresql.org>
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
>