Re: cannot set view triggers to replica

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: cannot set view triggers to replica
Date: 2015-06-05 16:07:46
Message-ID: 1338761162.5814911.1433520466946.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:> On Sat, May 30, 2015 at 11:47 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> 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 able to
> accept the command as well.

What would be a use case for disabling the _RETURN rule for a [ MATERIALIZED ] VIEW?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-06-05 16:20:12 Re: [CORE] Restore-reliability mode
Previous Message deavid 2015-06-05 16:07:36 Is it possible to have a "fast-write" Index?