Problem inserting into a view

[rski]

I deleted all the rule and created a new one and when execute insert statement it is showing me the same error......

I believe u created only this one rule (and deleted all the others)

CREATE RULE emp2_ins AS ON INSERT TO empp
DO INSTEAD
INSERT INTO employee VALUES (NEW.name,now() ,NEW.id);

What does \d empp show

[priyan]

I believe u created only this one rule (and deleted all the others)

CREATE RULE emp2_ins AS ON INSERT TO empp
DO INSTEAD
INSERT INTO employee VALUES (NEW.name,now() ,NEW.id);

What does \d empp show

Hi
Thank u very much......It is now working correctly...... Once again thanks a lot for patiently answering all my questions and clearing my doubts......