Thread: Re: AUTO_INCREMENT patch

Re: AUTO_INCREMENT patch

From
"Andrew Dunstan"
Date:
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
>