On Sat, May 30, 2015 at 11:47 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> It appears to be an omission that ALTER TABLE ... ENABLE TRIGGER and
> similar commands don't allow acting on views, even though we now have
> triggers on views.
True, now isn't it something that should be as well part of ALTER VIEW?
> Similarly, the ALTER TABLE ... ENABLE RULE commands only allow acting on
> tables, even though rules can also exist on views and materialized views.
I think that ALTER VIEW and ALTER MATERIALIZED VIEW should be able to
accept the command as well.
> Attached is a sample patch. It appears we don't have any regression
> tests for this.
This sounds like a mandatory condition for this patch.
--
Michael