From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
---|---|
To: | "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: AUTO_INCREMENT patch |
Date: | 2003-08-03 02:12:34 |
Message-ID: | 008701c35964$b43e2880$6401a8c0@DUNSLANE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
OK, I read further and now understand. Sorry.
andrew
----- Original Message -----
From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-08-03 06:05:19 | working on release |
Previous Message | Andrew Dunstan | 2003-08-03 02:09:04 | Re: AUTO_INCREMENT patch |