[GENERAL] Create trigger on Materialized View?

2016-03-31 Thread Matthew Syphus
I would like a trigger on a materialized view. Is this possible? I have tried both an INSTEAD OF and BEFORE trigger with no luck. It responds with: "project_milestone_mv" is not a table or view. It is absolutely present and spelled correctly. It is the same with or without the schema qualificat

Re: [GENERAL] Create trigger on Materialized View?

2016-03-31 Thread Matthew Syphus
I was afraid of that. Any idea if it is a technical or resource limitation? In other words, is such functionality impossible, undesirable, anticipated, or in the works? From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Thursday, March 31, 2016 10:38 AM To: Matthew Syphus Cc