about RULES

Hi all,

I have a question about rules. I create a rule to insert data into a
view that works fine,
but when I add a row to the view, PostgreSQL replies INSERT 0 0 if the
row is added and it replies
INSERT oid# 1 if the row is not added.
I have the same behavior with RULES on UPDATE and on DELETE.

Here the example:

create rule "_RIT_vista" as on insert to vista
where new.job='SALESMAN'
do instead
insert into emp (empno,ename,job) values
(new.empno,new.ename,new.job);
CREATE

insert into vista values ('8900','MANUEL','SALESMAN');
INSERT 0 0 <<<<<<<<<<------------------------- Why it replies
INSERT 0 0 if it adds the row ?
^^^^^^^^^^^

select * from vista;
empno|ename |job
-----+----------+------------
8900|MANUEL |SALESMAN
(1 row)

insert into vista values ('8901','JOSE','PROGRAMMER');
INSERT 144991 1 <<<<<<<<<------------------------- Why it replies
INSERT oid 1 if it adds no row?
^^^^^^^^^^^^^^^

select * from vista;
empno|ename |job
-----+----------+------------
8900|MANUEL |SALESMAN
(1 row)

select oid,* from emp;
oid|ename |empno|job |hiredate|sal|comm|deptno|level|mgr
------+----------+-----+------------+--------+---+----+------+-----+---
144990|MANUEL | 8900|SALESMAN | | | | | |
(1 row)

Any ideas ?

-Jose'-