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.klaver@xxxxxxxxxxx> 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@xxxxxxxxx> 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.klaver@xxxxxxxxxxx -- http://mitar.tnode.com/ https://twitter.com/mitar_m
