Michael Paquier wrote:> On Sat, May 30, 2015 at
11:47 AM, Peter Eisentraut wrote:
>> 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
On 30 May 2015 at 03:47, Peter Eisentraut 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.
>
It was deliberately omitted from the original INSTEAD OF triggers
patch because it
On Sat, May 30, 2015 at 11:47 AM, Peter Eisentraut 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?
>
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.
Similarly, the ALTER TABLE ... ENABLE RULE commands only allow acting on
tables, even though rules can also exist on views and materialized