*** /home/postgres/pgsql.viewupdate/src/test/regress/expected/view_update.out Thu Jan 22 02:17:54 2009 --- /home/postgres/pgsql.viewupdate/src/test/regress/results/view_update.out Thu Jan 22 02:25:13 2009 *************** *** 40,46 **** INSERT INTO vutestv3 (a, b) VALUES (6, 'six'); INSERT INTO vutestv4 VALUES (7, 'seven'); -- ok, but would be check option issue INSERT INTO vutestv5 VALUES (8); -- fail ! ERROR: view is not insertable into HINT: You need an unconditional ON INSERT DO INSTEAD rule. SELECT * FROM vutest1; a | b --- 40,46 ---- INSERT INTO vutestv3 (a, b) VALUES (6, 'six'); INSERT INTO vutestv4 VALUES (7, 'seven'); -- ok, but would be check option issue INSERT INTO vutestv5 VALUES (8); -- fail ! ERROR: view is not updatable HINT: You need an unconditional ON INSERT DO INSTEAD rule. SELECT * FROM vutest1; a | b ======================================================================