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