Re: Watching for view changes - Mailing list pgsql-general

From Mitar
Subject Re: Watching for view changes
Date
Msg-id CAKLmikN=J+96wDX_PX1CGnKo9gK5=jVpR+Tbn06dd5gcnC3fqg@mail.gmail.com
Whole thread Raw
In response to Re: Watching for view changes  (George Neuner <gneuner2@comcast.net>)
List pgsql-general
Hi!

On Fri, Dec 21, 2018 at 11:10 PM George Neuner <gneuner2@comcast.net> wrote:
> A materialized view IS exactly such a deliberate cache of results from
> applying a view.  It is a real table that can be monitored for changes
> using INSERT, UPDATE and/or DELETE triggers.

Are you sure one can use triggers on a materialized view? I am getting:

"my_materialized_view" is not a table or view

as an error when I am trying to create a trigger on materialized view.


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m


pgsql-general by date:

Previous
From: Mitar
Date:
Subject: Determine in a trigger if UPDATE query really changed anything
Next
From: George Neuner
Date:
Subject: Re: Watching for view changes