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

From Mitar
Subject Re: Watching for view changes
Date
Msg-id CAKLmikMsXV+bAP-Mk7MphwsPhtkKZGJ4iGOQFE8pkMaDcv3uXQ@mail.gmail.com
Whole thread Raw
In response to Re: Watching for view changes  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Watching for view changes
List pgsql-general
Hi!

Thanks. Care for a link or at least thread subject?

Also, Googling around this seems a pretty popular request. I am quite
surprised that there is not something out-of-box available for this,
efficient and scalable.


Mitar

On Thu, Dec 20, 2018 at 7:33 AM Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 12/20/18 3:17 AM, Mitar wrote:
> > Hi!
> >
> > I am trying to see how I could use NOTIFY/LISTEN to watch changes of a
> > complicated SELECT query which spans multiple tables. Ideally, I would
> > like to leave to PostgreSQL to determine when some data (and which
> > data) in the result of the SELECT query has changed. So I am thinking
> [snip]
>
> There was a LONG thread on this list a few months ago about monitoring for
> DDL changes.  It should prove helpful (or cause you to despair).
>
>
> --
> Angular momentum makes the world go 'round.
>


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


pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Watching for view changes
Next
From: Adrian Klaver
Date:
Subject: Re: Watching for view changes