rule system oddity
| От | Jaime Casanova |
|---|---|
| Тема | rule system oddity |
| Дата | |
| Msg-id | 20050105055154.21717.qmail@web50004.mail.yahoo.com обсуждение исходный текст |
| Ответы |
Re: rule system oddity
|
| Список | pgsql-hackers |
Hi, i was doing some tests and found out this: create table foo (id serial not null primary key,name text not null ); NOTICE: CREATE TABLE will create implicit sequence "foo_id_seq" for serial column "foo.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo" i want the view show the oid of the row it shows: create view vfoo as select oid, * from foo; so far, so good... -- then i create this rule create rule insrule as on insert to vfoo do instead insert into foo(id, name) values (new.id, new.name); and try an insert insert into vfoo values(1, 'test1'); ERROR: invalid input syntax for integer: "test1" it seems like it's trying to insert into the oid column is that the intended behaviour? or is it a bug? (i think is the latter). if it's a bug? where (in the code) is the rule expanded? regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com
В списке pgsql-hackers по дате отправления: