Re: AUTO_INCREMENT patch - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: AUTO_INCREMENT patch
Date
Msg-id 008701c35964$b43e2880$6401a8c0@DUNSLANE
Whole thread Raw
List pgsql-hackers
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
>



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: AUTO_INCREMENT patch
Next
From: "Andrew Dunstan"
Date:
Subject: Re: AUTO_INCREMENT patch