Re: [HACKERS] rule system oddity

2005-01-05 Thread Jaime Casanova
--- Michael Fuhr <[EMAIL PROTECTED]> escribió: > On Tue, Jan 04, 2005 at 11:51:54PM -0600, Jaime > Casanova wrote: > > > create view vfoo as select oid, * from foo; > > ... > > create rule insrule as on insert to vfoo > > do instead > > insert into foo(id, name) values (new.id, > new.name); > >

Re: [HACKERS] rule system oddity

2005-01-04 Thread Michael Fuhr
On Tue, Jan 04, 2005 at 11:51:54PM -0600, Jaime Casanova wrote: > create view vfoo as select oid, * from foo; > ... > create rule insrule as on insert to vfoo > do instead > insert into foo(id, name) values (new.id, new.name); > ... > insert into vfoo values(1, 'test1'); > ERROR: invalid input sy