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.