Re: Watching for view changes

Hi!

Ah, that was a thread about table changes. I am interested in data
changes (results from a query).

Thanks.

Mitar

On Thu, Dec 20, 2018 at 8:01 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 12/20/18 7:54 AM, Mitar wrote:
> > Hi!
> >
> > Thanks. Care for a link or at least thread subject?
>
> https://www.postgresql.org/message-id/CA%2BFnnTxqScf6mDw_7HLMfu7YTagPrsYUw-bc%3DOKsBQ0TqprvEA%40mail.gmail.com
>
> >
> > 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(at)gmail(dot)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.
> >>
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com

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