It works fine if you insert into the view:
=# INSERT INTO speedv VALUES (1, 'test', 100); INSERT 0 1 =# SELECT * FROM alarm; name | id | type | init | fired | t_end | t_user ------+----+-------+----------------------------+-------+-------+-------- test | 0 | SPEED | 2013-07-30 18:08:01.006979 | | | (1 row) =# SELECT * FROM car; id | type | speed ----+------+------- (0 rows) =# SELECT * FROM speedv; id | type | speed ----+------+------- (0 rows) -- * * Beena Emerson