1 files changed, 74 insertions, 4 deletions
diff --git a/src/pl/plpython/expected/plpython_trigger.out b/src/pl/plpython/expected/plpython_trigger.out
index 3192ff1d48..275d0f7439 100644
--- a/src/pl/plpython/expected/plpython_trigger.out
+++ b/src/pl/plpython/expected/plpython_trigger.out
@@ -294,11 +294,81 @@ NOTICE:  TD[table_schema] => public
 CONTEXT:  PL/Python function "trigger_data"
 NOTICE:  TD[when] => BEFORE
 CONTEXT:  PL/Python function "trigger_data"
+DROP TRIGGER show_trigger_data_trig_stmt on trigger_test;
+DROP TRIGGER show_trigger_data_trig_before on trigger_test;
+DROP TRIGGER show_trigger_data_trig_after on trigger_test;
+insert into trigger_test values(1,'insert');
+CREATE VIEW trigger_test_view AS SELECT * FROM trigger_test;
+CREATE TRIGGER show_trigger_data_trig
+INSTEAD OF INSERT OR UPDATE OR DELETE ON trigger_test_view
+FOR EACH ROW EXECUTE PROCEDURE trigger_data(24,'skidoo view');
+insert into trigger_test_view values(2,'insert');
+NOTICE:  TD[args] => ['24', 'skidoo view']
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[event] => INSERT
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[level] => ROW
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[name] => show_trigger_data_trig
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[new] => {'i': 2, 'v': 'insert'}
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[old] => None
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[relid] => bogus:12345
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_name] => trigger_test_view
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_schema] => public
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[when] => INSTEAD OF
+CONTEXT:  PL/Python function "trigger_data"
+update trigger_test_view set v = 'update' where i = 1;
+NOTICE:  TD[args] => ['24', 'skidoo view']
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[event] => UPDATE
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[level] => ROW
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[name] => show_trigger_data_trig
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[new] => {'i': 1, 'v': 'update'}
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[old] => {'i': 1, 'v': 'insert'}
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[relid] => bogus:12345
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_name] => trigger_test_view
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_schema] => public
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[when] => INSTEAD OF
+CONTEXT:  PL/Python function "trigger_data"
+delete from trigger_test_view;
+NOTICE:  TD[args] => ['24', 'skidoo view']
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[event] => DELETE
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[level] => ROW
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[name] => show_trigger_data_trig
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[new] => None
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[old] => {'i': 1, 'v': 'insert'}
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[relid] => bogus:12345
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_name] => trigger_test_view
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[table_schema] => public
+CONTEXT:  PL/Python function "trigger_data"
+NOTICE:  TD[when] => INSTEAD OF
+CONTEXT:  PL/Python function "trigger_data"
 DROP FUNCTION trigger_data() CASCADE;
-NOTICE:  drop cascades to 3 other objects
-DETAIL:  drop cascades to trigger show_trigger_data_trig_before on table trigger_test
-drop cascades to trigger show_trigger_data_trig_after on table trigger_test
-drop cascades to trigger show_trigger_data_trig_stmt on table trigger_test
+NOTICE:  drop cascades to trigger show_trigger_data_trig on view trigger_test_view
+DROP VIEW trigger_test_view;
+delete from trigger_test;
 --
 -- trigger error handling
 --